[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - 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


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4249822#4249822

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4249822