Configuring JDBC/ODBC Drivers

Environment Properties

Use Table 1–16 to configure the environment properties for the specified JDBC/ODBC driver.

Table 1–16 Teradata Driver Environment Properties

Parameter 

Value 

Description 

JDBC Connection Pool Datasource 

ClassName 

com.ncr.teradata.TeraConnectionPoolDataSource 

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.