Did you try to close all the connections? It is a bit complicated with Spring, but I believe if you have every bean to set to "singleton=false", the connection might get reset.
Thanks. Carson Reinke [EMAIL PROTECTED] P: 248.333.7700 x108 -----Original Message----- From: AlexeyG [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 3:47 PM To: [email protected] Subject: MS Access LDB locks using JDBC-ODBC bridge and iBATIS Hello, I am attempting to use iBATIS and to access MS Access file via JDBC-ODBC bridge. (I am using Spring's "SqlMapClientDaoSupport," but that is probably irrelevant) All this runs on Tomcat... First time DB gets accessed the LDB lock file is created. From there on the only way I can remove the lock file is to kill the JVM... Any help is greatly appreciated... - general ideas/info on the way iBATIS behaves with JDBC-ODBC bridge and locks - maybe I can somehow get Spring to reset the bean? -- View this message in context: http://www.nabble.com/MS-Access-LDB-locks-using-JDBC-ODBC-bridge-and-iBA TIS-tf2017245.html#a5546027 Sent from the iBATIS - User - Java forum at Nabble.com.
