The JDBC/ODBC bridge is no longer available in Java 8 and therefor it is not possible to connect through an ODBC data source when using SQL Workbench/J. Specifying a library directory When defining the location of the driver's.jar file, you can use the placeholder%LibDir% instead of the using the directory's name directly. The JDBC-ODBC Bridge is a JDBC driver that implements JDBC operations by translating them into ODBC operations. To ODBC it appears as a normal application program. The Bridge implements JDBC for any database for which an ODBC driver is available.
JDBC is the Java Database Connectivity standard and it provides a mechanism for Java programs to connect to databases.To access databases using JDBC, you must use a JDBC driver. Database vendors offer JDBC drivers as free downloads.
SQL Developer supports the following JDBC drivers.
- IBM DB2: You need the binary driver jar files db2jcc.jar and db2jcc_license_cu.jar. Search for DB2 Universal JDBC Drivers or download it here.
- Microsoft Access: No additional driver is required. Access uses the JDBC/ODBC bridge
- Microsoft SQL Server and Sybase: jTDS driver version 1.2. Download here.
The binary driver is located within the jtds-1.2-dist.zip. This jar file is called jtds-1.2.jar. - MySQL: MySQL JDBC Driver, version 5.04. Download here.
The binary driver is located within the mysql-connector-java-5.0.4.tar.gz (or .zip). The jar file is called mysql-connector-java-5.0.4-bin.jar. - Teradata: Use Teradata JDBC Driver 12.0 or above. Both the Teradata JDBC Driver 12.0 and 13.0 use the jar files terajdbc4.jar and tdgssconfig.jar. Download here.
Once you have extracted the relevant jar file to your disk, you need to configure SQL Developer to tell it where this driver resides.
How to Install a JDBC Driver in Oracle SQL Developer
Using Check For Updates to configure JDBC Drivers
Oracle SQL Developer also supports the use of Check for Updates to install the drivers required for MySQL, Microsoft SQL Server and Sybase. To use Check for Updates, start SQL Developer and select Help -> Check for Updates.
Starting with Java 8, the JDBC-ODBC Bridge will no longer be included with the JDK.
Is there any other solution connecting JDBC-ODBC Bridge?
Jdbc Odbc Bridge Url
6 Answers
We can still use JDBC-ODBC Bridge in java 8 too, just follow this simple recipe:
- Download a JDK 7 or JRE 7.
- Goto JRElib folder and find the rt.jar
- Unzip it (if you have WinRAR or 7zip installed) or you can rename it to rt.zip and unzip it.
Copy sunjdbc and sunsecurityaction folders out, keep the folder structure. i.e., you should have the folder structure like below:
Open a CMD window. Go to the parent folder of Sun folder. Run the command:
jar -cvf jdbc.jar sun- The above command will create a file named jdbc.jar
- Copy JDBC.jar to your JDK8 or JRE8
libfolder. If that doesn't work try thelibextfolder. - Copy jdbcodbc.dll from JREbin of your JRE 7 installation to JREbin of your JRE 8 installation.
- Restart your JVM.
Type 1 Driver Jdbc-odbc Bridge Download
Well, in my opinion this blog entry by an Oracle employee says it all:
I would recommend that you use a JDBC driver provided by the vendor of your database or a commercial JDBC Driver instead of the JDBC-ODBC Bridge.
What kind of application are you using the JDBC-ODBC Bridge for?
- If it is production code, you should IMHO replace the bridge with a real driver and the legacy database with a real one ASAP
- If it is test code that interacts with an Access DB, Excel spreadsheet or whatever you can access through ODBC, try replacing it with a pure Java database like H2
- If you use it for ad-hoc access to legacy Access DBs for, say, development and/or analytical purposes, and really can't or don't want to update anything, you can stick to a JDK 7 for quite a long while until its End-of-Life date and probably far beyond that
Is there any other solution connecting JDBC-ODBC Bridge?
Sun's and Oracle's official positions have long been that --
the [JVM-bundled] JDBC-ODBC Bridge should be considered a transitional solution [...] Oracle does not support the JDBC-ODBC Bridge.
However, my employer, OpenLink Software, has produced enterprise-grade commercial Type 1 Bridges between JDBC and ODBC since JVM 1.0, and these are fully compatible with the current JVM 1.8. You can learn more here --
- Single-Tier JDBC-ODBC Bridge Driver -- a JDBC driver for ODBC data sources
- Single-Tier ODBC-JDBC Bridge Driver -- an ODBC driver for JDBC data sources
I found a reasonable solution that allows for use of existing code with a change only to open database connection logic.
UCanAccess is an open-source, JDBC driver.
That has two dependencies, one of which has two more dependencies.
jackcess-2.0.0.jar or later
hsqldb.jar(2.2.5)
Those are all open-source. Do an internet search, download, unzip if necessary and put all four jars plus the one for UCanAccess in a directory in your project (e.g. JDBC-to-MSAccess). If using Ecplise, add to your build path by choosing from the menu 'Project / Properties / Java Compiler / Libraries / Add External JARs' and select all five jar files.
The connection logic is really simple:
Robert Petermeier gave a good point H2 drives supports ODBC through PostgreSQL driver, and you can install the driver accordingly the link from Stackoverflow Setting up PostgreSQL ODBC on Windows
I know this question has been answered a long time back, but I wanted to highlight DataDirect's sequelink. In this blog https://www.progress.com/blogs/jdbc-odbc-bridge-replacement-yields-performance-boost the author talks about how their bridge can yield a 310% performance boost. The bridge's trial version can be downloaded here: https://www.progress.com/jdbc/sequelink
Jdbc Odbc Bridge Driver Download
protected by Community♦Apr 13 '17 at 12:39
Squirrel Jdbc Odbc Bridge Driver Download
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?