RE: Suggestions for connection pooling

2007-10-26 Thread Tony Fountain
Everyone, thanks for the feedback and additional suggestions on "clean coding" :). I think I'm good to go. Thanks, Tony -Original Message- From: Len Popp [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 5:25 PM To: Tomcat Users List Subject: Re: Suggestions

Re: Suggestions for connection pooling

2007-10-25 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Len, Len Popp wrote: >Connection conn = ds.getConnection(); >try { >...do something... >} finally { >conn.close(); >} Might I further suggest: Connection conn = ds.getConnection();

Re: Suggestions for connection pooling

2007-10-25 Thread Len Popp
On 10/25/07, Tony Fountain <[EMAIL PROTECTED]> wrote: > Now, my goal is to utilize connection pooling. Does (a) this > implementation achieve that and (b) the close statement suffice to > return the object to the pool and not actually close the connection? Or > do I also need to set "conn = null;

RE: Suggestions for connection pooling

2007-10-25 Thread Propes, Barry L
that should work for you Tony. I have a similar setup and mine works properly. -Original Message- From: Tony Fountain [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 3:59 PM To: Tomcat Users List Subject: RE: Suggestions for connection pooling Ok - I think I have my answer

RE: Suggestions for connection pooling

2007-10-25 Thread Tony Fountain
---Original Message- From: Tony Fountain [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 2:39 PM To: Tomcat Users List Subject: RE: Suggestions for connection pooling Thanks for the reference. This looks like what I need. Now to go read up a bit more to grasp the concept. To

RE: Suggestions for connection pooling

2007-10-25 Thread Tony Fountain
Thanks for the reference. This looks like what I need. Now to go read up a bit more to grasp the concept. Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2000 2:30 PM To: Tony Fountain Subject: Re: Suggestions for connection