Re: [OT] minIdle not being enforced and connections are getting closed instead of returning to the pool

2013-11-19 Thread Srikanth
Hi Chris, We are creating oracle.sql.ARRAY objects in our application using the below piece of code. ArrayDescriptor varArrayDesc = ArrayDescriptor.createDescriptor(ARRAY_XYZ, connection); ARRAY xyzArray = new ARRAY(ArrayDescriptor paramArrayDescriptor, Connection paramConnection, Object

Re: [OT] minIdle not being enforced and connections are getting closed instead of returning to the pool

2013-11-15 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Srikanth, On 11/15/13, 2:36 AM, Srikanth wrote: I was unwrapping each connection before returning it using the below piece of code. con = ds.getConnection().unwrap(oracle.jdbc.OracleConnection.*class*); *return* con; As explained by

Re: minIdle not being enforced and connections are getting closed instead of returning to the pool

2013-11-14 Thread Srikanth
Hi Daniel, Thank you very much for responding to the query. How do you know it is creating a new connection? Are you monitoring the number of active / idle connections in the pool? What numbers do you see? Actually I was logging the time taken to get the Connection from pool and it was

minIdle not being enforced and connections are getting closed instead of returning to the pool

2013-11-13 Thread Srikanth
Hi, I am using the below configuration for creating a datasource in Tomcat 7.0.42. And the backend database is Oracle 10g. Resource name=jdbc/crd auth=Container type=javax.sql.DataSource factory=org.apache.tomcat.jdbc.pool.DataSourceFactory driverClassName=oracle.jdbc.driver.OracleDriver

Re: minIdle not being enforced and connections are getting closed instead of returning to the pool

2013-11-13 Thread Daniel Mikusa
On Nov 13, 2013, at 4:01 AM, Srikanth gaadi...@gmail.com wrote: Hi, I am using the below configuration for creating a datasource in Tomcat 7.0.42. And the backend database is Oracle 10g. Resource name=jdbc/crd auth=Container type=javax.sql.DataSource