To access a data source outside of the appliance, define the properties of the server.
Property | Description |
---|---|
Name | Specifies the name for the server connection. Ensure that the
name is unique. Select this name when you define the policy
information point. Note: The server connection name must begin with
an alphabetic character. Do not use control characters, leading
and trailing blanks, and the following special characters ~ ! @
# $ % ^ & * ( ) + | ` = \ ; " ' < > ? , [ ] { } /
anywhere in the name.
|
Description | Describes the server connection. This property is optional. |
Type | Shows the server connection type. (Read only) |
JNDI ID (Oracle, DB2, solidDB only) | Specifies the JNDI ID that the server uses. Ensure that the ID is unique. Use only alphanumeric characters: a-b, A-B, 0-9 |
Server name (Oracle, DB2, solidDB only) | Specifies the name or IP address for the server. |
Port | Specifies the port number where the connection to the server can be made. |
User name (Oracle, DB2, solidDB only) | Specifies the user name that has the correct permissions to access the resources. |
Password (Oracle, DB2, solidDB only) | Specifies the password to access the server. |
SSL | Specifies whether SSL is used for connecting to the server. Select True or False. The default value is True. See Configuring SSL connections. |
Driver type (Oracle only) | Specifies the driver type. Select Thin or OCI. The default value is Thin. |
Service name (Oracle only) | Specifies the name of the service. |
Database name (DB2 only) | Specifies the name of the database. |
Host name (LDAP only) | Specifies the host name or IP address of the LDAP server. |
Bind DN (LDAP only) | Specifies the LDAP distinguished name (DN) that is used when binding, or signing on, to the LDAP server. |
Bind Password (LDAP only) | Specifies the password for the LDAP bind DN. |
The properties in the following table are connection manager properties. The defaults that are listed are the current known defaults. All tuning properties are optional.
Property | Description |
---|---|
Aged timeout (seconds) (Oracle, DB2, solidDB only) | Specifies the amount of time, in seconds, before a physical connection is discarded by pool maintenance. Specify -1 to disable this timeout. The default is -1. |
Connection timeout (seconds) | Specifies the amount of time, in seconds, after which a
connection times out. For Oracle, DB2,and solidDB, specify -1 to disable this timeout. The default is 30 seconds. For LDAP, specify only integers, 1 or greater. The default is 120 seconds. |
Max idle time (seconds) (Oracle, DB2, solidDB only) | Specifies the maximum amount of time, in seconds, after which an unused or idle connection is discarded during pool maintenance. Specify -1 to disable this timeout. The default is 1800 seconds. |
Reap time (seconds) (Oracle, DB2, solidDB only) | Specifies the amount of time, in seconds, between runs of the pool maintenance thread. Specify -1 to disable pool maintenance. The default is 180 seconds. |
Max pool size (Oracle, DB2, solidDB only) | Specifies the maximum number of physical connections for a pool. Specify 0 for unlimited. The default is 50. |
Min pool size (Oracle, DB2, solidDB only) | Specifies the minimum number of physical connections to maintain in a pool. The aged timeout can override the minimum. |
Purge policy (Oracle, DB2, solidDB only) | Specifies which connections to delete when a stale connection is
detected in the pool. Select from the following options:
|
Max connections per thread (Oracle, DB2, solidDB only) | Specifies the limit of open connections on each thread. |
Cache connections per thread (Oracle, DB2, solidDB only) | Specifies the number of cache connections for each thread. |