tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Utt" <s...@strateja.com>
Subject Re: Lock on database file not being released...
Date Mon, 08 Dec 2003 02:10:33 GMT
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" <gsexton@mhsoftware.com>
To: "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
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:yaakov.y.chaikin@baesystems.com]
> 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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message