Configuring JDBC/ODBC Drivers

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.