Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | JDBC Driver Specific Properties | Teradata | Teradata JDBC Type 4 Driver
 
Teradata JDBC Type 4 Driver
DataSource
Transaction Type
DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION
com.ncr.teradata.TeraDataSource
Transaction Isolation Level Setting
Specify the transaction isolation level properties in the Other Properties field:
Parameter
Description
TransactionIsolation
*Dirty read does not function if you set the transaction isolation level to 1.
*Non-repeatable read and phantom read cannot be avoided even if you set the transaction isolation level to 8.
For example:
TransactionIsolation=Transaction_Isolation_Level;
Other Properties
Specify the driver-dependent parameters based on the JDBC driver and the transaction type that the connection is using in the Other Properties field:
Parameter
Description
DSName
Teradata database server name.
DSName=value
Required Connection Property Fields
Driver Name
Server Name
User
Password
Database Name
Port Number
Network Protocol
Teradata Type 4 v03.04.00 (for V2R5 and V2R6)
No
Yes
Yes
No
No
No
Teradata Type 4 v12.00.00.01 (for R12.0)
No
Yes
Yes
Yes
No
No
Teradata Type 4 v13.00.00.20 (for R13.0, R13.10, and R14.0)
No
Yes
Yes
Yes
No
No
For more information about limitation, see Limitations.