Eclipse Link 是否与 Vertica 一起工作
我目前正在测试vertica。由于 vertica 有一个 jdbc 驱动程序,因此应该可以使其工作。
有没有一种简单的方法让 Eclipse 链接支持 vertica? 是否有支持它的替代 orm 框架(如 hibernate)?
i'm currently testing vertica. Since vertica has a jdbc driver it should be possible to get it working.
Is there a simple way to get Eclipse link to support vertica?
Are there alternative orm framework (like hibernate) that support it?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
![扫码二维码加入Web技术交流群](/public/img/jiaqun_03.jpg)
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
只要您有兼容的 JDBC 驱动程序,EclipseLink 就可以与 Vertica 配合使用。
某些功能(例如 DDL 生成)可能需要自定义 DatabasePlatform 类,您可以根据需要创建该类。大多数功能应该与通用数据库平台一起使用。
您遇到任何具体问题吗?
As long as you have a compliant JDBC driver EclipseLink should work with Vertica.
Some features such as DDL generation, may require a custom DatabasePlatform class, which you could create if required. Most features should work with the generic DatabasePlatform.
Are you encountering any specific issues?
根据 Vertica 支持,Hibernate 查询可与 org.hibernate.dialect.PostgreSQLDialect 配合使用,虽然这是事实,但仍然存在一些问题(特别是 hbm2ddl),只能使用自定义方言来修复。
其中包括:
不确定 postgres 与 vertica 有多远,但使用我自己的继承 postgres 方言的自定义方言,到目前为止一切正常。
According to the Vertica Support Hibernate queries works with the
org.hibernate.dialect.PostgreSQLDialect
while this is true there are still some problems (exspecially with hbm2ddl) that can only be fixed with a custom dialect.Among those are:
not sure how far postgres is from vertica but with my own custom dialect that inherits the postgres dialect everything works so far.
我们最近尝试让 Hibernate 与 vertica 一起工作,但没有成功。问题之一是该组合的方言不存在。
在咨询了 Vertica 顾问后,得到的答案是,没有计划提供此类支持,因为像 hibernate 这样的 ORM 和像 Vertica 这样的数据库提供了不同的数据存储方法。
We recently tried to get Hibernate working with vertica unsuccessfully. One of the problems was an inexistent dialect for that combination.
After consulting a Vertica consultant the answer was that there is no plans to provide this sort of support as ORMs like hibernate and a DB like Vertica provide different approaches for data storage.