#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?

An interface running on Ensemble generates PDFs by building a command line and invoking c:\InterSystems\Ensemble\fop\fop.bat

One day last week the PDF generation stopped working. The output from the .bat script says:

The setSchema () method is not implemented in CacheConnection, so how should I switch Schema?

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?

Hello all,

I am trying to start java gateway and constantly getting an error in terminal:
"%RemoteService+3^%Net.Remote.Gateway.1 *%Exception.StatusException ERROR #5023: Remote Gateway Error: TCP error on port '55555', ensure there is an Object Gateway running on this port". I've checked jvm and it is running properly, telnet also is able to connect to the port.

Has anyone encountered this issue before?

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

Is there a way problematically to see what Operations/Services are attached to a EnsLib.JavaGateway.Service and if there are issues with the EnsLib.JavaGateway.Service to stop/start those Services/Operations that might be attached to it?

Thanks

Hello!

I used %Projection.Java to generate the java proxy classes. Follows the projected class image.

Note that "import com.intersystems.binding.Database" was added but it displays the error cannot find symbol.

Has anyone had this problem, how was it resolved?

Hello Programmers,
I'm trying to use Intersystems IRIS Database with
Quarkus, but I'm getting problems making it work
does anyone knows how to set up the Intersystems IRIS Database
on Quarkus ?

I did that on my pom.xml and also I added the jar
hibernate-iris-1.0.0.jar and intersystems-jdbc-3.2.0.jar but it's not working

Hi....
I am trying to execute legacy routines from Cache 2018, into new environment with Iris 2021. I use new JDBC driver to make this connection, and change my java code to execute this legacy routines. But I get this write error: <REMOTE EXECUTE INVALID WRITE>
I changed the mnemonic routine to populate object and return this object to java. And the java class convert this object to json.
This is my simple classes used for this process, just to exemplification:

Java Class

Hello. I'm having problems migrating a java application that is running with cache 2018 to Iris
The application uses json generated by the cache to receive it as a string in java.

Consider a Natural Key with an Identity (Serial) field.

I cannot seem to acquire the generated value after persisting my entity. That is, the returned entity by Spring Data's "save" does not have the generated value.

The value is generated by the database, and I can query it after repository.save(entity).

I have done some testing and created a Github repo with it...

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.