Sorry, but for some reason the welcome.jsp didn't get attached to the previous email.
Trying again. Yaakov Chaikin Software Engineer BAE SYSTEMS 301-838-6899 (phone) 301-838-6802 (fax) [EMAIL PROTECTED] > -----Original Message----- > From: Sean Utt [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 07, 2003 9:11 PM > To: Tomcat Users List > Subject: Re: Lock on database file not being released... > > Hi, > > Is your jsp/servlet forwarding or redirecting to another jsp/servlet/html > page before close() is called on the connection? > Dreamweaver will automagically create jsp pages that fall prey to this > gotcha. If you have access to the log files, log the opening and closing of > the connection, and see if what you think is happening is in fact happening. > > Sean > > ----- Original Message ----- > From: "George Sexton" <[EMAIL PROTECTED]> > To: "'Tomcat Users List'" <[EMAIL PROTECTED]> > Sent: Sunday, December 07, 2003 1:15 PM > Subject: RE: Lock on database file not being released... > > > > One other question. What is the setting of AutoCommit? Are you setting > > it to TRUE? > > > > -----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]