IRIS as a backend database for Java application

Question

Oliver Wilms · Jul 12, 2022

#Application Server #Java #JDBC #InterSystems IRIS

Hello,

I work on deploying IRIS using Kubernetes operator and Red Hat OpenShift. I encouraged another team working on Java application to consider using IRIS as database. My team deployed IRIS cluster using two mirrored data pods for the other team. The other team asked me for the connection information.

To learn how to use Java with IRIS, I attempted to deploy two apps from Open Exchange:

https://openexchange.intersystems.com/package/CRUD-GLOBALS-IRISNATIVEAPI...

Here I got errors like this:

package com.intersystems.jdbc does not exist

https://openexchange.intersystems.com/package/springboot-iris-crud

I can view the front end, but I do not know how it interacts with database and where the connection is defined.

I wonder how can I learn to configure Java to connect to IRIS?

Product version: IRIS 2022.1

Discussion (1)1

Guilherme Koerber · Jul 12, 2022

Hi Oliver,

There is a possibility that you create a table in IRIS that connects to an external table. I've done tests with the ODBC format, it works well I believe JDBC too.

In this case, I recommend using a JDBC connection to communicate the IRIS database with Java.

SQL Gateway via JDBC: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=BSQ...

How to use the table wizard: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=BSQ...

0 0