Server connection properties

To access a data source outside of the appliance, define the properties of the server.

Table 1. Server connection properties
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.

Table 2. Tuning properties
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:
Entire pool

When a stale connection is detected, all connections in the pool are marked stale, and when no longer in use, are closed. This is the default option.

Failing connection only

When a stale connection is detected, only the connection that was found to be bad is closed.

Validate all connections

When a stale connection is detected, connections are tested and the ones that are found to be bad are closed.

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.