Java is a general-purpose computer-programming language that is concurrent, class-based, object-oriented, and specifically designed to have as few implementation dependencies as possible.
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?
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.
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?
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?
Recently I started moving some of our JDBC Gateway configurations over to using the Microsoft JDBC Gateway driver instead of using the jTDS open source driver. I have noticed since then that those Objects that are using Microsoft JDBC Driver are throwing a lot more errors than the jTDS driver ever did, which I can understand however I am puzzled that I keep running into an issue with the Java Gateway Service within the Interoperability engine.
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
Start External Language Server %Java Server:
Please wait...result will show below:
2023-07-26 19:46:24 Starting Java Gateway Server '%Java Server' 2023-07-26 19:46:24 *ERROR* Return from RunStartCmd: ERROR #5049: Java version '18.0.1.1' is not supported. 2023-07-26 19:46:25 An error occurred while trying to start the Gateway Server External Language Server failed to Start: ERROR #5049: Java version '18.0.1.1' is not supported.
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 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?
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:
I am trying to work with Java Selenium through Cache my java programme works fine but I would like to pass parameters to the jar file form my Ensemble production.
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:
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...
I'm having a lot of trouble figuring out how to properly map List collection types. I can't change the schema at all, and I don't have the ability to change the way they are stored from the serialized form to the Array projection. I'm also pretty locked into using JPA for Java interoperability, as I'd like to be able to change out the backing database arbitrarily.
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:
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.
I'm trying to produce Kafka Message to Topic using Java Objects. I have build Business operation and Jar file and trying to execute. I'm getting following exception
Terminating Job 8316 / 'IrisKafkaProducer' with Status = ERROR #5046: Error executing java command 'init() returned: "ERROR #5034: Invalid status code structure ("java.sql.SQLException: [InterSystems IRIS JDBC] Communication link failure: Access Denied")"'. Java may not be installed correctly on your system., %QuitTask=