beautypg.com

A.4.2 environment properties, Environment properties – Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 123

background image

Appendix A

Section A.4

JDBC/ODBC Drivers

PostgreSQL Driver

JDBC/ODBC eWay Adapter User’s Guide

123

Sun Microsystems, Inc.

A.4.2

Environment Properties

Use Table 31 to configure the environment properties for the specified JDBC/ODBC
driver.

Note:

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

URL Connection String

jdbc:postgresql://:/name>

Note:

NOTE: Default server port is 5432.

User Name

Login name of the account used to access the database.

Password

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

Table 31 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

Note:

NOTE: Default server port is 5432.

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.

Table 30 PostgreSQL Driver Connection Information (Continued)

Parameter

Value