Thanks a lot for assistance Jan Cumps. But if i add
"catch(com.ibm.websphere.ce.cm.StaleConnectionException
sce)
{
//if a StaleConnectionException is caught
// rollback and retry the action
try {
tran.rollback();
} catch (java.lang.Exception e) {
//deal with exception
//in most cases, this can be ignored
}
"
am getting compilation error that "com.ibm.websphere.ce.cm.StaleConnectionException" cannot be resolved