OpenLink ODBC to JDBC Bridge Connector

Figure 1: Multi-tier ODBC-JDBC Bridge Architecture

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Driver;
import java.util.Enumeration;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;
import java.io.Console;

public class UniversalJDBCTest {

    public static void main(String[] args) {
        Scanner scanner = new Scanner(System.in);
        Console console = System.console();

        System.out.println("=== Universal JDBC Connection Test ===\n");

        // Collect registered JDBC drivers
        List<Driver> driverList = new ArrayList<>();
        Enumeration<Driver> drivers = DriverManager.getDrivers();
        System.out.println("Available JDBC Drivers:\n");

        int index = 1;
        while (drivers.hasMoreElements()) {
            Driver driver = drivers.nextElement();
            driverList.add(driver);
            System.out.printf("%d) %s (v%d.%d)\n",
                    index++, driver.getClass().getName(),
                    driver.getMajorVersion(), driver.getMinorVersion());
        }

        if (driverList.isEmpty()) {
            System.out.println("⚠️ No JDBC drivers are registered with DriverManager.");
            System.out.println("Make sure your driver JARs are on the classpath.\n");
            scanner.close();
            return;
        }

        System.out.print("\nEnter driver number to test: ");
        int driverChoice = scanner.nextInt();
        scanner.nextLine();

        if (driverChoice < 1 || driverChoice > driverList.size()) {
            System.out.println("Invalid driver selection.");
            scanner.close();
            return;
        }

        Driver selectedDriver = driverList.get(driverChoice - 1);
        System.out.println("\nTesting " + selectedDriver.getClass().getName() + "...\n");

        System.out.print("Enter JDBC URL: ");
        String url = scanner.nextLine();

        System.out.print("Enter username: ");
        String user = scanner.nextLine();

        System.out.print("Enter password: ");
        String password = scanner.nextLine();

        try {
            System.out.println("\n⏳ Attempting connection...");
            Connection conn = DriverManager.getConnection(url, user, password);
            System.out.println("✓ Connection successful!\n");

            DatabaseMetaData metadata = conn.getMetaData();
            System.out.println("Database Information:");
            System.out.println("  Database Name: " + metadata.getDatabaseProductName());
            System.out.println("  Version: " + metadata.getDatabaseProductVersion());
            System.out.println("  URL: " + metadata.getURL());
            System.out.println("  Username: " + metadata.getUserName());

            conn.close();
            System.out.println("\n✓ Test completed successfully.");

        } catch (SQLException e) {
            System.err.println("\n❌ SQL Error: " + e.getMessage());
            e.printStackTrace();
        } finally {
            scanner.close();
        }
    }
}

Figure 2: ODBC Data Source Administrator

Figure 3: Select OpenLink Generic ODBC Driver

Figure 4: Enter DSN Name and Hostname:Port

Figure 5: Configure JDBC Domain, Driver, URL, and Credentials

Figure 6: Additional Options (Default Settings)

Figure 7: DSN Configuration Summary and Test Data Source Button

Figure 8: Successful DSN Connection Confirmation

Figure 9: C++ Demo Application

Figure 10: Environment → Open Connection Menu

Figure 11: Select ODBC DSN for Connection

Figure 12: Enter Username and Password for Target Database

Figure 13: SQL → Execute SQL Menu

Figure 14: Query Results Display