Spring Data JPA, Hibernate and EXASOL database

Question

I'm currently facing the problem to migrate an existing application using Spring Data JPA and Hibernate from an Oracle Database to EXASOL. This should in general not be a big problem but it seems like that it is not possible use Hibernate in combination with EXASOL.

My current application.properties file:

#db config
db.driver=com.exasol.jdbc.EXADriver
db.url=jdbc:exa:192.168.1.11..17:8563
db.username=foobar
db.password=foobar

#hibernate config
hibernate.dialect=???
hibernate.hbm2ddl.auto=validate
hibernate.ejb.naming_strategy=org.hibernate.cfg.ImprovedNamingStrategy
hibernate.show_sql=true
hibernate.format_sql=true

The question is which hibernate.dialect to use?

To shorten it, the combination of Hibernate and EXASOL is not working. Plain JDBC seems to be the best way to work with EXASOL and Java. — Aldjinn, May 03 '16 at 07:04

score 1 · Answer 1 · answered Feb 16 '18 at 15:52

1

It's possible currently to use Hibernate in combination with EXASOL. Here is the repository for the Exasol Hibernate Dialect from their github page.

answered Feb 16 '18 at 15:52

gdrt

3,160
4
37
56

Disclaimer: Please note that this is an open source project which is not officially supported by EXASOL. We will try to help you as much as possible, but can't guarantee anything since this is not an official EXASOL product. – torina Apr 09 '18 at 14:20

score 0 · Answer 2 · edited Jan 12 '16 at 09:55

0

EXASOL does have a hibernate dialect - please contact your support representative or post a request to the EXASOL community for more details

edited Jan 12 '16 at 09:55

Community

1
1

answered Jan 11 '16 at 15:56

Graham Mossman

1
1

Spring Data JPA, Hibernate and EXASOL database

2 Answers2