Describes the requirements for installing Oracle JDBC adapters, including installing the Oracle client, and the command to call the adapter.
We use "thick" drivers in our JDBC adapters. Therefore, you need to install Oracle client on the computer where adapters will run. You can use Oracle's InstantClient, which is lightweight, and has everything that you need. After you have installed this, modify your CLASSPATH to include the 2 .jar files that came with the client: classes12.jar and odbc14.jar Modify your LD_LIBRARY_PATH to point to the directory with the libraries from the client.
Set up tnsnames.ora (this is optional). This is purely for convenience. If you set up tnsnames, you can call the database by its alias in the command line for the adapter. Otherwise you'll have to provide the full URL (see below)
Here's a sample command to call JDBCInputAdapter to connect to an Oracle database (no tnsnames used):
java com.sybase.c8.adapter.JDBCInputAdapter --queryFile=query.sql --tupleDescriptorFile=td2.xml --username=lola --password=sybase --driver=oracle.jdbc.driver.OracleDriver --databaseURL=jdbc:oracle:oci8:@oraclehost.sybase.com:1521:orcl --pollInterval=30000 --streamUrl=ccl://ab03.sybase.com:7777/Stream/PQA/DbWrite/InStream