Error using graalvm native image and jdbc oracle and instant client (driver oci)

[matpil]

Hi all,
I'll trying to use the quarkus native image with oracle instant client 21_05 ( oci driver ).
I'm able to compile and generate the native image but I've exeperiences some runtime issues:

2024-03-01 09:21:38,168 WARN  [io.agr.pool] (agroal-11) Datasource '<default>': Failed to create connection due to IllegalStateException
2024-03-01 09:21:39,344 ERROR [io.qua.run.Application] (main) Failed to start application (with profile [prod]): java.lang.IllegalStateException: Missing character set id 871 is not loaded at image build time
        at oracle.sql.CharacterSet.make(CharacterSet.java:122)
        at oracle.jdbc.driver.DBConversion.init(DBConversion.java:185)
        at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:138)
        at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:146)
        at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:734)
        at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1095)
        at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:97)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)
        at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:226)
        at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:536)
        at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:517)
        at [email protected]/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:75)
        at [email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
        at [email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
        at [email protected]/java.lang.Thread.run(Thread.java:833)
        at org.graalvm.nativeimage.builder/com.oracle.svm.core.thread.PlatformThreads.threadStartRoutine(PlatformThreads.java:775)
        at org.graalvm.nativeimage.builder/com.oracle.svm.core.posix.thread.PosixPlatformThreads.pthreadStartRoutine(PosixPlatformThreads.java:203)

After "googling" I've found a post that suggested me to add

quarkus.native.add-all-charsets=true

on application.properties.

With this fix the stacktrace now is:

2024-03-01 14:57:42,346 WARN  [io.agr.pool] (agroal-11) Datasource '<default>': Failed to create connection due to NoSuchFieldError
2024-03-01 14:57:43,582 ERROR [io.qua.run.Application] (main) Failed to start application (with profile [prod]): java.lang.NoSuchFieldError: oracle.jdbc.driver.T2CConnection.m_nativeState
        at org.graalvm.nativeimage.builder/com.oracle.svm.core.jni.functions.JNIFunctions$Support.getFieldID(JNIFunctions.java:1271)
        at org.graalvm.nativeimage.builder/com.oracle.svm.core.jni.functions.JNIFunctions.GetFieldID(JNIFunctions.java:425)
        at oracle.jdbc.driver.T2CConnection.t2cCreateState(T2CConnection.java)
        at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:755)
        at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1095)
        at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:97)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)
        at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:226)
        at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:536)
        at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:517)
        at [email protected]/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:75)
        at [email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
        at [email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
        at [email protected]/java.lang.Thread.run(Thread.java:833)
        at org.graalvm.nativeimage.builder/com.oracle.svm.core.thread.PlatformThreads.threadStartRoutine(PlatformThreads.java:775)
        at org.graalvm.nativeimage.builder/com.oracle.svm.core.posix.thread.PosixPlatformThreads.pthreadStartRoutine(PosixPlatformThreads.java:203)

The dependecies that I use is

    <dependency>
      <groupId>io.quarkus</groupId>
      <artifactId>quarkus-jdbc-oracle</artifactId>
    </dependency>

    <dependency>
      <groupId>org.kie.kogito</groupId>
      <artifactId>kogito-addons-quarkus-persistence-jdbc</artifactId>
    </dependency>

How can I fix this issue?

Regads

Matteo

[quarkus-bot[bot]]

/cc @zakkak (native-image)

[matpil]

If I remove the dependency ``` org.kie.kogito kogito-addons-quarkus-persistence-jdbc ```

seems that the error disappear...
...btw by removing this dependency, it does not write to the db of the kogito part