Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to use MS-Access with Hibernate

 
Shrinivas Mujumdar
Ranch Hand
Posts: 328
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,
How to use MS-Access with Hibernate? What value we should specify for hibernate.dialect in Hibernate.properties?


Thanx in Advance
Shrinivas
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Its not one of the officially supported (or community supported) databases for Hibernate. No surprise there, its not really an RDBMS. So the unhelpful answer is: don't bother trying to use Hibernate with Access. If you need a database for development purposes, try something like HypersonicSQL or MySQL.
 
Michael Duffy
Ranch Hand
Posts: 163
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Paul Sturrock:
Its not one of the officially supported (or community supported) databases for Hibernate. No surprise there, its not really an RDBMS. So the unhelpful answer is: don't bother trying to use Hibernate with Access. If you need a database for development purposes, try something like HypersonicSQL or MySQL.


Not officially supported, but I believe you can try it with their GenericDialect. Use the JDBC-ODBC bridge for the driver, of course.
 
Shrinivas Mujumdar
Ranch Hand
Posts: 328
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So i should write net.sf.hibernate.GenericDialect for Dialect property?

Shrinivas
 
Jignesh Khambhayta
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
please try below link:

https://www.hibernate.org/80.html
http://www.hxtt.com/hibernate.html

it might be useful for you

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic