db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Narayanan <V.Naraya...@Sun.COM>
Subject Re: Closig connection vs shutting down derby
Date Mon, 10 Mar 2008 06:26:36 GMT
musky wrote:
> I have a doubt:
>
> i an application after obtaining a connection to a database and after i
> perform all required transactions on the tables of the database do i need to
> shutdown the database or is it enough if i just close the connection.
>
> i tried shutting down the database but i get the
> nontransientconnectionexception sql state:08006
>
> please help.
>
> Thank you.
> Varun
>   
I found this

"Once a database has been booted within a Derby system, it remains 
active until the Derby system has been shut down or until you shut down 
the database individually."

here

http://db.apache.org/derby/docs/dev/devguide/cdevdvlp27715.html

So while running in the embedded mode of operation if you have booted 
the database from one application and without
shutting down this database in this application you try  a boot from 
another application you run into dangers of
double booting system behaviour

http://db.apache.org/derby/docs/dev/devguide/cdevdvlp20458.html

I read this

"A successful shutdown always results in an /SQLException/ to indicate 
that Derby has shut down and that there is no other exception."

here

http://db.apache.org/derby/docs/dev/devguide/tdevdvlp40464.html

Narayanan

Mime
View raw message