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 for connection

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

RE: Suggestions for connection pooling

2007-10-25 Thread Tony Fountain
? Or do I also need to set conn = null;? Thanks, Tony -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

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 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;? You

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();