This jdbc information is based on Oracle Database 11g Release 2 (11.2.0.4), on a RAC (Oracle Real Application Clusters), JDBC for InfoSphere Information Server 11.5 on Red Hat Linux.  so, here are a few pointers for building an IBM InfoSphere Information Server (IIS) isjdbc.config file.

Where to place JAR files

As a standard practice for Infosphere Information Server installs, create a custom jdbc folder in the install path and copy the jar file into the folder (not install activity required).   Usually, jdbc folder path looks something like this:

• /opt/IBM/InformationServer/jdbc

JAR Source URL

• In this example, we used the jar files from the client install, but if you want to skip the client install you can download the drivers here: Oracle JDBC Drivers

Oracle DEFAULT PORT

• 1521

JDBC URL FORMAT

• jdbc:oracle:thin:@//:/ServiceName

or

• jdbc:oracle:thin:@<host>:<port>:<SID>

JDBC URL EXAMPLE

• jdbc:oracle:thin:@//RAC01-scan:1521/DW

Create And Place A jdbc configuration file

The Isjdbc.config file needs to be placed in the DSEngine directory:

Isjdbc.config File Path

• /opt/IBM/InformationServer/Server/DSEngine

isjdbc.config Example

CLASSPATH=/opt/app/oracle/product/11.2.0/client_1/jdbc/lib/ojdbc6.jar;

CLASS_NAMES=oracle.jdbc.OracleDriver

isjdbc.config Properties Notes

CLASSPATH

• jar
• Classpath must have complete path and jar name

CLASS_NAMES

• oracle.jdbc.OracleDriver

Related References

• Netezza – JDBC ISJDBC.CONFIG Configuration
• SQL Server JDBC ISJDBC.CONFIG Configuration
• Netezza JDBC Error – Unterminated quoted string
• DB2 JDBC Driver Versions and Downloads
• Setting up the driver configuration file
• Oracle JDBC Drivers
• Sample JDBC driver connection URL formats
• JDBC drivers for predefined data connectors