Thanks for answering my question. You are saying you can set a validation query to validate connections. Can you set a specific time intervals for this validation to be done and where do you do it? Is there a documentation on how to do this? I should mention we are using Tomcat 4.0.x, can I use DBCP? Or what's the best way to configure pooling? Is that a good idea in general to use the Tomcat mechanism or should I consider something like DBConnectionBroker? Thanks again Nadia
-----Original Message----- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 3:15 PM To: Tomcat Users List Subject: RE: connection pooling Howdy, >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? You don't need to do this manually: set a validation query for your pool and DBCP will validate all your connections for you. Tomcat is not a connection pooling product by itself. It simply allows you to use JNDI to configure other connection pooling products, like DBCP or Oracle's connection pooling implementation. Each of those products have their own features and documentation you will need to consult. Yoav Shapira 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]
