How to properly shutdown Embedded Derby database with BoneCP connection pool

Question

With Derby you're specifically suppose to call:

DriverManager.getConnection("jdbc:derby:myDatabase;shutdown=true");

When you want to shutdown the database. However with BoneCP you do:

BoneCPConfig config = new BoneCPConfig();
config.setJdbcUrl("jdbc:derby:myDatabase");
config.setXXX(...);
... 
BoneCP connectionPool = new BoneCP(config);

// shutdown connection pool
connectionPool.shutdown();

However with derby you need to call the shutdown command otherwise you can get some errors

So the question is how do I call that shutdown connection string within the BoneCP framework?

can't you simply call `DriverManager.getConnection("jdbc:derby:myDatabase;shutdown=true");` after `connectionPool.shutdown()?` — oers, Jun 15 '12 at 07:27
No, doing that results in java.sql.SQLNonTransientConnectionException — Stephane Grenier, Jun 20 '12 at 20:31
According go the linker question and the docs an exception has to be expected — oers, Jun 21 '12 at 16:23

score 0 · Accepted Answer · edited May 23 '17 at 12:18

In another related newer question, the following appears to be the same cause: "Unless you are running v0.8.1-beta2 or greater, set "disableConnectionTracking" to true in your config."

In other words you need both the derby connection URL as well as the proper config for BoneCP, at least for now...

Please note that you should expect an exception when SUCCESSFULLY shutting down derby: "A successful shutdown always results in an SQLException to indicate that Derby has shut down and that there is no other exception."

How to properly shutdown Embedded Derby database with BoneCP connection pool

1 Answers1