How To Solve Java.Lang.Classnotfoundexception Sun.Jdbc.Odbc.Jdbcodbcdriver Inwards Coffee 8

java.lang.classnotfoundexception sun.jdbc.odbc.jdbcodbcdriver exception comes inwards Java 8 because it has removed the JDBC ODBC couplet driver degree "sun.jdbc.odbc.jdbcodbcdriver" from JDK together with JRE. This degree is required to connect whatever database using Object database connectivity driver e.g. Microsoft Access, but unfortunately you lot cannot purpose it from JDK 8 onward. In lodge to solve this error, simply use Jackcess library or a commercial driver similar HXTT. Normally, inwards pre Java 8 world, java.lang.classnotfoundexception sun.jdbc.odbc.jdbcodbcdriver mistake comes when you try to connect to Microsoft Access database from Java using JDBC together with JDBC ODBC couplet driver is non available inwards classpath. If you lot remember, In lodge to opened upward SQL connector to database, outset measurement is to charge together with register the driver. In lodge to charge driver, nosotros purpose Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  together with this method throws java.lang.classnotfoundexception sun.jdbc.odbc.jdbcodbcdriver, if ClassLoader is non able to honor the requested degree (sun.jdbc.odbc.JdbcOdbcDriver) in CLASSPATH. In lodge to connect to MS Access, nosotros cry for type 1 JDBC driver, too known equally JDBC ODBC couplet driver together with the degree inwards question, JdbcOdbcDriver is driver implementation to connect to Open database connectivity driver installed inwards machine.


Just retrieve that sun.jdbc.odbc.JdbcOdbcDriver is a criterion degree from JDK API together with it doesn't come upward alongside whatever external JAR similar other vendor database's JDBC drivers e.g. JDBC driver to connect Oracle database comes on ojdbc6.jar together with MySQL driver comes in mysql-connector-java-5.1.23-bin.jar. JdbcOdbcDriver class is introduce inwards rt.jar, which is ever included inwards Classpath, equally this JAR file is business office of the JRE.

Many newbie inwards Java programming prefer to connect to MS Access database from Java together with thus bigger database similar Oracle, SQL Server or MySQL. Even I accept done the same when I outset started learning JDBC, primary argue for that was MS ACCESS comes equally business office of Microsoft Office together with  was available inwards my machine. I didn't accept to become alongside hurting involved on installing Oracle, SQL Server or MySQL database, sometime fifty-fifty you lot don't fifty-fifty accept administrator access inwards your auto to practise that. BTW, at that spot are several disadvantage of using JDBC ODBC Bridge driver, outset it require ODBC driver to travel installed inwards your machine, instant it makes your code platform dependent. Using pure Java type iv JDBC driver is best means to connect commercial database from Java programs. Almost all major database vendor provides type iv JDBC driver right away days, thus its simply affair of finding correct version together with dropping that JAR inwards classpath.

java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver inwards Java 8

JDBC-ODBC couplet driver has been marked equally "don't use" for the final decade or so. It was introduce inwards Java seven unloosen but removed from Java 8 unloosen onward. It mightiness too non travel available on non-Windows JVMs, equally it makes no feel to accept an ODBC-JDBC couplet driver on platforms on which ODBC does non be e.g. Linux or Mac OS.  Here is the stacktrace of the mistake you lot acquire :

   java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver     at java.net.URLClassLoader$1.run(URLClassLoader.java:372)     at java.net.URLClassLoader$1.run(URLClassLoader.java:361)     at java.security.AccessController.doPrivileged(Native Method)     at java.net.URLClassLoader.findClass(URLClassLoader.java:360)     at java.lang.ClassLoader.loadClass(ClassLoader.java:424)     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:30     at java.lang.ClassLoader.loadClass(ClassLoader.java:357)     at java.lang.Class.forName0(Native Method)     at java.lang.Class.forName(Class.java:259)

That's all about java.lang.classnotfoundexception sun.jdbc.odbc.jdbcodbcdriver exception inwards Java 8. JDBC-ODBC couplet driver is buggy, irksome together with unsupported inwards many platforms, it may non fifty-fifty travel available fifty-fifty inwards 64-bit Windows versions. You volition acquire this exception if you lot endeavour to connect to Microsoft Access database shape Java 8 JRE or JVM, because JDBC-ODBC couplet driver is right away removed. Consider using type iv JDBC, pure Java driver alongside existent database or if you lot all the same desire to connect to MS access, use Jackcess library or a commercial driver similar HXTT.

Related JDBC Tutorials together with troubleshooting conduct :

• General Guide to solve java.lang.ClassNotFoundException inwards Java [guide]
• How to solve java.lang.ClassNotFoundException: com.mysql.jdbc.Driver inwards Java MySQL? [solution]
• How to gear upward java.lang.ClassNotFoundException: org.postgresql.Driver mistake inwards Java? [solution]
• How to gear upward java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver Error inwards Java? [solution]
• java.lang.ClassNotFoundException: org.apache.commons.logging.LogFactory? [solution]
• How to solve java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver inwards Java? [solution]
• How to connect Oracle database from Java Program? (example)
• How to solve java.lang.unsatisfiedlinkerror no ocijdbc11 inwards java.library.path? (solution)

Further Learning
JSP, Servlets together with JDBC for Beginners: Build a Database App
Complete JDBC Programming Part 1 together with 2
Java Platform: Working alongside Databases Using JDBC

Share this post