test

Configuring JDBC/ODBC Drivers

Environment Properties

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

Table 1–8 PostgreSQL Driver Environment Properties

Parameter 

Value 

Description 

JDBC Connection Pool Datasource 

ClassName 

org.postgresql.jdbc3.Jdbc3ConnectionPool 

ClassNamefor 

OtherInterfaces 

 

ServerName 

Server name of the machine hosting the database. 

PortNumber 

server-port

Note –

NOTE: Default server port is 5432.

DatabaseName 

database-name

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.

Note –

It is not mandatory to enter driver properties in the Outbound JDBC eWay Environment properties for PostgreSQL.