shutdown=true attribute shutdown=true database connection URL attribute
Function

Shuts down the specified database if you specify a databaseName. (Reconnecting to the database reboots the database.) For a database for which authentication and SQL authorization are both enabled, only the database owner can perform shutdown of that database. Please see "Enabling user authentication" and "Setting the SQL standard authorization mode" in the for more information.

Shuts down the entire system if and only if you do not specify a databaseName.

When you are shutting down a single database, it lets perform a final checkpoint on the database.

When you are shutting down a system, it lets perform a final checkpoint on all system databases, deregister the JDBC driver, and shut down within the JVM before the JVM exits. A successful shutdown always results in an SQLException indicating that has shut down and that there is no connection. Once is shut down, you can restart it by reloading the driver. For details on restarting , see "Shutting down the system" in the .

Checkpointing means writing all data and transaction information to disk so that no recovery needs to be performed at the next connection.

Used to shut down the entire system only when it is embedded in an application. Any request to the DriverManager with a shutdown=true attribute raises an exception.

-- shuts down entire system jdbc:derby:;shutdown=true -- shuts down salesDB (authentication not enabled) jdbc:derby:salesDB;shutdown=true