Working with the database connection URL attributes

You specify attributes on the Derby connection URL (see Derby JDBC database connection URL). The examples in this section use the syntax of the connection URL for use in an embedded environment. You can also specify these same attributes and values on the client connection URL if you are using Derby as a database server. For more information, see the Derby Server and Administration Guide.

You can also set these attributes by passing a Properties object along with a connection URL to DriverManager.getConnection when obtaining a connection; see "Specifying Attributes in a Properties Object".

All attributes are optional. For detailed information about the connection URL syntax and attributes, see "Derby Database Connection URL Syntax"in the Derby Reference Manual.

You can specify the following attributes:

• bootPassword=key
• create=true
• databaseName=nameofDatabase
• dataEncryption=true
• encryptionProvider=providerName
• encryptionAlgorithm=algorithm
• territory=ll_CC
• logDevice=logDirectoryPath
• createFrom=BackupPath
• restoreFrom=BackupPath
• rollForwardrecoveryFrom=BackupPath
• password=userPassword
• shutdown=true
• user=userName

• Using the databaseName attribute
  
• Shutting down Derby or an individual database
  
• Creating and accessing a database
  
• Providing a user name and password
  
• Encrypting a database when you create it
  
• Booting an encrypted database
  
• Specifying attributes in a properties object