Oracle driver error

Symptoms: Opportunity Detect is installed using the manual database setup option, and the system tables are in Oracle. The following error occurs in the trace log.

org.apache.axis2.AxisFault: A connection could not be obtained for driver class "oracle.jdbc.OracleDriver" and URL "jdbc:oracle:thin:@//[DB Host]:[Port]/[Schema]". You may have specified an invalid URL.

Resolution:

Take the following steps.

  1. Add the ojdbc7.jar file on the runtime server in the following location.

    /home/streamsadmin/OpDetection/StreamsRemoteControlService/wlp/usr/servers/StreamsRCS/dropins/StreamsRCS/WEB-INF/lib/

  2. Restart the Streams instance and the StreamsRCS service.