Ok here's how I changed the code. I read in the link above that the connections won't return to the pool unless they are closed. I added a cleanup() method for all subclasses to call in their finally blocks after using a connection.
Does this look better? Anything else I should change wrt connection pooling or other standard DAO practices?
Also, we're using
Tomcat 5 for our App Server. Here's the datasource info in server.xml. Any tweaks I should be making here?
Thanks again for everyone's time and consideration.
Aaron
[ August 31, 2006: Message edited by: Aaron Wilt ]
[ August 31, 2006: Message edited by: Aaron Wilt ]