The databaseName=nameOfDatabase attribute specifies a database path name for a connection.
You can use this attribute instead of specifying the database name after the subprotocol.
The nameOfDatabase value can be either an absolute path name or a path name relative to derby.system.home. For example, thisDB, databases/thisDB, and c:/databases/2014/january/thisDB can all be valid values.
The path separator in the connection URL is a forward slash (/), even in Windows path names. The nameOfDatabase value cannot contain a colon (:), except for the colon after the drive name in a Windows path name.
If you use a subsubprotocol to specify the database (for example, memory for an in-memory database), include the subsubprotocol as part of the databaseName attribute specification. For example:
jdbc:derby:;databaseName=memory:myDB
If the database name is specified both in the URL (as a subname) and as an attribute, the database name set as the subname has priority. For example, the following database connection URL connects to toursDB:
jdbc:derby:toursDB;databaseName=flightsDB
Allowing the database name to be set as an attribute allows the getPropertyInfo method to return a list of choices for the database name based on the set of databases known to Derby. For more information, see java.sql.Driver.getPropertyInfo method.
You can combine this attribute with all other attributes.
jdbc:derby:;databaseName=newDB;create=true