JDBC SQL Gateway connection error on a MacBook

Question

Question

Muhammad Waseem · Nov 16, 2024

Hi Community,
I am getting below "The driver cannot be loaded" error on a MacBook.

obdbc8.jar file is present in the mentioned folder.

Looking forward to resolve the above issue or workaround

Thanks

Discussion (8)4

Log in or sign up to continue

Evgeny Shvarov · Nov 17, 2024

Maybe some path issue? Not enough rights to access the folder with the driver?

0 0

Alexander Koblov Nov 18, 2024 to Alexander Koblov

Other idea -- try to put ojdbc8.jar in some publicly available folder. Like /tmp to rule out permissions issue. You wrote that you checked the permissions, however I wonder if MacOS treats folders in the /Users folder in a special way

1 0

score 0 · Answer 1 · 2024-11-18T09:04:50-05:00

Thank you for your suggestion! I have already checked the path and folder permissions, and everything seems to be in order.

score 0 · Answer 2 · 2024-11-18T09:44:12-05:00

I quickly examined https://openexchange.intersystems.com and found an app that seems useful at a first glance. May be @Sergey Mikhailenko can follow up from here.

score 0 · Answer 3 · 2024-11-17T08:14:42-05:00

Is Java installed and the appropriate version for the driver? Is the $JAVA_HOME environment variable set for the account under which IRIS is running?

score 0 · Answer 4 · 2024-11-18T09:56:03-05:00

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();
        }
    }
}Java
Java

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

score 0 · Answer 5 · 2024-11-18T10:11:29-05:00

Hi Muhammad.

Enable logging in the %JDBC External language server, reproduce the error, and check the log. Hopefully there will be some useful information in the log

score 1 · Answer 6 · 2024-11-18T14:58:41-05:00

Muhammad Waseem Nov 18, 2024 to Alexander Koblov

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

1 0