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 paramO

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 explaine

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

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 wrote: > Hi, > > I am using the below configuration for creating a datasource in Tomcat > 7.0.42. And the backend database is Oracle 10g. > > auth="Container" > type="javax.sql.DataSource" > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > dri

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. Now the problem is whenever I try to get a connection from pool, it is creating a new connection and returning back. minIdle connections are not maintained in the pool and