On 10/10/12 6:35 PM, Oskar Zinger wrote:
Hi Derby Community,

I'm having some difficulties resetting a Derby Database without restarting the whole application (JVM).

I'm deploying Derby Network Server. My application has a service that executes shutdown / start of the Derby Network Server on demand.

// code here to clear Derby connection pool
derbyServer.shutdown();
derbyServer = null;

The above does not reset the Derby database.
Hi Oskar,

This may be relevant to the problem you are seeing: When you shutdown the server, that does not shut down any booted databases and it does not shutdown the Derby engine. Instructions for shutting down a single database and the entire engine can be found in the Derby Developer's Guide in the section titled "Shutting down Derby or an individual database": http://db.apache.org/derby/docs/10.9/devguide/

Hope this helps,
-Rick

For example, what if my database becomes corrupted and I would like to stop the service, remove the database, and copy over my new template database (or recreate the database) without having to restart my whole application. Is this possible?

Thanks,
Oskar Zinger

Reply via email to