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]
