Oracle JDBC Step triggers "Internal Server Error. Could not connect to the specified database. Please check the logs for more detail" - Support and Troubleshooting

Oracle JDBC Step triggers "Internal Server Error. Could not connect to the specified database. Please check the logs for more detail" Issue Test connection on jdbc_connection.do page is successful Open Flow designer > actions with JDBC step Select test JDBC Step and it will show an error like Internal Server Error. Could not connect to the specified database. Please check the logs for more detail. Release All

Cause The issue is related to the testing of the connection The Oracle driver requires the Service name ( . ) in order to test correct The Oracle driver will not query with the service name, only the SID Resolution Update the connection details only with SID in the oracle_sid field and will query successfully Check the requirements to fill the jdbc_connection.do form in the documentation page JDBC step To grab errors from the Mid Server, refer to the KB Review the agent log for MID Server errors Verify you can execute queries from the MID server Check the connection details including port number. Make sure access from firewall if there is any is allowed to the Oracle Port. The default value is 1521 Verify you have the right JDBC driver installed in the mid server For more information about the JDBC driver, follow our documentation page JDBC type data source