Configuring JDBC/ODBC Drivers

Sequelink DataDirect Informix ODBC Driver Configuration Properties

OTD Wizard: Database Connection Information

The settings in Table 1–11 describe how to use the DataDirect Sequelink JDBC/ODBC bridge with the JDBC/ODBC eWay. This information demonstrates how Sequelink can be used to interface with the ODBC driver. To connect to an Informix database, it is recommended to use the Informix eWay Adapter.

Table 1–11 Sequelink DataDirect Informix ODBC Driver Database Connection Information

Parameter 

Value 

Driver Jar Files 

sljc.jar

Driver Java Class Name 

com.ddtek.jdbc.sequelkink.SequeLinkDriver 

URL Connection String 

jdbc:sequelink://server-name:server-port


Note –

NOTE: Default server port is 19996.


User Name 

Login name of the account used to access the database. 

Password 

Password associated with the login account name used to connect to the database. 

Environment Properties

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

Table 1–12 Sequelink DataDirect Informix ODBC Driver Environment Properties

Parameter 

Value 

Description 

JDBC Connection Pool Datasource 

ClassName 

com.ddtek.jdbcx.sequelkink.SequeLinkDataSource 

ClassNamefor 

OtherInterfaces 

 

ServerName 

Server name of the machine hosting Sequelink. 

PortNumber 

server-port


Note –

NOTE: Default server port is 19996.


DatabaseName 

 

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 

 

Delimiter 

The default is #.

DataSourceName 

 

MinPoolSize 

The default is 0.

MaxPoolSize 

The default is 10.

MaxIdleTime 

The default is 0.


Note –

It is not mandatory to enter driver properties in the Outbound JDBC eWay Environment properties for Sequelink DataDirect Informix ODBC.