At this point, I would have to say the answer is to get a real database. FWIW, I use access in our application and except for the ImplicitUserSync and UserCommitSync issue have never really had any problems. Of course you could be running into problems specific to your version of Java, or Jet.
-----Original Message----- From: Chaikin, Yaakov Y (US SSA) [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 8:43 AM To: Tomcat Users List Subject: RE: Lock on database file not being released... Hi, I did as you said and adjusted those values for the odbc. Same result. The database file is still showing as locked. Yaakov Chaikin Software Engineer BAE SYSTEMS 301-838-6899 (phone) 301-838-6802 (fax) [EMAIL PROTECTED] > -----Original Message----- > From: George Sexton [mailto:[EMAIL PROTECTED] > Sent: Monday, December 08, 2003 1:11 AM > To: 'Tomcat Users List' > Subject: RE: Lock on database file not being released... > > In the ODBC connection entry in the registry, or by using the ODBC > Connection editor, change those two parameters. They are probably set > for Yes and should be set to No. > > If you are not using an ODBC Connection entry, then you need to pass > these as arguments in the connection string. > > -----Original Message----- > From: Chaikin, Yaakov Y (US SSA) > [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 07, 2003 11:07 PM > To: Tomcat Users List > Subject: RE: Lock on database file not being released... > > > How do I do that in server.xml file? Is that what you are suggesting? > Specifying other parameters for the connection pooling? > > Please elaborate on what you think I should do. > > Thanks. > > Yaakov Chaikin > Software Engineer > BAE SYSTEMS > 301-838-6899 (phone) > 301-838-6802 (fax) > [EMAIL PROTECTED] > > > > -----Original Message----- > > From: George Sexton [mailto:[EMAIL PROTECTED] > > Sent: Sunday, December 07, 2003 11:28 PM > > To: 'Tomcat Users List' > > Subject: RE: Lock on database file not being released... > > > > OK, I now think I know the issue. Try changing the entries for the > ODBC > > connection. Specifically change: > > > > ImplicitCommitSync > > > > And > > > > UserCommitSync > > > > The docs are inconsistent on their usage, and I think the drivers vary > > depending upon the version of the Jet engine you are using. > > > > Anyhow, adjust these and see what happens. > > > > > > > > -----Original Message----- > > From: Chaikin, Yaakov Y (US SSA) > > [mailto:[EMAIL PROTECTED] > > Sent: Sunday, December 07, 2003 2:13 PM > > To: Tomcat Users List > > Subject: RE: Lock on database file not being released... > > > > > > > > However, I have used this driver before in a standalone app and > when > > you > > > close a connection, it certainly does release the lock on the > database > > file. > > > > > > This makes me think, you didn't use pooling in this standalone app. > > Therefor > > > check weather you close all your ResultSets and Statements. In > > standalone > > > apps where no pooling is involved, they are caught by the garbage > > collector, > > > but not in connection pooling. > > > > > > Trapped into this myself. > > > > Steffen, > > > > I tried what you said and closed the ResultSet and Statement before I > > close the Connection. Still same affect. > > > > Any other ideas anyone? > > > > I highly doubt it's the driver. I would bet that I am doing something > > wrong. I just can't figure out what it is. > > > > Thanks, > > Yaakov. > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
