Just wanted to let everyone know that I convinced the powers that be here at work to upgrade to 5.0.16 for this project, and lo and behold all my problems went away! Not a single line of code was changed, only two configuration parameters changed (username became user and driverName became url in the server.xml entry), and everything is now working as expected. Considerably snappier performance as well. I wish I knew what the issue was, but I'll live with never knowing now that things are working right. Thanks for all the suggestions tossed my way!
--------------------------------------------------- Hello all. I've recently had a need to implement connection pooling under Tomcat 4.0.6 (I can't upgrade versions as per a mandate by my employer). I have read some posts that indicate that Tyrex does not actually pool connections. I don't know for sure if that is true or not (any definitive answers here?), so I decided to use DBCP, since I knew that did. I grabbed the latest builds of DBCP, collections and pool (1.1, 2.1 and 1.1 respectively), stuck them in tomcat/common/lib, added my JNDI entry to the app's context in server.xml, added the proper ref tags in web.xml and put in the appropriate code to get a connection from the pool (set to maxActive=50, maxIdle=50000, maxWait=1000 and minIdle=10). Now, I've got it up and running without much trouble. Everything SEEMED to be working fine, until I realized that all my database writes (updates, inserts, deletes) were NOT hitting the database. There are NO exceptions being thrown anywhere of any kind. All the relevant objects (statements, connection, etc.) are non-null. Return codes from SQL executions where applicable seem to be what they should be. Database reads work perfectly, which indicates everything is OK I think (I have a single class with a single method that gets the connection out of the pool and deals with all database access). My question is simple and obvious: anyone have any ideas why database writes would be failing (maybe failing is the wrong word... simply not happening is more accurate) while reads succeed? It is an Oracle 9.2 database by the way, using the Oracle thin JDBC driver (same driver that is used when I switch to manually creating connections in code rather than using JNDI and Tomcat's facilities). Frank W. Zammetti Web Architect Consultant ----------------------------------------- The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]