test

Configuring JDBC/ODBC Drivers

Environment Properties

Use Table 1–2 to configure the environment properties for the specified JDBC/ODBC driver.

Table 1–2 AS/400 Database Environment Properties

Parameter 

Value 

Description 

JDBC Connection Pool Datasource 

ClassName 

com.ibm.as400.access.AS400JDBCConnectionPoolDataSource 

ClassNamefor 

OtherInterfaces 

 

ServerName 

Server name of the machine hosting the database. 

PortNumber 

server-port

Note –

NOTE: Default server port is 446.

DatabaseName 

 

User 

Login name of the account used to access the database. 

Password 

Password associated with the login account name used to connect to the database. 

DriverProperties 

 

Delimiter 

The default is #. 

DataSourceName 

 

MinPoolSize 

The default is 0.

MaxPoolSize 

The default is 10.

MaxIdleTime 

The default is 0.