RE: need inputs on connection pool

2006-04-06 Thread Chandrashekhar O
om Orielly) and then make your changes on the top of that. Regards, Chandrashekhar. -Original Message- From: Lenin Lakshminarayanan -X (lelakshm - HCL at Cisco) [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 05, 2006 11:45 PM To: Tomcat Users List Subject: RE: need inputs on conne

Re: need inputs on connection pool

2006-04-05 Thread Mark Thomas
When starting a new thread (ie sending a message to the list about a new topic) please do not reply to an existing message and change the subject line. To many of the list archiving services and mail clients used by list subscribers this makes your new message appear as part of the old thread. Thi

RE: need inputs on connection pool

2006-04-05 Thread Lenin Lakshminarayanan -X \(lelakshm - HCL at Cisco\)
You'll have to release the connection to the pool and _NOT_ close the connection. It's something like this : * Create a resource pool that maintains the pool * release the resource from the pool upon request ( if the resource Is already there in the pool and can be utilized )

RE: need inputs on connection pool

2006-04-05 Thread Farrow, Marc
Then you need to check your Driver and see what level of JDBC it is implementing for a complete answer. -Original Message- From: Abh N [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 05, 2006 11:27 AM To: Tomcat Users List Subject: RE: need inputs on connection pool Thanks Marc. I

RE: need inputs on connection pool

2006-04-05 Thread Abh N
Thanks Marc. I was reading an article http://java.sun.com/developer/technicalArticles/J2EE/pooling/ it says with con.close() the connection will be released to connection pool in jdbc 2.0 , in 1.0 it will be closed with the stmt. "Farrow, Marc" <[EMAIL PROTECTED]> wrote:

Re: need inputs on connection pool

2006-04-05 Thread Larry Meadors
Calling close() on a pooled connection simply returns it to the pool, however, i have seen some cases where calling ti twice closes it for real. Don't do that. If you are interested in other options that eliminate that concern, you may want to try iBATIS - you would still use SQL, but it manages t

RE: need inputs on connection pool

2006-04-05 Thread Farrow, Marc
It is always good practice to call the close methods on the Connection, Statement, PreparedStatement, ResultSet objects (if you use them). Depending on the connection pooling that you are using, they may or may not get released in a timely manner (for example, timeouts/etc). By explicitly calling