title: Websphere connection pool issue i.e DSRA9110E
body: <pre><code>LOGGER.debug("Connection Status Disb isClosed = " + conn.isClosed()); 
  // returns true.
  crsDisbDetailstmp = DataAccess.getData("select 1 cnt from dual", conn, new String[] {});
  crsDisbDetailstmp.first();
  LOGGER.debug("crsDisbDetailstmp"+ crsDisbDetailstmp.getString("cnt"));
  
  DataAccess.executeProc("PRC_MCLR_TRNPRCDTL", new String[]{strOrgId, strAccountid,strFixedRate ,strModifiers }, conn);
  </code></pre>
  
  <blockquote>
    <p>Exception occured while executing last statement i.e execute procedure.
    Exception=com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed. </p>
  </blockquote>
  
  <p>I search a lot on google it shows this exception is occurred because connection is closed also i checked with conn.isclosed() which return true..
  But If connection is closed then how i am able to fire select queries???
  Please help me to figure it out as i worked on JBOSS only and first time on Websphere</p>