[jboss-user] Loosing DB Connectionson doing load test ...:(

[Stephen Davidson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Karthik.

Q: Why do do you need to access the underlying connection directly?
Usually, this is not a good idea, unless you are writing your own
connection wrapper.

In regards to this mailing, you would be better off posting on the
forums, as it does not appear that this list is monitored any more by
the JBoss Group.

Regards,
Steve

Karthik Nanjangude wrote:
> Hi
> 
> 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
> 
> 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>
> <password>SCHEMAPASSWD</password>
> <min-pool-size>10</min-pool-size>
> <max-pool-size>60</max-pool-size>
> <track-statements>false</track-statements>
> <metadata>
> <type-mapping>Oracle9i</type-mapping>
> </metadata>
> </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
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> jboss-user mailing list
> jboss-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jboss-user

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iEYEARECAAYFAkqIhpwACgkQSphIUSiVzgZtOwCgs21ybdw6ZHcr99j22nIEtjIs
Wc8AoOAlw3OdMiHGk3f3qZE4GuYCMCGz
=o+Kh
-----END PGP SIGNATURE-----