Unable to connect JDBC over Secure SSL.

Unable to connect JDBC over Secure SSL.

book

Article ID: KB0089015

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Description:
JDBC SSL connection fails after following the steps mentioned in KB 29440. The following error is reported.

"JDBC error reported: (SQLState = 08006) -
java.sql.SQLException: IO Error: The Network Adapter could not establish the
connection"
      at
com.tibco.plugin.jdbc.JDBCActivity.eval(JDBCActivity.java:1000)
      at
com.tibco.pe.plugin.Activity.eval(Activity.java:240)
      at
com.tibco.pe.core.TaskImpl.eval(TaskImpl.java:775)
      at
com.tibco.pe.core.Job.step(Job.java:729)
      at
com.tibco.pe.core.Job.checkStep(Job.java:518)
      at
com.tibco.pe.core.JobDispatcher$formula($JobCourier.runx)(JobDispatcher.java:249)
      at
com.tibco.pe.core.JobDispatcher$formula($JobCourier.run)(JobDispatcher.java:200)
caused by: java.sql.SQLException: IO Error: The Network
Adapter could not establish the connection
      at
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
      at
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
      at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
      at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
      at
java.sql.DriverManager.getConnection(DriverManager.java:582)
      at
java.sql.DriverManager.getConnection(DriverManager.java:185)
     at
com.tibco.pe.core.JDBCPool.getConnectionEntry(JDBCPool.java:1262)
      at
com.tibco.pe.core.JDBCPool.getConnectionEntry(JDBCPool.java:1149)
      at
com.tibco.pe.core.JDBCPoolManager.getConnectionEntry(JDBCPoolManager.java:588)
      at
com.tibco.plugin.jdbc.JDBCActivity.eval(JDBCActivity.java:860)
     at
com.tibco.pe.plugin.Activity.eval(Activity.java:240)
     at
com.tibco.pe.core.TaskImpl.eval(TaskImpl.java:775)
      at
com.tibco.pe.core.Job.step(Job.java:729)
      at
com.tibco.pe.core.Job.checkStep(Job.java:518)
    at
com.tibco.pe.core.JobDispatcher$formula($JobCourier.runx)(JobDispatcher.java:249)
     at
com.tibco.pe.core.JobDispatcher$formula($JobCourier.run)(JobDispatcher.java:200

Caused by: oracle.net.ns.NetException: The Network
Adapter could not establish the connection


Symptoms:
"Network Adapter could not establish the connection: error.

Cause:

As part of the work around mentioned in KB 29440, it is required to provide the trust store as an argument to the JVM. There is a conflict with global trust store. If the global trust store variable is created at the project level, it will break the SSL JDBC connection.

Resolution

Remove the global trust store.

Issue/Introduction

Unable to connect JDBC over Secure SSL.

Additional Information

KB article 29440.