The $JAVA_HOME environment variable is set, even I have added the driver path to the classpath. In the terminal, I am able to run the following code successfully:"

import java.sql.DriverManager;

public class OracleJDBCTest {
    public static void main(String[] args) {
        try {
            // Load the Oracle JDBC driver
            Class.forName("oracle.jdbc.OracleDriver");
            System.out.println("Oracle JDBC Driver is installed and loaded successfully!
        } catch (ClassNotFoundException e) {
            System.out.println("Oracle JDBC Driver is NOT installed!");
            e.printStackTrace();
        }
    }
}



However, I’m still unable to connect from the IRIS SQL Gateway Connection.

I’m getting the following error for the first time after restarting the IRIS instance:


and after that I am getting the below error :



Thanks
 

I tried DC AI and found it quite impressive. Below is one of the questions I asked:
https://community.intersystems.com/ask-dc-ai?question_id=177731
Here are some suggestions for improvement:
Session History: Having a history of asked questions, at least at the session level, would enhance convenience and allow users to track their inquiries more easily.
Reference Links: Instead of displaying links always as "[1]", consider using more readable references like "Ref #1" or "Ref #2". This format would improve readability.