Thanks, but do you know what is abandoned connection? As I understand it, abandoned connection is the one that has not been used in some time but it still could be a live connection. I need to go through all the connections in the pool and check if every connection is a valid, live connection and not whether it has been used recently. Does Tomcat allow me to do that? And how do I retrieve all the used connections to check every one of them? Nadia
-----Original Message----- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 12:44 PM To: Tomcat Users List Subject: RE: connection pooling Howdy, Tomcat uses DBCP by default for connection pooling, although you can use other packages as well. DBCP supports evicting idle connections with a configurable timeout on how long the connection must be idle before eviction. DBCP also supports configurable validation queries (checking for stale / bad connections). See DBCP API JavaDocs at http://jakarta.apache.org/commons/dbcp/apidocs/index.html See Tomcat & DBCP (and other) connection pool configuration examples at: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples -howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: Nadia Kunkov [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 04, 2003 12:39 PM >To: [EMAIL PROTECTED] >Subject: connection pooling > > >Hi, I'm using Tomcat 4.0.4 and I'm wondering if setting up a connection >pooling will give me a capability to set up some time intervals according >to which my pool manager will check if connections are active and recycle >them if they are not. Does Tomcat have this capability? ( is there >something like pool manager that goes aroung checking for connections?) >In the Jakarta documentation you can find how to set up and obtain the >connection through the new datasource, but there is nothing about how to >explicitly use this pool to check for stale connections and such. >Plese, let me know where I can find this. >Are there some free packages I can download and use? >Thank you very much for your help. >Nadia > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
