Hello Helical Insight Team,
we are currently using Helical Insight 7.0.0 as a podman container running on an AlmaLinux 10 system with the Docker image hiee/helicalinsight:nitrogen-j25t11.
When trying to add a DB2 connection (after downloading and loading the db2 driver), we receive following error: Error: EfwdServiceException: Unable to obtain connection. jdk/net/ExtendedSocketOptions. When looking closer at the error we get:
at com.helicalinsight.datasource.managed.PlainJdbcConnectionProvider.fallBack(PlainJdbcConnectionProvider.java:127) ~[hi-core-7.0.0.jar:?]
at com.helicalinsight.datasource.managed.PlainJdbcConnectionProvider.getConnection(PlainJdbcConnectionProvider.java:85) [hi-core-7.0.0.jar:?]
at com.helicalinsight.datasource.managed.PlainJdbcConnectionProvider.newConnection(PlainJdbcConnectionProvider.java:42) [hi-core-7.0.0.jar:?]
at com.helicalinsight.datasource.managed.TestConnectionProvider.getConnection(TestConnectionProvider.java:74) [hi-core-7.0.0.jar:?]
at com.helicalinsight.datasource.managed.TestConnectionProvider.testConnection(TestConnectionProvider.java:49) [hi-core-7.0.0.jar:?]
at com.helicalinsight.efw.components.GlobalConnectionsTester.executeComponent(GlobalConnectionsTester.java:45) [hi-core-7.0.0.jar:?]
at com.helicalinsight.efw.serviceframework.ServiceUtils.getComponentResult(ServiceUtils.java:202) [hi-core-7.0.0.jar:?]
at com.helicalinsight.efw.serviceframework.ServiceUtils.executeService(ServiceUtils.java:95) [hi-core-7.0.0.jar:?]
at com.helicalinsight.efw.serviceframework.ServiceUtils.executeService(ServiceUtils.java:50) [hi-core-7.0.0.jar:?]
at com.helicalinsight.adhoc.services.DataSourceConnectionTester.doService(DataSourceConnectionTester.java:23) [hi-adhoc-7.0.0.jar:?]
at com.helicalinsight.efw.serviceframework.ServiceManager.getResultFromComponent(ServiceManager.java:497) [hi-core-7.0.0.jar:?]
at com.helicalinsight.efw.serviceframework.ServiceManager.getResult(ServiceManager.java:253) [hi-core-7.0.0.jar:?]
at com.helicalinsight.efw.controller.EfwServicesController.lambda$service$0(EfwServicesController.java:142) [hi-core-7.0.0.jar:?]
at com.helicalinsight.parallelprocessor.ThreadPoolTaskExecutorImpl.lambda$submit$2(ThreadPoolTaskExecutorImpl.java:126) [hi-core-7.0.0.jar:?]
at com.helicalinsight.parallelprocessor.ThreadPoolTaskExecutorImpl$2.call(ThreadPoolTaskExecutorImpl.java:173) [hi-core-7.0.0.jar:?]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:?]
at java.lang.Thread.run(Unknown Source) [?:?]
Caused by: java.lang.ClassNotFoundException: jdk.net.ExtendedSocketOptions
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1315) ~[catalina.jar:11.0.25]
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1146) ~[catalina.jar:11.0.25]
at com.helicalinsight.efw.framework.ParentLastClassLoader$ChildURLClassLoader.findClass(ParentLastClassLoader.java:84) ~[hi-core-7.0.0.jar:?]
at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:?]
at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:?]
We check Java inside the container with java --list-modules | grep ‘^jdk . net’ and nothing returns as expected by the error.
So it seems like the java runtime inside the container doesnt include jdk . net which is needed for the db2 connection.
This happens when we select as DataSource: Tomcat, Adhoc JDBC, Hikari.
Could you look into this?
Thanks to the whole team in advance.