Intersystems IRIS Dialect for HIBERNATE

Question

Question

Luis-Ángel Pére... · Jun 17, 2019

Good morning!

I am developing a Java project (Spring Boot + Maven + Hibernate) but I've a big issue when I try to define the Hibernate Dialect org.hibernate.dialect.InterSystemsIRISDialect... that dialect is neither in the Hibernate library nor in the IRISDriver class com.intersystems.jdbc

How should I define the IRISDialect in my project?

Thank you in advance!

Discussion (5)2

Log in or sign up to continue

Jon Willeke · Jun 17, 2019

Unfortunately, deployment of the Hibernate dialect for InterSystems IRIS is still a bit of a work in progress:

https://irisdocs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page...

There's an old dialect for Caché in the Hibernate distribution itself, but the IRIS dialect lives in a handful of files that you can get from the WRC.

0 0

score 0 · Answer 1 · 2019-06-17T12:38:19-04:00

I think there may be another jar, probably available from hibernate.org, which has the driver. I don't know for certain, but I think that is how things work. Note "org.hibernate.dialect" as the prefix of the URL means that hibernate has and owns the driver, including its support.

Just my two cents,

Jonathan

score 0 · Answer 2 · 2019-06-17T12:55:02-04:00

Thank you Jonathan for your answer, but I don't find any reference to InterSystemsIRISDialect in any page of Hibernate.

It's mysterious...

score 0 · Answer 3 · 2019-08-20T10:58:30-04:00

The dialect of Intersystems IRIS being approved in the hibernate git repository.
The depot managers want to stop the "support" of the Cache dialect to position the IRIS one.

https://github.com/hibernate/hibernate-orm/pull/2335

score 1 · Answer 4 · 2023-07-19T23:38:28-04:00

Yuri Marx · Jul 19, 2023

I created a new dialect see: https://community.intersystems.com/post/using-new-intersystems-iris-hibe...

1 0