Adrian Beech wrote: >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. > >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] > > >----- Original Message ----- >From: "Matt Gregory" <[EMAIL PROTECTED]> >To: "Tomcat Users List" <[EMAIL PROTECTED]> >Sent: Saturday, April 06, 2002 11:06 PM >Subject: Re: Is there a native JDBC driver for MS Access? > > >>No, you are forced to use the JDBC/ODBC bridge or purchase one of the >>proprietary drivers available. I know there are Paradox, FoxPro and dBase >>IV drivers but I have not seen any for Access. >> >>----- Original Message ----- >>From: "Adrian Beech" <[EMAIL PROTECTED]> >>To: "'Tomcat Users List'" <[EMAIL PROTECTED]> >>Sent: Sunday, April 07, 2002 6:47 AM >>Subject: Is there a native JDBC driver for MS Access? >> >> >>G'day all, >> >>Is there a native JDBC driver for MS Access? A few postings I've seen in >>the list archive make mentioned that the JDBC/ODBC bridge is a bit dodgy. >> >>I have Tomcat 4.03 running as a standalone on a Win 2k pro box with JDK >>1.3.1 installed. >> >>I'm rather new to Tomcat, JSP, JDBC, etc... >> >>Any help would be appreciated. >> >>Adrian Beech >>[EMAIL PROTECTED] >> >> >> >> >>-- >>To unsubscribe: <mailto:[EMAIL PROTECTED]> >>For additional commands: <mailto:[EMAIL PROTECTED]> >>Troubles with the list: <mailto:[EMAIL PROTECTED]> >> > > >-- >To unsubscribe: <mailto:[EMAIL PROTECTED]> >For additional commands: <mailto:[EMAIL PROTECTED]> >Troubles with the list: <mailto:[EMAIL PROTECTED]> > I was under the impression that it was recommended that you obtain a commercial JDBC driver from a vendor such as your RDBMS /middleware vendor as the JDBC-ODBC driver is usaually used for experimental use or if no other is available. Anyway there is mysql odbc which works fine with Mysql back-end and front-end M$ Aceess 2000.
Cheers Chuck Amadi Systems Programmer -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>