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
 

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

Thanks @Iryna Mologa 

Hi Alexey,

I'm glad you found the introduction to container data persistence helpful.

I am not sure about ISC recommendations; however, a bind mount is located anywhere on the host filesystem and is directly tied to the host's directory structure. In contrast, a volume is located in a Docker-managed directory and is independent of the host's directory structure.

Hi @Fakhriansyah Wijaya,

Thanks for highlighting the issue. This is a known issue and has already been raised at the Streamlit site:
https://discuss.streamlit.io/t/issues-with-chroma-and-sqlite/47950

I attempted to apply the suggested solution but could not succeed. I will try to check it in more detail some other time.

Thanks