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.

Unable to connect JDBC over Secure SSL.

Remove the global trust store.

KB article 29440.