Subject: Problem with M$ Access database connections. From: "David Bolsover" <[EMAIL PROTECTED]> === Hi all
System: W2K Tomcat 4.0.1 Struts 1.0 Microsoft Access with sun.jdbc.odbc.JdbcOdbcDriver diver I found a problem a week or so back that has had me puzzled. In order to support a clients existing database, I have been forced to use a Realm based authentication against a M$ Access database. While testing, I had several testapps installed under Tomcat connecting to one or more jdbc:odbc links to Access databases. Various action classes make calls to the Access db's to create/edit user profiles/passwords. I have found that if I have more than one app connecting to an Access db, calls to con.close() will invariably throw exceptions and occasionally will even crash the JVM hosting Tomcat. Has anyone else seen similar problems with the above configuration and have any hints as to how I might solve the problem (short of changing to another db)? Davd Bolsover -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
