有谁知道Hibernate和Java是否可以有效地与Access一起工作？ [英] Does anyone know if Hibernate and java will work effectively with Access?

问题描述

我想知道是否有人使用Spring + Hibernate +访问组合，如果可以的话，他们可以发布连接属性。

感谢您

解决方案

Hibernate理论上可以与任何数据库有一个JDBC驱动程序。 Access的确有一个第三方驱动程序，因此从理论上讲，是的，它会工作。 YMMV。

话虽如此，如果您需要的是轻量级数据库，并且您正在使用Java / Hibernate土地。我会使用 Derby 。

更新：使用Access的关键点可能是SQL Dialect。在Hibernate配置中，您需要声明一个类来告诉Hibernate它正在使用哪种SQL方言。有一个列表支持的方言，如果其中任何一个与Access 100％兼容，您可以使用它（恐怕我不知道那是哪一个）。

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

解决方案

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).

这篇关于有谁知道Hibernate和Java是否可以有效地与Access一起工作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！