JDBC/ODBC Adapter User's Guide

Appendix A Section A.9
JDBC/ODBC Drivers Installing JDBC/ODBC Drivers
JDBC/ODBC eWay Adapter User’s Guide 129 Sun Microsystems, Inc.
A.9 Installing JDBC/ODBC Drivers
The database drivers specified in your projects need to be installed on both the
Enterprise Designer machine and the Logical host machine. When installing the drivers
on the Enterprise Designer machine, you must specify the absolute path to the driver.
When installing the drivers on the Logical Host, place the driver into the Logical Host
stcis directory:
<JavaCAPS51>\logicalhost\is\lib; or
<JavaCAPS51>\logicalhost\is\domains\domain1\lib
where <JavaCAPS51> is the location of your Sun Java Composite Application Platform
Suite installation.
The driver file must be copied to the latter folder if you are running multiple domains
and wish to specify a driver for each domain. Otherwise, you only need to copy the
driver file to the former folder address.
For procedures on how to install database drivers, see “Sample Projects Drivers” on
page 72.
ClassNamefor
OtherInterfaces
ServerName Server name of the machine hosting the database.
PortNumber <server-port>
Note: NOTE: Default server port is 6666 for the
Type-3 driver Gateway.
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 setURL#jdbc:teradata://<server-name>:<server-port>/
<database-server-name>##setDSName#<database-
server_name>##
Delimiter The default is #.
DataSourceName
MinPoolSize The default is 2.
MaxPoolSize The default is 10.
MaxIdleTime The default is 0.
Table 39 Teradata Driver Environment Properties (Continued)
Parameter Value