We are using JRUN 2.3.3 and are trying to connect to a Microsoft Access
Database. We are using Java 1.2 and Windows NT 4.0. We have tried:
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection( "jdbc:odbc:WadeTest" );
If we just retrieve data, everything seems fine. If we update, or insert,
Dr. Watson is called about every 3d time, and JRUN dies. We had similar
problems with Oracle until we used their JDBC driver. A discussion on
Alliare's site indicated that the JDBC:ODBC driver was not thread safe and
that would be problematic with Servlets.
http://www.allaire.com/Handlers/index.cfm?ID=12409&Method=Full
http://java.sun.com/products/jdbc/faq.html#20
Is there an alternative driver that works with MS Access. We could switch
to the MS Java, and the problem would go away, but we also kiss off
portability. (Not a good choice as we are using 1.2 features.) I once
thought there was nothing I should be able to do to crash Java, but I was
wrong. Am I really the only person having this problem? Any help or
guidance would be appreciated.
Greg
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
