I have facing the issue in SAX Parsing like i have got the xml and the xml structure is like below.

<?xml version="1.0" encoding="UTF-8" ?>
- <Customers>
- <Customer>
<CustName>M.T.C ALUPACK <CustName>
<CustId>06684209932</CustId>
<CountryCode>BH</CountryCode>
<BranchCode>06684</BranchCode>
<AccountNbrs />
</Customer>
- <Customer>
<CustName>AL HASSANAIN CO.WLL</CustName>
<CustId>06684210088</CustId>
<BranchCode>06684</BranchCode>
- <AccountNbrs>
<AccountNbr>0668421008800119BHD</AccountNbr>
<AccountNbr>0668421008800119USD</AccountNbr>
<AccountNbr>0668421008800216BHD</AccountNbr>
<AccountNbr>0668421008800119QAR</AccountNbr>
</AccountNbrs>
</Customer>
<Customer>
<CustName>M.T.C. ALUPACK <CustName>
<CustId>06684209916</CustId>
<CountryCode>BH</CountryCode>
<BranchCode>06684</BranchCode>
- <AccountNbrs>
<AccountNbr>0668420991600115BHD</AccountNbr>
<AccountNbr>0668420991600115EUR</AccountNbr>
<AccountNbr>0668420991600115USD</AccountNbr>
</AccountNbrs>
</Customer>
- <Customer>
<CustName>AL ZAIN AUTO SUPPLIES ESTABLISHMENT</CustName>
<CustId>06684209577</CustId>
<BranchCode>06684</BranchCode>
- <AccountNbrs>
<AccountNbr>0668420957700159BHD</AccountNbr>
<AccountNbr>0668420957700159EUR</AccountNbr>
<AccountNbr>0668420957700159USD</AccountNbr>
</AccountNbrs>
</Customer>
<Customers>

you can find the above xml there is no CountryCode in the second record and 4th records.
if that CountryCode is not present then i need to skip the total Customer tag.
so we were using the sax parcing in our application. can you please let me know... how to handle this code in SAX Parcing.

Please find the below code which i have used..from the parcing point of view it is working very find..

package com.bnpparibas.tradefinance.batch.atlas2;

import java.io.File;
import java.io.FileReader;
import java.rmi.RemoteException;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
import java.util.Map;
import java.util.Properties;
import java.util.ResourceBundle;
import java.util.Set;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.rmi.PortableRemoteObject;

import org.xml.sax.Attributes;
import org.xml.sax.InputSource;
import org.xml.sax.XMLReader;
import org.xml.sax.helpers.DefaultHandler;
import org.xml.sax.helpers.XMLReaderFactory;

import com.bnpparibas.tradefinance.batch.util.IBatchConstants;
import com.bnpparibas.tradefinance.common.bean.db.Branch;
import com.bnpparibas.tradefinance.common.bean.db.Country;
import com.bnpparibas.tradefinance.common.bean.db.Customer;
import com.bnpparibas.tradefinance.common.bean.db.CustomerAccount;
import com.bnpparibas.tradefinance.common.bean.db.MO;
import com.bnpparibas.tradefinance.common.exception.DatabaseException;
import com.bnpparibas.tradefinance.ejb.facade.EjbFacade;
import com.bnpparibas.tradefinance.ejb.facade.EjbFacadeHome;
import com.ideo.sweetdev.core.log.ILog;
import com.ideo.sweetdev.core.log.LogHelper;
import com.ideo.sweetdev.core.service.remoting.IRemotingConstants;


