Written by

Technical Consultant at Traverse Health
Question Muhammad Waseem · Nov 16, 2024

JDBC SQL Gateway connection error on a MacBook

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

Comments

Evgeny Shvarov · Nov 17, 2024

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

0
Muhammad Waseem  Nov 18, 2024 to Evgeny Shvarov

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

0
Jeffrey Drumm · Nov 17, 2024

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?

0
Muhammad Waseem  Nov 18, 2024 to Jeffrey Drumm

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;

publicclassOracleJDBCTest{
    publicstaticvoidmain(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
 

0
Alexander Koblov · Nov 18, 2024

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

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

0