beautypg.com

A.9 installing jdbc/odbc drivers, Installing jdbc/odbc drivers – Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 129

background image

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:

\logicalhost\is\lib; or

\logicalhost\is\domains\domain1\lib

where 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

Note:

NOTE: Default server port is 6666 for the
Type-3 driver Gateway.

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

setURL#jdbc:teradata://:/
##setDSName#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