public void myConnPool() throws java.rmi.RemoteException {
// retry indicates whether to retry or not
// numOfRetries states how many retries have been attempted
boolean retry = false;
int numOfRetries =  0 ;
java.sql.Connection conn = null;
java.sql.Statement stmt = null;
do {
    try {
       //Assumes that a datasource has already been obtained from JNDI
       conn = ds.getConnection();
       stmt = conn.createStatement();
       stmt.execute(
                     "INSERT INTO ORG VALUES (10, 'Pacific', '270', 'Western', 
                    'Seattle')");
        retry = false;
    } catch (com.ibm.websphere.ce.cm.StaleConnectionException sce) {
      //if a StaleConnectionException is caught rollback and retry the action
         if (numOfRetries <  2 ) {
            retry = true;
            numOfRetries++;
            // add an optional pause
           Thread.sleep( 10000 );
        } else {
           retry = false;
        }
    } catch (java.sql.SQLException sqle) {
        //deal with other database exception
    } finally {
       //always cleanup JDBC resources
       try {
          if (stmt != null)
             stmt.close();
       } catch (java.sql.SQLException sqle) {
          //usually can ignore
       }
      try {
           if (conn != null)
              conn.close();
      } catch (java.sql.SQLException sqle) {
          //usually can ignore
      }
    }
  } while (retry);
}