--- "Craig R. McClanahan" <[EMAIL PROTECTED]> wrote: > > > On Mon, 8 Apr 2002, Adrian Beech wrote: > > > Date: Mon, 8 Apr 2002 10:38:45 +1000 > > From: Adrian Beech <[EMAIL PROTECTED]> > > Reply-To: Tomcat Users List <[EMAIL PROTECTED]> > > To: Tomcat Users List <[EMAIL PROTECTED]> > > Subject: Re: Is there a native JDBC driver for MS Access? > > > > Ummmmm, okay then how stable is the JDBC/ODBC bridge? As I previously > > mentioned in my initial posting some bits and peices that I've read suggest > > that this method of connecting to a DB back end is, or can be, a little > > dodgy. The comments basically revolved around the premise that the bridge > > is not capable of being threaded and it is considered by Sun to still be > > experimental. I got the impression that there is potential for data loss > or > > corruption along with performance related issues. > > > > The JDBC/ODBC bridge is not appropriate for use in a multithreaded > environment like a servlet container. Also, lots of people have had > problems trying to use MS Access (designed for personal desktop use) in > environments like this, even with a for-pay JDBC driver. > > I'd start by choosing a different database.
How about MySQL (http://www.mysql.org) ? They have a type 4 JDBC driver. Is this OK in a multithreaded environment ? > > > I guess I really need to know if it is reasonable to use Tomcat to host an > > environment that relies on this sort of DB connectivity. > > > > Adrian > > [EMAIL PROTECTED] > > > > Craig > Sriram __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
