Exasol Dialect for Hibernate 6+?

Hibernate ORM
1

hi,
I am looking for a solution to use Exasol database from SpringBoot 3.1 by Hibernate 6.2+. There was a project at GITHUB for hibernate 5, but that dialect no longer compilable. Syntax changed a lot. Some forum entry says for other databases as custom dialect not needed anymore.
Can you please help me where else to look for infos?
thanks,
Zol

2

Dialects for non-officially supported databases are maintained by the community through voluntary contributions in a separate module, see the Hibernate 6.0 migration guide for more details.

I’m not sure if there was a working version of an Exasol database dialect with Hibernate 5, but your best bet would be trying to port / implement a compatible version for 6 and we would be really happy to include it in the the community module.

3

thanks for the update.

I can confirm this GIT project was working nicely with util SpringBoot 2.7.x (hibernate 5). That project is provided by EXASOL guys.

If no better idea, then I will need to migrate to hibernate6 if want to proceed with SpringBoot3.1.

thx

4

The repository is archived and not maintained anymore. You should contact Exasol and talk with them about this if you care about Hibernate support. Also point them to this document: https://github.com/hibernate/hibernate-orm/blob/main/dialects.adoc

5

Hi there again,

as no longer supported (available) exasol-jdbc6 even our workaround is trashed.

The current (7.1.20 mvn central exasol-jdbc) driver is complaining as:

 WARN  c.z.h.p.ProxyConnection - HikariPool-1 - Connection com.exasol.jdbc.EXAConnection@_____ marked as broken because of SQLSTATE(0A000), ErrorCode(0)
com.exasol.jdbc.NotImplemented: Feature not supported - Auto-generated keys.

However executed native SQL (via JDBC in DataGrip Tool), just working fine:

insert into MYAPP_SECURITY_LOG
(    EMAIL, ID_RESULT, IP_ADDRESS, LOGON_DATE)
values ('testme', 1, '0:0:0:0', systimestamp);

Tried forcing my Sql to do the same via annotation:

@SQLInsert(sql=“insert into myapp_security_log (email,id_result,ip_address,logon_date) values (?,?,?,?)”)

Is there any way to ask hibernate to ignore jdbc-drivers (exasol-jdbc) complaint about “not supported” and just let the basic sql to run?

thanks

6

You can disable the use of auto-generated keys: https://docs.jboss.org/hibernate/orm/6.4/userguide/html_single/Hibernate_User_Guide.html#settings-hibernate.jdbc.use_get_generated_keys