DBA > Job Interview Questions > DERBY Java Database FAQs

How to Work with the Database Connection URL Att

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to Work 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.

You can also set these attributes by passing a Properties object along with a connection URL to DriverManager.getConnection when obtaining a connection;

All attributes are optional. For detailed information about the connection URL syntax and attributes

. 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

(Continued on next question...)

Other Job Interview Questions