Connection Error While Accessing a Secure Oracle Database
Issue Description:
The client has enabled SSL on their Oracle database; however, they are encountering issues when attempting to connect through AutomationEdge Process Studio.
Error Message:
User Defined Java Class.0 - java.sql.SQLRecoverableException: IO Error: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
Root Cause:
Investigation revealed a version mismatch in the Oracle JDBC driver:
Process Studio was using Oracle JDBC driver v6.
Eclipse was using Oracle JDBC driver v8.
Replacing the Process Studio JAR with the Eclipse JAR reproduced the issue, confirming the driver version as the cause.
Switching to Oracle JDBC driver v8 resolved the issue temporarily but is not recommended for long-term use.
Recommended Solution:
We recommend upgrading AutomationEdge from version 7.6.6 to 8.x.
Version 8.x includes Oracle JDBC driver 11.23.4, which is fully compatible with SSL configurations.
This upgrade ensures a stable and secure database connection without requiring manual changes to the driver.