| Option | Description |
|---|---|
| Host | Specifies either the IP address or the hostname of the database server. |
| Port | Specifies the TCP port of the listener running on the database server. The default is 1521, which is the default port number when installing the Oracle database software. |
| User | Defines the user id used to connect to the database. |
| Password | Defines the password for the user id used to connect to the database. This password is case-insensitive. |
| SID | Specifies the Oracle System Identifier that refers to the instance of the Oracle database running on the server. |
| Schema | Optionally, specifies the name of the schema used.
Note: When using a schema, it is recommended that the schema name and user name be
the same.
|
| URL | Defines the URL format to connect to the database. |
| Option | Description |
|---|---|
| Tablespace | Specifies the tablespace within the Oracle BPM database. |
| Temporary Tablespace | Specifies the temporary tablespace within the Oracle BPM database. |
| Profile | Specifies the profile for the Oracle BPM database. Profiles are as a way to limit which users can connect to the database. |
This tab allows you to specify additional properties that are supported by the JDBC driver. Properties are defined using name/value pairs.
Runtime properties define the JDBC connection handling for Oracle BPM components when running outside a J2EE (for example, WebLogic Server). When running within a J2EE container, database connectivity information is supplied by the container itself.
| Option | Description |
|---|---|
| Maximum Pool Size | Specifies the maximum number of connections within the connection pool. Database connections are grouped together within a connection pool to improve performance. |
| Maximum connections per user | Specifies the maximum number of connections within the connection pool for each user. |
| Connection Idle Time (minutes) | Specifies how long a connection can be idle before it times out. |
| Minimum Pool Size | Specifies the minimum number of connections with the connection pool. |
| Maximum Opened Cursors | Specifies how many queries can be created for each connection. |