aspose file tools*
The moose likes Object Relational Mapping and the fly likes Hibernate and MS Access? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate and MS Access?" Watch "Hibernate and MS Access?" New topic
Author

Hibernate and MS Access?

Thameem Aliyar
Ranch Hand

Joined: Oct 11, 2011
Posts: 42
I'am developing an application with hibernate . And i have ms access db in hand . Is it possible to connect. How can i connect hibernate to ms access DB. Kindly help me please........
Thanking you in advance...........
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3775

You should have the proper driver and the appropriate Hibernate dialect defined. See this for more information about the support for various vendors.


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Thameem Aliyar
Ranch Hand

Joined: Oct 11, 2011
Posts: 42
Thanks for your reply. I used the same dialect. But I got some errors.

Here's my hibernate.cfg.xml................

And here's the error.......


Failed to create sessionFactory object.org.hibernate.HibernateException: Dialect class not found: com.hxtt.support.hibernate.HxttAccessDialect
Exception in thread "main" java.lang.ExceptionInInitializerError
at com.actions.MsAccessMain.main(MsAccessMain.java:20)
Caused by: org.hibernate.HibernateException: Dialect class not found: com.hxtt.support.hibernate.HxttAccessDialect
at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:159)
at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:99)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:117)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
at com.actions.MsAccessMain.main(MsAccessMain.java:17)
Caused by: java.lang.ClassNotFoundException: com.hxtt.support.hibernate.HxttAccessDialect
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)
at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:156)
... 6 more


Kindly tell me a solution required.

Thanking you in advance................
Thameem Aliyar
Ranch Hand

Joined: Oct 11, 2011
Posts: 42
I resolved the above error by including hibernate35.jar..
Now i'am getting the following error.......


Failed to create sessionFactory object.java.lang.NoSuchFieldError: INTEGER
Exception in thread "main" java.lang.ExceptionInInitializerError
at com.actions.MsAccessMain.main(MsAccessMain.java:25)
Caused by: java.lang.NoSuchFieldError: INTEGER
at com.hxtt.support.hibernate.HxttDialect.<init>(HxttDialect.java:27)
at com.hxtt.support.hibernate.HxttAccessDialect.<init>(HxttAccessDialect.java:12)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:156)
at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:99)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:117)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
at com.actions.MsAccessMain.main(MsAccessMain.java:22)


Here's my main method.....



Kindly tell me the solution required.

Thanking you in advance................
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3775

Looks like you have used incompatible types here. Can you show your mapping file and the POJO itself?
Thameem Aliyar
Ranch Hand

Joined: Oct 11, 2011
Posts: 42
Thanks for your reply.......... Sorry for the late reply........ its beacause the net was down................

Here's my POJO.........

And here's my mapping xml...

Kindly reply me solution....
Thanking you in advance..............
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3775

What is the line corresponding to the line #25 in your MsAccessMain original class (including package, imports etc..)?

And I suggest you first try to get the initialization work properly. Remove other code from the main class and try.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate and MS Access?
 
Similar Threads
how do i connect applet to datbase of ms-access.
How to access MS-Access(.mdb) file in java program with MAC OS
Remote Access
Exception when reading image( using getBLOB ) from database
DATABASE APPLET