Cheers Filip, I didnt realise that DBCP would suppport Access. (1) Doesnt the driver need to be a jar file though??
(2) I thought I needed an actual JDBC driver for MS Access. (3) Does the DBCP support for MS Access Connection Pooling mean that I no longer need my ConnectionPoolServlets to manage the connections. I will read through the HOW-TOs again? Any more advice would be much appreciated JS > who needs foreign keys, they only slow your DB down anyway :) > > DBCP can support any DB, you will need an ODBC bridge for Access, then > you just give DBCP the odbc bridge driver info, and it should work > > Filip > >> -----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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
