Derby Database Driver Properties

You can specify the following properties for your Derby database:

Basic

Property Description
Database Path The path to the file that contains the database.
Requires Authentication Specifies if you need to provide a user and password to connect to the database.
User Specifies the case-sensitive user name used to connect to your Derby database.
Password Specifies the case-sensitive password used to connect to your Derby database.
Schema Specifies the schema of the derby database server.
URL The URL to connect to the database. You cannot edit this field directly, the URL is formed using the database path you define.

Properties

You can define name/value pairs to provide additional configuration properties to your database. See your vendor's documentation for more information.

Note: Connection property names are case-insensitive.

Runtime

Property Description
Maximum Pool Size Determines the maximum number of connections that can be created within the connection pool.
Maximum Connections Per User Determines the maximum number of connections that can be created per user.
Connection Idle Time (minutes) Specifies the maximum time, in minutes, that a database connection can remain idle before it is closed automatically.
Minimum Pool Size Determines the minimum number of connections that can be created within a connection pool.
Maximum Opened Cursors Determines the maximum number of cursors that can be opened at one time.