ODBC-JDBC Bridge Installation Guide

Launch the Installer

Locate and double-click the OJDBC installation executable to launch the installer.

Welcome Screen

The Welcome screen presents an overview of what will be installed. Click "Next >" to continue.

License Agreement

Read the License Agreement carefully. You must accept the terms to continue. Select "I Agree" and click "Next >".

Licensing Information

Enter your licensing details if applicable. For evaluation versions, this may be optional. Click "Next >".

Installation Options

Choose whether to install to the default location or specify a custom path. Standard installation is recommended.

Begin Installation

Review your settings and click "Install" to begin copying files to your system.

Installation Complete

Once installation is complete, click "Finish" to close the installer.

Locate the JVM

Find the jvm.dll file location in your Java installation. Typically located at:

C:\Program Files\Java\jdk1.8.0_version\jre\bin\server\jvm.dll
C:\Program Files (x86)\Java\jre1.8.0_version\bin\server\jvm.dll

Configure PATH Environment Variable

Add the directory containing jvm.dll to your system PATH:

1. Open System Properties (Win+Pause or Control Panel → System)
2. Click "Advanced system settings" then "Environment Variables"
3. Under "System variables", edit "Path" and add a new entry for C:\path\to\jvm\bin\server
4. Click OK and restart your applications

Locate JDBC Driver

Find the JDBC driver .jar file for your target database. For example:

C:\Program Files\JDBC Drivers\postgresql-42.2.14.jar
C:\Program Files\JDBC Drivers\mysql-connector-java-8.0.22.jar

Configure CLASSPATH Environment Variable

Add the JDBC driver .jar file to your system CLASSPATH:

1. Open Environment Variables and click "New" under "System variables".
2. Set Variable name: CLASSPATH
3. Set Value: C:\path\to\jdbc\driver.jar
4. For multiple drivers, separate paths with semicolons (;).

Optional - Configure JVM Options

Set the OPL_JVM_OPTS environment variable for custom JVM parameters:

Variable name: OPL_JVM_OPTS
Value: -Xms64m -Xmx512m

Verify Java Installation

Test your Java setup by running these commands in Command Prompt:

java -version
javac -version

Both commands should display version information without errors.

JDBC Testing Utility - UniversalJDBCTest

Before configuring the ODBC DSN, verify your JDBC driver is properly installed and your connection parameters are correct using this testing utility. Copy the code into a file named UniversalJDBCTest.java, edit the connection parameters, then compile and run.

import java.sql.*;

public class UniversalJDBCTest {
    public static void main(String[] args) {
        // EDIT THESE VALUES
        String driverClass = "org.postgresql.Driver";
        String jdbcURL = "jdbc:postgresql://localhost:5432/mydb";
        String username = "myuser";
        String password = "mypassword";
        
        try {
            System.out.println("Loading JDBC Driver: " + driverClass);
            Class.forName(driverClass);
            System.out.println("Connecting to: " + jdbcURL);
            Connection conn = DriverManager.getConnection(jdbcURL, username, password);
            System.out.println("Connection successful!");
            
            DatabaseMetaData meta = conn.getMetaData();
            System.out.println("Database: " + meta.getDatabaseProductName() + " " + meta.getDatabaseProductVersion());
            
            conn.close();
        } catch (Exception e) {
            System.err.println("ERROR: Connection failed!");
            e.printStackTrace();
        }
    }
}

Compile and Run:

javac UniversalJDBCTest.java
java UniversalJDBCTest

A successful test confirms your Java and JDBC driver setup is correct.

Open ODBC Administrator

Access the ODBC Data Source Administrator. On Windows, open Control Panel → Administrative Tools → ODBC Data Sources (32-bit or 64-bit as appropriate).

Navigate to System DSN Tab & Add

Click on the "System DSN" tab and click the "Add..." button to create a new data source.

Select Driver

Select the "OpenLink JDBC Lite Driver" from the list of available drivers.

Configure DSN Name

Enter a descriptive name for your data source (e.g., "MyVirtuoso", "OracleDB_DSN").

Connection Tab Settings

Configure the connection parameters. Enter the JDBC driver class, URL string, username, and password for your database connection.

Database-Specific Settings

Configure database-specific parameters if needed. These settings allow fine-tuning of the connection.

Options Tab Configuration

The Options tab provides additional configuration parameters such as row buffer size and other performance-related settings.

Compatibility Settings

Configure compatibility options to ensure optimal behavior with your specific applications and database.

Test Connection

Click the "Test" button to verify that your configuration is correct and that the connection to your database is successful.