#Java

Hello, we are currently using the Cache Database released in January 2018.

There are no specific classes or SQL mappings in the namespaces where data is stored.

Only a few routines(.mac) and stored data are in the global area.

In this case, when accessing the Cache DB through Java, is it essential to write SQL mappings or wrapper classes? The reason I ask is that our team doesn't have advanced developers who specialize in Cache.

Alternatively, is it possible to directly call pre-existing routines from Java?

Hello, dear colleagues.

I need to connect to a remote JavaGateway from an Ensemble service.

I am trying to use the EnsLib.JavaGateway.Service with a remote host where the JVM is running.

I can successfully ping the remote Java Gateway from EnsLib.JavaGateway.Service, and Ensemble reports that the service status is OK.

There are no network issues, and all necessary ports are accessible.

s connection = ##class(%Net.Remote.Java.JavaGateway).%New()

Does IRIS for Health support Java 21?

Hi,

I have a spring-boot Java application which has Quartz Scheduler (spring-boot-quartz-starter) dependency, and uses IRIS DB.
There is a problem with making Quartz Scheduler work with IRIS since there is a blob field expected in two tables, but IRIS is using longvarbinary type.
Can you provide me with clues on how to resolve this?

I am using org.quartz.impl.jdbcjobstore.StdJDBCDelegate driverDelegateClass.

This is the error:
MisfireHandler: Error handling misfires: Couldn't retrieve trigger: invalid stream header: 41434544

The current jdbc driver version is 3.1.0, but it is not published in the public mvn repository, only the old version, see:

https://mvnrepository.com/artifact/com.intersystems/intersystems-jdbc

It is very bad to the Java Community. And why not publish IRIS Hibernate dialect in mvn repository too?

These actions are important to Java Developers.

For example, I have two timestamp values ('2024-04-01 10:00:00', '2024-04-01 11:30:30'). I would like to find the difference between these two timestamps, and I need the result in hours:minutes:seconds (hh:mm:ss) format.

Expected Output: 01:30:30

Note: I need an SQL query command. I should not use ClassMethod, Function, or Stored Procedure.

Could anyone please provide me with an SQL query for my question?

Has anyone noticed that when IRIS is forced down that the EnsLib.JavaGateway.Services do not properly shut down and release the ports? While we can write a shell script to kill the processes at the OS level, I was wondering if anyone experienced this issue.

We are working on our Mirroring setup/failover and had the team testing forcing the Primary down to make the Backup to become the Primary Server. When this happened and we failed back, IRIS could not restart the JavaGateway.Services because the ports were still in use.

Hi,

I am trying to use a Jreport catalog which had been saved by a different user. But when I save the catalog I am getting an error "Access is denied".

So does that mean same catalog can't use by different users ?

Can anyone please provide a solution for the Jreport same catalog can use for different users. ?

Thanks

Jude

Can you please any one assist me for How to connect with the InterSystems IRIS in Java(Quarkus) version 3.0.

Is there a best practice to set the memory options (classic xms and xmx) on the JavaGw service in the production?

What can be recommended?

Like specifying 1024M for xmx is for a single process? that process can't grow beyond that value right? what happen if the process reach the memory limit?

Thanks

Pietro

So, I needed to start Java Gateway, and found, that it does not want to work with the latest Java versions, I tried 20, 18, 17

Error, only says, that it will not work, and say nothing, about which version it wants to see

Any news about JDBC driver and Hibernate dialect on a public java repository, like mvnrepository? Today I need to download the jdbc driver and hibernate jar, add as an external resource on my maven config file to works.

I am trying to write a message to a Kafta cluster programmatically (i.e. not in Ensemble or using a Production) using %External.Messaging. I am consistently getting a 'topic not found error' even though I have created the topic on the cluster. I dug into the client I created an when accessing the property KaftaClient.jclient.gateway I get the following output: