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]
