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
