Description

The description of the database. 

A valid string. The configured default is JDBC Connection Pool Datasource.

ClassName

Specifies the Java class in the JDBC driver that is used to implement the ConnectionPoolDataSource, XADataSource interface. Change as needed for your driver.

A valid class name. 

For example: 

com.ibm.as400.access.AS400JDBC 

ConnectionPoolDataSource 

See the JDBC/ODBC Drivers section for some of the popular drivers you can use with this adapter. 

ClassNamefor 

OtherInterfaces 

For components such as eTL that do not use ConnectionPoolDataSource, use this entry to enter the name of the driver class. This entry is not used by the JDBC Adapter.

A valid class name. 

ServerName 

This setting specifies the host name of the external database server. 

Any valid string. 

PortNumber

Specifies the I/O port number on which the server is listening for connection requests. 

A valid port number. 

DatabaseName

Specifies the name of the database instance. 

Any valid string. 

User

Specifies the user name the adapter uses to connect to the database. 

Any valid string. 

Password

Specifies the password used to access the database. 

Any valid string. 

DriverProperties

The Connection Pool DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will need to be identified in the Driver Properties. You must ensure that the driver is installed on both the app server machine and Java CAPS IDE. 

Set the driver properties according to driver vendor’s instruction. For example: 

setDefTdpName#DBSQL##setWorkspace#Navigator## 

Delimiter

This is the delimiter character to be used in the DriverProperties prompt. 

The default is #.

DataSource 

name 

Specifies the name of the XADataSource or ConnectionPoolDataSource implementation, to which the DataSource object delegates behind the scenes when there is connection pooling or distributed transaction management being done.

The name of the XADataSource or ConnectionPoolDataSource implementation.

This property is Optional, in most cases, leave this box empty. 

MinPoolSize

Specifies the minimum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there is no maximum. 

The pool size you set depends on the transaction volume and response time of the application. If the pool size is too big, you may end up with too many connections with the database. 

A valid numeric value. The default is 0.

MaxPoolSize

Specifies the maximum number of physical connections the pool should keep available at all times. 0 (zero) indicates that there is no maximum. 

If the pool size is too big, you may end up with too many connections with the database. The pool size depends on the transaction volume and response time. 

A valid numeric value. The default is 10.

MaxIdleTime

Specifies the maximum number of seconds that a physical connection may remain unused before it is closed. 0 (zero) indicates that there is no limit. 

A valid numeric value. The default is 0.

ConnectionRetries

Specifies the number of retries to establish a connection upon failure to acquire one. 

A valid numeric value. The default is 0.

ConnectionRetryInterval

Specifies the milliseconds of pause before each attempt to reaccess the database. This setting is used in conjunction with the ’Connection Retries’ setting. 

For example: In the event that the adapter cannot connect to the Database, the adapter will try to reconnect to the database 10 times in 5 seconds apart when the Connection Retries is 10 and the Connection Retry Interval is 5000 

A valid numeric value. The default is 1000.