Re: Can I connect to an Access database?
At 12:26 AM 17/07/01, you wrote: The standard JDBC-ODBC bridge works fine (as far as it goes). Which is not very far - given that it's not a production-level driver. That said, access is not a production-level database, either ;) Seriously though, if you try to have more than one (a couple?) of connections open at once you'll start getting SQLExceptions all over the place. Jim - A On Mon, Jul 16, 2001 at 03:31:28PM -0500, Brandon Cruz wrote: Does anyone know of a free driver that I can use to connect via jdbc from Tomcat to a Microsoft Access database? I have looked in the database on java.sun.com, but there are 15 different choices. Just looking for some help on which direction to go. Is this simple, or should I stay away from connecting to access via jdbc entirely? Brandon Cruz Norvax Inc. www.norvax.com -- Alex Chaffee mailto:[EMAIL PROTECTED] jGuru - Java News and FAQs http://www.jguru.com/alex/ Creator of Gamelan http://www.gamelan.com/ Founder of Purple Technology http://www.purpletech.com/ Curator of Stinky Art Collective http://www.stinky.com/ -- * Jim Cheesman * Trabajo: [EMAIL PROTECTED] - (34)(91) 724 9200 x 2360 In retrospect it becomes clear that hindsight is definitely overrated
RE: Can I connect to an Access database?
-Original Message- From: Jim Cheesman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 3:07 AM To: [EMAIL PROTECTED] Subject: Re: Can I connect to an Access database? At 12:26 AM 17/07/01, you wrote: The standard JDBC-ODBC bridge works fine (as far as it goes). Which is not very far - given that it's not a production-level driver. That said, access is not a production-level database, either ;) Seriously though, if you try to have more than one (a couple?) of connections open at once you'll start getting SQLExceptions all over the place. Only if you're lucky. More likely is that you will become familiar with Dr. Watson and his friends the General Protection Fault and Illegal Access Error. Really, the JDBC-ODBC bridge is not thread safe. You can check out Sun's BugParade where they acknowledge the bug and indicate that it will not be fixed. Randy
RE: Can I connect to an Access database?
At 01:22 PM 17/07/01, you wrote: -Original Message- From: Jim Cheesman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 3:07 AM To: [EMAIL PROTECTED] Subject: Re: Can I connect to an Access database? At 12:26 AM 17/07/01, you wrote: The standard JDBC-ODBC bridge works fine (as far as it goes). Which is not very far - given that it's not a production-level driver. That said, access is not a production-level database, either ;) Seriously though, if you try to have more than one (a couple?) of connections open at once you'll start getting SQLExceptions all over the place. Only if you're lucky. More likely is that you will become familiar with Dr. Watson and his friends the General Protection Fault and Illegal Access Error. Alright, I confess I haven't used jdbc:odbc with access - though I have used it extensively with DB2 and SQL Server. In those cases I get SQLExceptionS rather than Dr.Watson -- * Jim Cheesman * Trabajo: [EMAIL PROTECTED] - (34)(91) 724 9200 x 2360 In retrospect it becomes clear that hindsight is definitely overrated
Can I connect to an Access database?
Does anyone know of a free driver that I can use to connect via jdbc from Tomcat to a Microsoft Access database? I have looked in the database on java.sun.com, but there are 15 different choices. Just looking for some help on which direction to go. Is this simple, or should I stay away from connecting to access via jdbc entirely? Brandon Cruz Norvax Inc. www.norvax.com
Re: Can I connect to an Access database?
The standard JDBC-ODBC bridge works fine (as far as it goes). - A On Mon, Jul 16, 2001 at 03:31:28PM -0500, Brandon Cruz wrote: Does anyone know of a free driver that I can use to connect via jdbc from Tomcat to a Microsoft Access database? I have looked in the database on java.sun.com, but there are 15 different choices. Just looking for some help on which direction to go. Is this simple, or should I stay away from connecting to access via jdbc entirely? Brandon Cruz Norvax Inc. www.norvax.com -- Alex Chaffee mailto:[EMAIL PROTECTED] jGuru - Java News and FAQs http://www.jguru.com/alex/ Creator of Gamelan http://www.gamelan.com/ Founder of Purple Technology http://www.purpletech.com/ Curator of Stinky Art Collective http://www.stinky.com/