JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Configuring JDBC/ODBC Drivers for Oracle Java CAPS     Java CAPS Documentation
search filter icon
search icon

Document Information

1.  Configuring JDBC/ODBC Drivers

About JDBC/ODBC Drivers

Configuring JDBC/ODBC Drivers

AS/400 Toolbox Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Attunity Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

MySQL Connector/J Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

PostgreSQL Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Sybase JConnect Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Sequelink DataDirect Informix ODBC Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Sequelink DataDirect MS Access ODBC Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Teradata Driver Configuration Properties

OTD Wizard: Database Connection Information

Environment Properties

Troubleshooting

Installing JDBC/ODBC Drivers

Attunity Driver Configuration Properties

OTD Wizard: Database Connection Information

To connect to Attunity, use the information provided in Table 1-3 to complete the Connect to Database step of the JDBC/ODBC OTD Wizard.

Table 1-3 Attunity Driver Database Connection Information

Parameter
Value
Driver Jar Files
nvjdbc2.jar
Driver Java Class Name
com.attunity.jdbc.NvDriver
URL Connection String
jdbc:attconnect://server-name;DefTdpName=database-logical-name; OneTdpMode=1

Note - The database-logical-name is created in the Attunity server.


User Name
Leave password field blank. Value configured when the database entry is created in the Attunity Server.
Password
Leave password field blank. Value configured when the database entry is created in the Attunity Server.

Environment Properties

Use Table 1-4 to configure the environment properties for the specified JDBC/ODBC driver.

Table 1-4 Attunity Driver Database Environment Properties

Parameter
Value
Description
JDBC Connection Pool Datasource
ClassName
com.attunity.jdbc.NvXADataSource
ClassNamefor

OtherInterfaces

ServerName
Server name of the machine hosting the database.
PortNumber
server-port

Note - NOTE: Default server port is 2551.


DatabaseName
<database-name>
User
Leave user field blank. Value configured when the database entry is created in the Attunity Server.
Password
Leave password field blank. Value configured when the database entry is created in the Attunity Server.
DriverProperties
setDefTdpName#database-logical-name##setWorkspace#Navigator##
Delimiter
The default is #.
DataSourceName
MinPoolSize
The default is 0.
MaxPoolSize
The default is 10.
MaxIdleTime
The default is 0.