Sun Microsystems eWay JDBC/ODBC Adapter - Manual (Page 122)

Appendix A Section A.4
JDBC/ODBC Drivers PostgreSQL Driver
JDBC/ODBC eWay Adapter User’s Guide 122 Sun Microsystems, Inc.
Note: It is not mandatory to enter driver properties in the Outbound JDBC eWay
Environment properties for MySQL.
A.4
PostgreSQL Driver
Configuration Properties:
ƒ OTD Wizard: Database Connection Information on page 122
ƒ Environment Properties on page 123
A.4.1
OTD Wizard: Database Connection Information
To connect to SQL, use the information provided in Table 30 to complete the Connect to
Database step of the JDBC/ODBC OTD Wizard. To access SQL, it is recommended to
use the SQL Server eWay Adapter.
ServerName Server name of the machine hosting the database.
PortNumber
Note: NOTE: Default server port is 3306.
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
Parameter Value
Driver Jar Files postgresql-8.0-310.jdbc3.jar
Driver Java Class Name org.postgresql.Driver
Table 29 MySQL Connector/J Driver Environment Properties (Continued)
Parameter Value