RE: Connection pool problem DBCP - 4.1.3

2007-02-23 Thread Propes, Barry L [GCG-NAOT]
: RE: Connection pool problem DBCP - 4.1.3 I wonder...would I get mixed results trying to implement JNDI maing in my server.xml file, but only trying to (on a page by page basis, with an existing servlet and/or JSP) utilize the naming context method? In other words, I test out DBCP with one

RE: Connection pool problem DBCP - 4.1.3

2007-02-21 Thread Propes, Barry L [GCG-NAOT]
Quilleash [mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 1:08 PM To: Tomcat Users List Subject: RE: Connection pool problem DBCP - 4.1.3 Need a bit more info. DB type and version, JDBC driver version, ResultSet loop/access code. Generally the pseudo code should be... Open Connection

Connection pool problem DBCP - 4.1.3

2007-02-19 Thread Propes, Barry L [GCG-NAOT]
This is driving me crazy. I'm finally close, I think, on getting this solved. Problem is I seem to either get Connection is closed or Exhausted resultset, depending where I put my close statement. I've got the following up at the top, which replaces my driver reference that was previously

RE: Connection pool problem DBCP - 4.1.3

2007-02-19 Thread Mike Quilleash
] [mailto:[EMAIL PROTECTED] Sent: 19 February 2007 18:22 To: Tomcat Users List Subject: Connection pool problem DBCP - 4.1.3 This is driving me crazy. I'm finally close, I think, on getting this solved. Problem is I seem to either get Connection is closed or Exhausted resultset, depending where I put my

RE: Connection pool problem DBCP - 4.1.3

2007-02-19 Thread Propes, Barry L [GCG-NAOT]
ok, I'll send that, too. Sorry about that. -Original Message- From: Mike Quilleash [mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 1:08 PM To: Tomcat Users List Subject: RE: Connection pool problem DBCP - 4.1.3 Need a bit more info. DB type and version, JDBC driver version

Re: Connection pool problem DBCP - 4.1.3

2007-02-19 Thread --
I think you should also call prepstmt.close() (before closing the connection). Besides selstmt seems not to be used at all. Bye This is driving me crazy. I'm finally close, I think, on getting this solved. Problem is I seem to either get Connection is closed or Exhausted resultset,

RE: Connection pool problem DBCP - 4.1.3

2007-02-19 Thread Propes, Barry L [GCG-NAOT]
To: Tomcat Users List Subject: Re: Connection pool problem DBCP - 4.1.3 I think you should also call prepstmt.close() (before closing the connection). Besides selstmt seems not to be used at all. Bye This is driving me crazy. I'm finally close, I think, on getting this solved. Problem