| Property | Description |
|---|---|
| Host | Specifies the hostname or IP address of the database server. |
| Port | Specifies the TCP port of the Oracle listener running on the Oracle database server. The default is 1521, which is the Oracle default port number when installing the Oracle database software. |
| User | Specifies the case-insensitive default user name used to connect to your Oracle database. |
| Password | Specifies the case-insensitive password used to connect to your Oracle database. |
| SID | Specifies the Oracle System Identifier that refers to the instance of the Oracle database running on the server. |
| Schema (optional) | Specifies the schema of the Oracle database server. |
| URL | Defines the URL used to connect to your database. |
| Property | Description |
|---|---|
| Tablespace | Specifies the tablespace Oracle BPM uses to create new tables. |
| Temporary Tablespace | Specifies the temporary tablespace Oracle BPM uses to create new tables. |
| Profile | Specifies the profile Oracle BPM assigns to the users it creates. |
| Use TimeStamp for Date Columns | Specifies if a column of type Date stores the date and the time. If unselected it only stores the date. |
You can define name/value pairs to provide additional configuration properties to your database. See your vendor's documentation for more information.
| 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. |