RE: Connection pool problem DBCP - 4.1.3

2007-02-23 Thread Propes, Barry L [GCG-NAOT]
To: Tomcat Users List Subject: 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 w

RE: Connection pool problem DBCP - 4.1.3

2007-02-21 Thread Propes, Barry L [GCG-NAOT]
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, ResultSet loop/access code. Generally the pseudo code should be...

RE: Connection pool problem DBCP - 4.1.3

2007-02-19 Thread Propes, Barry L [GCG-NAOT]
06 PM 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 gettin

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, de

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 ve

RE: Connection pool problem DBCP - 4.1.3

2007-02-19 Thread Mike Quilleash
Need a bit more info. DB type and version, JDBC driver version, ResultSet loop/access code. Generally the pseudo code should be... Open Connection try { Prepare Statement try { Execute Query try { while ( resultSet.next() ) { // process row here }

RE: Connection pool problem

2007-02-18 Thread Caldarale, Charles R
> From: Roland Rabben [mailto:[EMAIL PROTECTED] > Subject: Connection pool problem > > My application has many clients that perform automatic download of new > files and send status information back to the server. AFAIK, there's nothing in the Tomcat configuration that provides per-app (or sub-a