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>
|