Hibernate 6 Dialect for InterSystems

This is the Hibernate 6 Dialect for InterSystems IRIS.

Source code for any contributions

To contribute to this dialect, go to the dialect folder

Pre reqs

1. Use Java 11 or later
2. Hibernate 6 or later

How to install this dialect

To install this dialect:

• For Maven:

<dependency> <groupId>io.github.yurimarx</groupId> <artifactId>hibernateirisdialect</artifactId> <version>1.1.0</version> </dependency>

• Gradle:

dependencies { implementation 'io.github.yurimarx:hibernateirisdialect:1.1.0' }

How to use this dialect

To use this dialect:

• For Spring properties file (application.properties):

spring.datasource.username=_SYSTEM spring.datasource.url=jdbc:IRIS://localhost:1972/USER spring.datasource.password=SYS spring.datasource.driver-class-name=com.intersystems.jdbc.IRISDriver spring.jpa.database-platform=io.github.yurimarx.hibernateirisdialect.InterSystemsIRISDialect

• for Spring yml file (application.yml): ``` spring: datasource: url: jdbc:IRIS://localhost:1972/USER password: SYS username: _SYSTEM jpa: properties: hibernate: dialect: io.github.yurimarx.hibernateirisdialect.InterSystemsIRISDialect

```

• For Hibernate file (hibernate.properties):

hibernate.connection.url=jdbc:IRIS://localhost:1972/USER hibernate.connection.driver_class=com.intersystems.jdbc.IRISDriver hibernate.connection.username=_SYSTEM hibernate.connection.password=SYS hibernate.dialect=io.github.yurimarx.hibernateirisdialect.InterSystemsIRISDialect

• For Hibernate xml file (hibernate.cfg.xml):

<hibernate-configuration> <session-factory> <property name="connection.url">jdbc:IRIS://localhost:1972/USER</property> <property name="hibernate.connection.driver_class">com.intersystems.jdbc.IRISDriver</property> <property name="connection.username">_SYSTEM</property> <property name="connection.password">SYS</property> <property name="dialect">io.github.yurimarx.hibernateirisdialect.InterSystemsIRISDialect</property> <property name="hibernate.hbm2ddl.auto">create-drop</property> </session-factory> </hibernate-configuration>

Unit test for this dialect

To execute unit the dialect unit tests or get a java hibernate sample, go to the folder tests-java-sample

To learn more:

• Tutorial: https://community.intersystems.com/post/using-new-intersystems-iris-hibernate-6-dialect-springboot-project
• Video: https://youtu.be/-8ureaF7wZQ

Cudas

• I would like thanks Dmitry Maslennikov for your advanced support and for help me to improve this new Dialect