0 Replies Latest reply on Aug 16, 2009 8:11 PM by nskarthik_k

    Loosing DB Connectionson doing load test    ...:(

    nskarthik_k

      Hi
      Sorry This form was pasted on JBOSS-MAIL List,but was suggested by "Steve"

      The url below says how to extract a Oracle type Connection from JBOSS Wrapper
      http://forums.oracle.com/forums/thread.jspa?messageID=1384788
      No problem is getting the connection, but Do Not know how to close the same for the obtained connection to be returned
      The code is as given below

      import org.jboss.resource.adapter.jdbc.WrappedConnection;

      private WrappedConnection WCP = null;

      /**
      * Singleton process
      */

      public static DBConnectionManager getInstance() throws InfinetException {
      if (instance == null) {
      synchronized (DBConnectionManager.class) {
      if (instance == null) {instance = new DBConnectionManager(); }
      }
      }
      return instance;
      }

      /**
      * Get connection
      */

      public Connection getConnection()throws InfinetException{
      Connection connx = null;
      Connection underlyingConn = null;
      try {
      connx = ODS.getConnection();
      WCP = (WrappedConnection)connx;
      underlyingConn = WCP.getUnderlyingConnection();
      connx = (OracleConnection)underlyingConn;
      } catch (SQLException sqlex) {
      sqlex.printStackTrace();
      }
      return connx;
      }



      /**
      * Free connection
      */

      public void freeConnection(Connection con) throws InfinetException {
      System.ou.println("RELEASING THE USED CONNECTION TO POOL");
      try {
      //@IMP JBOSS does not require this connection to close
      //con.close();
      //Close WRAPPER Connection
      WCP.close();
      }catch (Exception e) {
      System.out.println("CAN'T CLOSE CONNECTION FOR POOL ");
      e.printStackTrace();
      }
      }



      Oracle-ds.xml is as follows
      <local-tx-datasource>
      <jndi-name>jdbc/ORACLESCHEMA1</jndi-name>
      <connection-url>jdbc:oracle:thin:@172.16.17.70:1521:SCHEMA1</connection-url>
      <driver-class>oracle.jdbc.OracleDriver</driver-class>
      <user-name>SCHEMAUSERID</user-name>
      SCHEMAPASSWD
      <min-pool-size>10</min-pool-size>
      <max-pool-size>60</max-pool-size>
      <track-statements>false</track-statements>

      <type-mapping>Oracle9i</type-mapping>

      </local-tx-datasource>

      >From jmx-console “name=jdbc/ORACLESCHEMA1,service=ManagedConnectionPoolâ€�
      We observe that with in 10 minuts “AvailableConnectionCountâ€� was become ‘0’

      Any help would be appreciated

      SPEC
      JBOSS 4.2.1
      ORACLE DB : 10G DB
      jar : ojdbc14.jar
      j2sdk 1.4 for development
      j2sdk1.6 for jboss runtime

      with regards
      Karthik