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 <server-port>
Note: NOTE: Default server port is 3306.
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.
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