tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chuck amadi <chuck.am...@breconbeacons.org>
Subject Re: Is there a native JDBC driver for MS Access?
Date Wed, 10 Apr 2002 08:30:36 GMT
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
>a.beech@bigpond.net.au
>
>
>----- Original Message -----
>From: "Matt Gregory" <matthew.gregory@skyleach.com>
>To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>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" <a.beech@bigpond.net.au>
>>To: "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
>>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
>>a.beech@bigpond.net.au
>>
>>
>>
>>
>>--
>>To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
>>For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
>>Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>
>>
>
>
>--
>To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
>For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
>Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>
>
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:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message