Uh, you don't want to use the Access with Java, at least not unless you mind rebooting your server on a regular basis. The JDBC-ODBC bridge has a memory leak.
And besides I've been hearing that even Microsoft isn't doing anything with Access (using SQL Server run-time instead). Also that it might be going away in one of the next few releases. But if you have to use Access all you should have to do is change the JDBC URL. --mikej -=----- mike jackson [EMAIL PROTECTED] -----Original Message----- From: JS [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 4:06 PM To: [EMAIL PROTECTED] Subject: connection pooling saga Hello. Has anyone ever done connection pooling with MS Access and tomcat 4.1.12? I havent had much luck in trying to find this done anywhere, and much of the advice is to go with mySQL. Though I am reluctant to due to the lack of Foreign Key support in mySQL and the fact that I have done alot with Access. I have read the DBCP tomcat support docs, but this is only geared towards mySQL, does such a thing exist for MS Access? Advance thanks JS --------------------------------------------------------------------- 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]
