Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 32642 invoked from network); 7 Apr 2002 01:09:06 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 7 Apr 2002 01:09:06 -0000 Received: (qmail 14889 invoked by uid 97); 7 Apr 2002 01:08:58 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org Received: (qmail 14873 invoked by uid 97); 7 Apr 2002 01:08:57 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 14862 invoked from network); 7 Apr 2002 01:08:57 -0000 Date: Sat, 6 Apr 2002 17:08:47 -0800 (PST) From: "Craig R. McClanahan" To: Tomcat Users List Subject: Re: Is there a native JDBC driver for MS Access? In-Reply-To: <01d201c1de95$bdd7e2a0$0300a8c0@babylon> Message-ID: <20020406170630.Q82993-100000@icarus.apache.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Rating: localhost 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N On Mon, 8 Apr 2002, Adrian Beech wrote: > Date: Mon, 8 Apr 2002 10:38:45 +1000 > From: Adrian Beech > Reply-To: Tomcat Users List > To: Tomcat Users List > 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. > 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 > Craig -- To unsubscribe: For additional commands: Troubles with the list: