Please review the following documentation and article, which might be helpful:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

https://community.intersystems.com/post/using-docker-your-intersystems-i...

Thanks @Alexander Koblov, copying ojdbc8.jar to /tmp worked for me. 

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