Does anyone know if Hibernate and java will work effectively with Access?

Question

I have a small project that doesn't require much disk space, so i considered using an access database.

I was wondering if anyone used a Spring + Hibernate + access combination, if so can they post the connection properties.

thanks guys

Answer 1

Hibernate will theoretically work with any database that has a JDBC driver. Access does have a third party driver, so in theory, yes it will work. YMMV.

Having said that, if you're requirements are for a lightweight database and you're working in Java/Hibernate land. I'd use Derby instead.

Update: The sticking point for using Access might be the SQL Dialect, In the Hibernate configuration you need to declare a class to tell Hibernate what dialect of SQL it is using. There is a list of supported dialects, If any of these is 100% compatible with Access you could use that (I'm afraid I don't know which that would be, if any).

Answer 2

The Hibernate docs say that Hibernate has been tested against Access, but it requires a dialect from HXTT.