JDBC connectors

The JDBC input and output connectors provide a read-write interface for relational databases. The JDBC input connector is used to retrieve information from the database, and the JDBC output connector is used to insert or update information in the database.

In the configuration of the JDBC input and output connector you specify the appropriate JDBC driver and Connection URL settings to connect to the database, and the SQL query to execute on the selected database.

Prerequisites

•	The following environment variable must be set:

STRS_JAVA_HOME="C:\Program Files\Java\jre1.5.0_14"

•	The appropriate JDBC driver must be available to connect to the database.

JDBC drivers included in the StreamServe installation

The following JDBC drivers are included in the StreamServe installation:

•	JDBC-ODBC bridge

•	DataDirect SQL Server driver

•	DataDirect Oracle driver

•	DataDirect DB2 driver

Downloading JDBC drivers

You can also download java packages with other drivers, and set the classpath to the downloaded *.jar file.

You use the argument -java-user-class-path in the Configure Platform Export dialog box (Administrator Arguments) to set the classpath.