Troubleshooting -- OpenLink JDBC-ODBC Bridge Driver (Connector) for macOS

ODBC Data Source Name (DSN) Check

Ensure you have a working ODBC DSN that successfully connects to your target Database via any of the following:

  1. ODBC Administrator Tool – using the ODBC DSN “Test” option

  2. C++ Demo or iODBCTest Tools

Know Your JDBC Driver’s Identity

The OpenLink JDBC-ODBC Bridger driver has the Java Class Name:

openlink.jdbc4.Driver

JDBC URL Construction and Troubleshooting

Ensure you’ve created a valid JDBC URL i.e., one that includes valid connection attribute name and value pairs.

A typical Virtuoso JDBC-ODBC Bridge URL is of the form:

jdbc:openlink://ODBC/DSN={ODBC-DSN}/UID={username}/PWD={password}/

Example

Given an existing ODBC DSN “Virtuoso on Demo”, your JDBC-ODBC Bridge Driver URL

would be as follows:

jdbc:openlink://ODBC/DSN=Virtuoso on Demo/UID=dba/PWD=/

At this juncture, if you still cannot establish a basic JDBC-ODBC Bridge Driver connection, please open a support case using our online support system.

Support System Guidelines

Before opening you support case, please prepare the following information, using the commands provided.

Host Operating System

Command: sw_vers

Sample Output:


ProductName: Mac OS X

ProductVersion: 10.14.6

BuildVersion: 18G6032

Java Version:

Command: java -version

Sample Output:


OpenLink Generic Driver for JDBC(TM) 4.2 Version 04.54 (Release 8.0)

Driver JAR:

Command: java -jar /Library/Java/Extensions/opljdbc4_2.jar

Sample Output:


OpenLink Generic Driver for JDBC(TM) 4.2 Version 04.54 (Release 8.0)

Driver Library:

Command: strings /Library/Java/Extensions/libopljodbc4_2.jnilib | grep Release

Sample Output:


Release

Version 08.00.191217 as of Tue Feb 11 2020 (Release 8.0, g1176e5eb1)