How to use hibernate with ms access?

Question

I created a project in netbeans. I required to connect ms access as DB using hibernate. I also include some jars like...

commons-lang-2.6.jar commons-logging-1.1.3.jar hsqldb.jarhsqldb.jar jackcess-2.0.4.jar ucanaccess-2.0.8.jar

and I also create driver ODBC for ms access DB . code for hibernate.cfg.xml.

<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="hibernate.connection.driver_class">sun.jdbc.odbc.JdbcOdbcDriver</property>  
    <property name="hibernate.connection.url">jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=E:/mydb.accdb</property>
    <property name="hibernate.connection.username">root</property>

but it show following errors.....

Exception in thread "AWT-EventQueue-0" org.hibernate.boot.registry.classloading.spi.ClassLoadingException: Unable to load class [sun.jdbc.odbc.JdbcOdbcDriver]
at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:245)   at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:245)
at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.loadDriverIfPossible(DriverManagerConnectionProviderImpl.java:200)
at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildCreator(DriverManagerConnectionProviderImpl.java:156)
at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:95)

See this post: http://stackoverflow.com/questions/22984438/java-lang-classnotfoundexception-sun-jdbc-odbc-jdbcodbcdriver-exception-occurin — Steph, Apr 29 '15 at 07:57

score 0 · Answer 1 · answered Apr 29 '15 at 07:58

0

I think that the error message is clear:

Unable to load class [sun.jdbc.odbc.JdbcOdbcDriver]

Your program cannot find the class sun.jdbc.odbc.JdbcOdbcDriver.

The JDBC-ODBC-Bridge was deprecated and is removed in Java 8.

answered Apr 29 '15 at 07:58

Uwe Plonus

9,803
4
41
48

i also try it in jdk 7 but error is same – Dipen Ahir Apr 29 '15 at 07:59
@dipenahir possibly you tried with a runtime rather than a JDK; only the JDK has the bridge driver jar. – Gimby Apr 29 '15 at 09:37

score 0 · Answer 2 · edited May 23 '17 at 12:14

0

You cannot use ODBC Bridge with Java8 Since it has been removed.

Removal of JDBC ODBC bridge in java 8

Ref: Oracle Blog Entry

Alternatively you will have to use a JDBC based driver for the same .

edited May 23 '17 at 12:14

Community

1
1

answered Apr 29 '15 at 07:59

Akash Yadav

2,411
20
32

How to use hibernate with ms access?

2 Answers2