Re: [OT] Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-21 Thread Rainer Frey (Inxmail GmbH)
On 22.11.2013, at 02:20, Christopher Schultz ch...@christopherschultz.net wrote: I also think that this is a justifiable spec violation, and all I’m asking is that this fact is shown more prominently, esp. as JDBC pool is advertised as a drop-in replacement for DBCP. Fair enough. Care you

Re: [OT] Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-21 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Rainer, On 11/21/13, 2:18 AM, Rainer Frey (Inxmail GmbH) wrote: On 20.11.2013, at 14:21, Christopher Schultz ch...@christopherschultz.net wrote: Rainer, FWIW, Connection.close also states this: Releases this Connection object's database

Re: Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-20 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Carl, A late reply, but I believe you have some problems with your code. Mark's comments about Tomcat-pool indicate that certain sloppy resource-management activities may leave resources open on the server, and I'm fairly sure that, given the code

Re: [OT] Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-20 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Rainer, On 11/20/13, 2:36 AM, Rainer Frey (Inxmail GmbH) wrote: On 19.11.2013, at 14:45, Mark Thomas ma...@apache.org wrote: On 19/11/2013 13:32, Carl Boberg wrote: I have here an example of the way we close from the application, (the

Re: [OT] Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-20 Thread Rainer Frey (Inxmail GmbH)
On 20.11.2013, at 14:21, Christopher Schultz ch...@christopherschultz.net wrote: Rainer, FWIW, Connection.close also states this: Releases this Connection object's database and JDBC resources immediately instead of waiting for them to be automatically released. Does that mean that

Re: Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-19 Thread Carl Boberg
Thanks for taking the time Daniel, It is very hard to explain the problem since, and it was also stupid of me to not include the fact that I have tried all kinds of similar combinations of configuration in context.xml. With botch dbcp and jdbc pools The behaviour persists. For example these are

Re: Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-19 Thread Mark Thomas
On 19/11/2013 13:32, Carl Boberg wrote: I have here an example of the way we close from the application, (the devs have named it dispose). From my untrained non java dev eye we do not seem to be doing statement.Close(); and Im curious if that might be the issue? If so, why does DBCP handle it

Re: Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-19 Thread Daniel Mikusa
On Nov 19, 2013, at 8:32 AM, Carl Boberg carl.bob...@memnonnetworks.com wrote: Thanks for taking the time Daniel, It is very hard to explain the problem since, and it was also stupid of me to not include the fact that I have tried all kinds of similar combinations of configuration in

Re: Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-19 Thread Rainer Frey (Inxmail GmbH)
On 19.11.2013, at 14:45, Mark Thomas ma...@apache.org wrote: On 19/11/2013 13:32, Carl Boberg wrote: I have here an example of the way we close from the application, (the devs have named it dispose). From my untrained non java dev eye we do not seem to be doing statement.Close(); and Im

Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-18 Thread Carl Boberg
Hello, We have recently migrated from dbcp pool to the newer tomcat-jdbc pool. As I understand, it is supposed to be almost a drop in replacement for dbcp. Everything works great except once small thing. Its a bit difficult for me to explain but our DBA is really annoyed by it... With the new

Re: Curious difference in connection behaviour on database side DBCP vs. JDBC?

2013-11-18 Thread Daniel Mikusa
On Nov 18, 2013, at 9:48 AM, Carl Boberg carl.bob...@memnonnetworks.com wrote: Hello, We have recently migrated from dbcp pool to the newer tomcat-jdbc pool. As I understand, it is supposed to be almost a drop in replacement for dbcp. *Almost* is the key word here. It's very similar, but