• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate with MSAccess?

 
Siegfried Heintze
Ranch Hand
Posts: 408
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does anyone have an example of using hibernate with MSAccess? According to the book "The definitive Guide to Grails" hibernate works with MSAccess.

The initial problem is finding a dialect. I did a google search and found com.hxtt.support.hiberate.HxttAccessDialect but apparently this only works if you buy the $200 JDBC driver to go with it.

Are there any other dialects for MSAccess that work with the sun provided ODBC bridge that is part of Sun's java distro?

Thanks,
Siegfried
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hmm, I thought Hibernate had a dialect for MSAccess already in its jar.

Mark
 
Siegfried Heintze
Ranch Hand
Posts: 408
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does anyone know what it is called? Eclipse could not find it in my jar.
thanks,
Siegfried
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Mark Spritzler:
Hmm, I thought Hibernate had a dialect for MSAccess already in its jar.

Mark


I don't think it does - their supported databases page suggests you use a commercial dialect.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Paul Sturrock:


I don't think it does - their supported databases page suggests you use a commercial dialect.


Ah, I must have assumed it did because the AS has a sample DS for Access in the docs folder, and thought that Hibernate would have matched those. But I was wrong. Thanks.

So, it recommends the dialect from HXTT. And http://www.hxtt.com/hibernate.html here, it doesn't look like you have to buy their driver. But I am not sure where else you can find a JDBC driver that talks to Access, unless there is a JDBC-ODBC driver out there and you can talk directly to the ODBC entry for your access db.

Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic