RedHat JBoss Fuse on Karaf cannot connect to Oracle DB via TNS/TCPS secured listener
Issue
-
We are facing issue with connection to Oracle DB using camel-jdbc which is deployed on JBoss Fuse on Karaf 6.3.0 . Our configuration to datasources looking ike this:
-
We added “java opts” parameters to jboss’s setenv file to access truststore. We tried truststore in two common formats: JKS, PKCS12. But neither one worked.
export EXTRA_JAVA_OPTS="-Djavax.net.ssl.trustStore=/etc/truststore.jks -Djavax.net.ssl.trustStorePassword=passw0999 -Djavax.net.ssl.trustStoreType=JKS -Djavax.net.debug=ssl”
-
Application modul is able to start successfully, however when trying to connect database, e.g. using command like: ‘jdbc:datasources’ we get issue “SSL handshake”
08:19:14,543 | ERROR | Thread-67 | JdbcServiceImpl | 357 - org.apache.karaf.jdbc.core - 2.4.0.redhat-630187 | Can't get information about datasource 674 java.sql.SQLRecoverableException: IO Error: Received fatal alert: handshake_failure at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:752)
- As it is in debug logs, the truststore is loaded but it looks like JDBC doesn’t use it as expected.
- Can you help us how to configure JDBC with Oracle TCPS (SSL listener)
Environment
- Red Hat Fuse
- 6.3.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.