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.
- 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/
- Restart the Streams instance and the StreamsRCS service.