Unable to connect to Oracle data source using WSO2 data service

rkalathil's picture
Hi, When I try yo connect to Oracle data source using WSO2 data service I get the following error message: Driver class oracle.jdbc.driver.OracleDriver can not be loaded I have tried copying the classes12.jar to the ./lib folder but it still throws this error, any help with this issue is much appreciated. Thanks, Raj
sumedha's picture

Hi, Put jdbc driver jar

Hi, Put jdbc driver jar inside lib/extensions folder. /sumedha
rkalathil's picture

Hi Sumedha, Thank you for

Hi Sumedha, Thank you for you help, it worked! Raj
rkg46's picture

Drive class oracle.jdbc.driver.OracleDriver can not be loaded

Sumedha - I'm having the same problem. I do not see a "/lib/extensions" folder under WSO2 install directory? This is my current setup: apache-tomcat-6.0.18 wso2-wsas2.3 jdk1.5.0_10 Oracle 10g I have the ojdbc14.jar as part of my Oracle client install and tried putting it under the JAVA_ENDORSED_DIRS directory (C:\Webservices\WSO2_WSAS\lib\endorsed) but that did not help either. Please help as I still get the "Drive class oracle.jdbc.driver.OracleDriver can not be loaded" error.
rkg46's picture

WSO2 Data Services with Oracle - driver load still an issue

Could someone please make any suggestions? After reading the numerous posts and articles, I'm still stuck not able to load the Oracle driver. Here is my setup: C:\Webservices\apache-tomcat-6.0.18 (WSO2 is deployed in Tomcat) C:\Webservices\WSO2_WSAS (WSAS_HOME directory) C:\Webservices\WSO2_WSAS\lib has the ojdbc14.jar (the lib directory is in the classpath) Here are the values I'm passing when creating the database connection: oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@10.xx.xx.xx:1521:stgis (real IP masked) scott tiger When I hit "Test Connection" I still get the following: "Drive class oracle.jdbc.driver.OracleDriver can not be loaded"
library project main code
Learn Cloud
Learn
Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar
Different groups within an organization need to monitor different Key Performance Indicators (KPIs) - An operations team will be interested in the response times of business services and loads of each service,..
Thursday, February 9th 2012, 09.00 AM (PST)

Thursday, February 9th 2012, 10.00 AM (GMT)