# shutdown=true

#### Function

Shuts down the specified database if you specify a databaseName. (Reconnecting to the database reboots the database.)

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

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

When you are shutting down a system, it lets Derby 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 Derby has shut down and that there is no connection. Once Derby is shut down, you can restart it by reloading the driver. For details on restarting Derby, see "Shutting Down the System" in Chapter 1 of the Derby Developer's Guide.

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.
Note: Any request to the DriverManager with a shutdown=true attribute raises an exception.

    -- shuts down entire system
    jdbc:derby:;shutdown=true
    -- shuts down salesDB
    jdbc:derby:salesDB;shutdown=true

Parent topic: Setting attributes for the database connection URL
Related reference
bootPassword=key
create=true
createFrom=Path
databaseName=nameofDatabase
dataEncryption=true
encryptionKey=<key>
encryptionProvider=providerName
encryptionAlgorithm=algorithm
logDevice=logDirectoryPath
newEncryptionKey= <key>
newBootPassword = <new password>
password=userPassword
restoreFrom=Path
rollForwardRecoveryFrom=Path
territory=ll_CC
user=userName
(no attributes)