Sun Microsystems JDBC/ODBC Adapter manual Installing JDBC/ODBC Drivers

Models: JDBC/ODBC Adapter

1 133
Download 133 pages 48.36 Kb
Page 129
Image 129

Appendix A

Section A.9

JDBC/ODBC Drivers

Installing JDBC/ODBC Drivers

Table 39 Teradata Driver Environment Properties (Continued)

Parameter

Value

 

 

 

 

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.

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.

JDBC/ODBC eWay Adapter User’s Guide

129

Sun Microsystems, Inc.

Page 129
Image 129
Sun Microsystems JDBC/ODBC Adapter manual Installing JDBC/ODBC Drivers