db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Henrique Gomes <li...@farol.co.pt>
Subject Re: shutting down derby db in tomcat
Date Thu, 11 Nov 2004 11:33:25 GMT

On Nov 11, 2004, at 8:00, SML wrote:

> What is the 'best' way to deal with shutting down a derby db when the
> data is used in jsp pages?  Do you shutdown when tomcat exits? What
> happens when either the derby db or tomcat container crashes and
> bypasses the shutdown script? Any problems, issues, corrections needed
> on a db crash?

I generally use the Destroy() method of the servlet. Look on the docs
for the way to safely shutdown a derby database.

> On a related question, is it better to open/close the db connection for
> different queries on different jsp pages? or to keep a persistent
> connection throughout the session?

No simple answer, depends on your app.

View raw message