/**
* Atlas2CustomerBatch ? This Class used to run the Batch to update the
* Customer Data in the Database Table Customer.
*
* @date 21/01/2009
* @revision 001
*
*/
public class Atlas2CustomerBatch extends DefaultHandler {


private Set accounts; // set of accounts for a single customer

private Customer customer; // A single customer

private String stringValue = "";

private CustomerAccount customerAct; //

String charValue = "";

private Branch branch = null;

private Country country = null;

private static EjbFacade ejbFacade = null;

private Map event = null;

private Set customers;

private static String CLASS_NAME = Atlas2CustomerBatch.class.getName();

private static ILog logger = LogHelper.getLog(CLASS_NAME);

/**
* main
*
* @param args
* @throws Exception
*/

public static void main(String args[]) throws Exception {
ResourceBundle customerResource = ResourceBundle
.getBundle("props.interfacecommon");
String cftFolderName = customerResource
.getString("customer.batch.cftfolder");
String processedFolderName = customerResource
.getString("customer.batch.processedfolder");
File cftcustomerFolder = new File(cftFolderName);
// Create a properties collection
Properties props = new Properties();
props.put(Context.INITIAL_CONTEXT_FACTORY,
IBatchConstants .INITIAL_CONTEXT_FACTORY);
props.put(Context.PROVIDER_URL, customerResource
.getString("rmi.remoteserver.uri"));
logger.debug("[Atlas2CustomerBatch][main]"+customerResource
.getString("rmi.remoteserver.uri"));
// Cretae a new Context Object
Context ctx = new InitialContext(props);
// look for the EJB using the Context
Object obj = (Object) ctx
.lookup(customerResource
.getString("rmi.ejb.facade.lookup"));
EjbFacadeHome dataHome = (EjbFacadeHome) PortableRemoteObject.narrow(
obj, EjbFacadeHome.class);
// Create a EJB Facade
ejbFacade = dataHome.create();

if (cftcustomerFolder.exists() && cftcustomerFolder.isDirectory()) {
File[] cftFiles = cftcustomerFolder.listFiles();
XMLReader xmlReader = XMLReaderFactory.createXMLReader();
Atlas2CustomerBatch handler = new Atlas2CustomerBatch();
xmlReader.setContentHandler(handler);
xmlReader.setErrorHandler(handler);

for (int i = 0; i < cftFiles.length; i++) {
FileReader customerXmlFile = new FileReader(cftFiles[i]);
xmlReader.parse(new InputSource(customerXmlFile));
cftFiles[i].renameTo(new File(processedFolderName + "/"
+ cftFiles[i].getName()));
}
}

}

public Atlas2CustomerBatch() {
super();
}

/**
* This method executes on the start of the document. on start of the
* document reset the table.
*
* @date 23/12/2008
*/
public void startDocument() {

customers = new HashSet();


}

/**
* endDocument-XMLParser Event handler This method executes on the end of
* the document. on end of the document set the customer table.
*
*
*/
public void endDocument() {

// Truncate the Customer Table
try {
event = new HashMap();

event
.put(IRemotingConstants.INTERFACE_CLASS_NAME,
IBatchConstants.DATABASE_BUSINESS_CONTROLLER);
event.put(IRemotingConstants.METHOD_NAME, IBatchConstants.DATABASE_RESET_CUSTOMER);
ejbFacade.execute(event);

} catch (DatabaseException e) {
logger.error(e.getMessage() + e.getStackTrace());

} catch (RemoteException e) {
e.printStackTrace();
logger.error(e.getMessage() + e.getStackTrace());

} catch (Exception e) {
logger.error(e.getMessage(), e);

}

// Add the cutomers to the table
try {
if (customers == null) {
logger.debug("It is finding null here");
} else {
Customer customer1 = null;
Iterator itr = customers.iterator();

Class[] methodParameterTypesCustomer = { Customer.class };

while (itr.hasNext()) {
customer1 = (Customer) itr.next();

if (customer1 != null) {
if (customer.getCustomerId().length() > 0) {
Object[] cusotomerArguments = { (Object) customer1 };
event = new HashMap();
event
.put(
IRemotingConstants.INTERFACE_CLASS_NAME,
IBatchConstants.DATABASE_BUSINESS_CONTROLLER);
event.put(IRemotingConstants.METHOD_NAME,
IBatchConstants.DATABASE_SET_CUSTOMER);
event.put(
IRemotingConstants.METHOD_PARAMETER_TYPES,
methodParameterTypesCustomer);
event.put(IRemotingConstants.METHOD_ARGUMENTS,
cusotomerArguments);
ejbFacade.execute(event);
}
}
}
}
} catch (RemoteException e) {
logger.error(e.getMessage(), e);
} catch (Exception e) {
logger.error(e.getMessage(), e);
}

}

/**
* startElement-XMLParser Event handler This method executes on the start of
* the elements. on start of the each element update the element in the
* customer bean
*
* @param uri
* @param name
* @param qName
* @param atts
*
*/

public void startElement(String uri, String name, String qName,
Attributes atts) {
if ("".equals(uri)) {
if (qName.equals(IBatchConstants.ATLAS2_CUSTOMER_QNAME_CUSTOMER)) {
// Create a new Customer bean here
customer = new Customer();
accounts = new HashSet();
}
// intialise the stringValue
stringValue = "";

}
}

/**
* endElement-XMLParser Event handler This method executes on the end of the
* elements. on end of the each element update the element in the customer
* bean
*
* @param uri
* @param name
* @param qName
*
*/

public void endElement(String uri, String name, String qName) {
String branchCode = "";
String countryCode = "";

MO mo = null;
if ("".equals(uri)) {
if (qName.equals(IBatchConstants.ATLAS2_CUSTOMER_QNAME_CUSTOMERNAME)) {
System.err.println("Customer Name:"+stringValue);
customer.setCustomerName(stringValue);
}
if (qName.equals(IBatchConstants.ATLAS2_CUSTOMER_QNAME_ID)) {
customer.setCustomerId(stringValue);
}

if (qName.equals(IBatchConstants.ATLAS2_CUSTOMER_QNAME_ACC_NMBR)) {
customerAct = new CustomerAccount();
customerAct.setAccountNumber(stringValue);
accounts.add(customerAct);
}

if (qName.equals(IBatchConstants.ATLAS2_CUSTOMER_QNAME_ACC_NUMBERS)) {
// Add the Accounts set to customer
if (accounts != null) {
customer.setAccounts(accounts);
}
}

if (qName.equals(IBatchConstants.ATLAS2_CUSTOMER_QNAME_COUNTRY_CODE)) {
countryCode = stringValue;
System.err.println("Country Code:"+stringValue);
try {
Class[] _methodParameterTypes = { String.class };
Object[] arguments = { (Object) countryCode };
event = new HashMap();
event
.put(IRemotingConstants.INTERFACE_CLASS_NAME,
IBatchConstants.DATABASE_BUSINESS_CONTROLLER);
event.put(IRemotingConstants.METHOD_NAME,
IBatchConstants.DATABASE_COUNTRY_BY_COUNTRY_CODE);
event.put(IRemotingConstants.METHOD_PARAMETER_TYPES,
_methodParameterTypes);
event.put(IRemotingConstants.METHOD_ARGUMENTS, arguments);
country = (Country) ejbFacade.execute(event);
}
catch (NumberFormatException e) {
logger.error(e.getMessage(), e);

} catch (DatabaseException e) {
logger.error(e.getMessage(), e);

} catch (RemoteException e) {
logger.error(e.getMessage(), e);
} catch (Exception e) {
logger.error(e.getMessage(), e);
}
}


if (qName.equals(IBatchConstants.ATLAS2_CUSTOMER_QNAME_BRANCH_CODE)) {
branchCode = stringValue;
if (branchCode.length() > 0) {

try {
Class[] _methodParameterTypes = { String.class };
Object[] arguments = { (Object) branchCode };
event = new HashMap();
event
.put(IRemotingConstants.INTERFACE_CLASS_NAME,
IBatchConstants.DATABASE_BUSINESS_CONTROLLER);
event.put(IRemotingConstants.METHOD_NAME,
IBatchConstants.DATABASE_BRANCH_BY_BRANCH_CODE);
event.put(IRemotingConstants.METHOD_PARAMETER_TYPES,
_methodParameterTypes);
event.put(IRemotingConstants.METHOD_ARGUMENTS,
arguments);
branch = (Branch) ejbFacade.execute(event);

} catch (NumberFormatException e) {
logger.error(e.getMessage(), e);

} catch (DatabaseException e) {
logger.error(e.getMessage(), e);

} catch (RemoteException e) {
logger.error(e.getMessage(), e);
} catch (Exception e) {
logger.error(e.getMessage(), e);
}

}
}

if (qName.equals(IBatchConstants.ATLAS2_CUSTOMER_QNAME_CUSTOMER)) {

// Got a Customer so update it in the customers set
if (country !=null && branch !=null){
try {

Class[] _methodParameterTypes = { Country.class,
Branch.class };

Object[] arguments = { (Object) country, (Object) branch };
event = new HashMap();
event
.put(IRemotingConstants.INTERFACE_CLASS_NAME,
IBatchConstants.DATABASE_BUSINESS_CONTROLLER);
event.put(IRemotingConstants.METHOD_NAME,
IBatchConstants.DATABASE_MO_BY_COUNTRY_AND_BRANCH);
event.put(IRemotingConstants.METHOD_PARAMETER_TYPES,
_methodParameterTypes);
event.put(IRemotingConstants.METHOD_ARGUMENTS, arguments);
mo = (MO) ejbFacade.execute(event);


} catch (DatabaseException e) {
logger.error(e.getMessage(), e);

} catch (RemoteException e) {
logger.error(e.getMessage(), e);
} catch (Exception e) {
logger.error(e.getMessage(), e);
}
if (mo !=null){

customer.setMiddleOffice(mo.getId());
customers.add(customer);
}else{
logger.error("Mo not found for Country or branch in Database.");
}

}else{
logger.error("Country or branch not available in Database.");
}

}

if (qName.equals(IBatchConstants.ATLAS2_CUSTOMER_QNAME_CUSTOMERS)) {
// end of list of customer
}

}

}

/**
*
* This method reads the value of XML elements.called by XML sex parser
*
* @param chArray -
* array of characters
* @param start
* @param length
*
*/
public void characters(char chArray[], int start, int length) {

for (int i = start; i < start + length; i++) {
if (!(chArray[i] == '\\' || chArray[i] == '"' || chArray[i] == '\n'
|| chArray[i] == '\r' || chArray[i] == '\t')) {
charValue = String.valueOf(chArray[i]);
stringValue = stringValue + charValue;
}

}
}
}


Thanks In Advance....

cheers,
Sunil