I want to use hibernate with MS Access. Which dialect should I use and can you give me a sample hibernate configuration file with MS Access?
+2
A:
For MS Access, you'll need the dialect from HXTT. You'll need to use the hibernate support package provided by HXTT. There is also a sample project that you can check for a fully working example.
Below, a sample minimal configuration:
# Hxtt Access dialect sample
hibernate.dialect=com.hxtt.support.hibernate.HxttAccessDialect
hibernate.connection.driver_class=com.hxtt.sql.access.AccessDriver
hibernate.connection.url=jdbc:access:///c:/yourAccessDirectory
PS: If MS Access is not a written in stone requirement, maybe you should consider using something else like... well, anything.
Pascal Thivent
2009-11-17 15:05:30
+1 for the PS. If I could you would get another +1 for actually answering the question too.
Vincent Ramdhanie
2009-11-17 18:21:48
-1 for the PS without any explanation of why -- there are plenty of applications that you might be using Hibernate for without it being inappropriate to use a file-server data store like Jet/ACE.
David-W-Fenton
2009-11-17 23:51:20
@David Isn't non official support from Hibernate enough for you? To me, it is, I don't want to rely on a third party dialect provider.
Pascal Thivent
2009-11-18 18:35:36
+1
A:
@Firstthumb. Sorry, this is not really an answer but just expressing a comment. I was in the same boat - considering using MS Access to develop a local tipping competition for the Football World Cup 2010. I could access MS Access directly using the Oledb but as a training exercise to reskill a bunch of Java developers moving to .NET, I wanted to show the usage of nHibernate as the DAO layer.
After investigating the non-availability of a robust and supported dialect from JBoss/Hibernate team and other considerations, I decided to forego the exercise on using MSAccess. I downloaded the free SQL Express 2008 instead.
For those who still want to use MSAccess in .NET, please see this link)
Syd
2010-06-02 22:47:49