test

Configuring JDBC/ODBC Drivers

AS/400 Toolbox Driver Configuration Properties

OTD Wizard: Database Connection Information

To connect to AS/400, use the information provided in Table 1–1 to complete the Connect to Database step of the JDBC/ODBC OTD Wizard. To access DB2, it is recommended to use the DB2 eWay Adapter or the DB2 Connect eWay Adapter.

Table 1–1 AS/400 Database Connection Information

Parameter 

Value 

Driver Jar Files 

jt400.jar

Driver Java Class Name 

com.ibm.as400.access.AS400JDBCDriver 

URL Connection String 

jdbc:as400://server-name:server-port/

Note –

NOTE: Default server port is 446.

User Name 

Login name of the account used to access the AS/400 database. 

Password 

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

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.