get Connection with multiple schemas does not close connection

Bug #1273611 reported by anjana
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
BoneCP
New
Undecided
Unassigned

Bug Description

In our scenario connection are retrieved using getConnection(string userName,String password) and getConnection. The statement cache is assigned value of 3. The statement are getting cached however on pool shutdown the connection that is created using specified username and password are not getting close. Below are the steps performed.

Connection insertConn=null
BoneCPDAtaSource connPool = new BoneCPDataSource(Config)
insertConn = connPool.getConnection()
... Perform insert

Connection selectConn=null
selectConn = connPool.getConnection(UserName,Password)

PreparedStatement prepStat = selectConn.prepared("select * from temp");
....perform select query

//close the connection and shutdown the pool
insertConn.close;
selectConn.close;
connPool.close ; //At this point the connection obtain in selectConn does get close.

We are using 0.8.0 release of bonecp.

Any help appreciated.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.