Question Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver in Technology Q&A

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Former Member — Tue, 08 May 2012 22:38:43 GMT

Hi,

We are working on NW 7.3 and trying to connect a Web Dynpro application to Oracle 10g Database. The JDK version is 1.6. We are getting the following error during Runtime:

Exception:java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver ------------------------- Loader Info ------------------------- ClassLoader name: [demo.sap.com/testwd] Loader hash code: 48c3794 Living status: alive Direct parent loaders: [system:Frame] [interface:webservices] [interface:cross] [interface:security] [interface:transactionext] [library:webservices_lib] [library:opensql] [library:jms] [library:ejb20] [service:p4] [service:ejb] [service:servlet_jsp] [library:tc~bl~logging~api] [library:tc~aii~base~offline~facade] [library:tc~cmi] [library:tc~ddic~runtime~facade] [sap.com/tc~wd~api] [library:tc~bl~exception~lib] Resources: E:\usr\sap\CEX\J10\j2ee\cluster\apps\demo.sap.com\testwd\servlet_jsp\webdynpro\resources\demo.sap.com\testwd\root\WEB-INF\lib\demo.sap.com~testwd.jar

Let me explain what I have done till now:

1) Downloaded the Oracle 10g JDBC driver using the following link: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html

Please note that there is no specific driver available for JDK 1.6. Hence I have used ojdbc14.jar. Searched everywhere on net but did not find a specific Oracle 10g JDBC driver for JDK 1.6.

2) Created a Web Dynpro project and added ojdbc14.jar as an External Library under Java Build Path of the project.

3) Also added the jar in the lib folder of the Web Dynpro folder.

4) Wrote a single line of code in the wdDoInit() method of the Component Controller:

Class.forName("oracle.jdbc.driver.OracleDriver");

5) Build and deploy the application.

For information, I tried performing the exact same steps in NW 7.0 with same Oracle version and JDK version as 1.4. I am successfully able to connect to the DB and fetch the data.

Request anyone to please share any information that can be useful for resolving this issue. Also, I am not looking to use EJBs as a middle layer between WD and Database.

Thanks & Regards,

Ankur Garg

Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

junwu — Tue, 08 May 2012 22:51:18 GMT

you just put the jar build path, it is not enough. it is only available at design time.

you have to know how to use external lib.

search in sdn you find a lot.

Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Former Member — Tue, 08 May 2012 22:57:17 GMT

Hi Jun,

Thanks for your reply. I have already searched a lot on sdn but not for creating an external lib.

The following thread has been resolved by you by recommending to put the jar file in the lib folder along with putting it in build path: http://scn.sap.com/thread/3145699

I will try to do it using the external lib, but I cannot believe that without external lib, this is not possible. The same thing is working in NWDS 7.0 without external lib.

Anyways, thanks for your reply.

Thanks & Regards,

Ankur Garg

Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

junwu — Wed, 09 May 2012 00:30:57 GMT

how you did that in nw7?

Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Former Member — Wed, 09 May 2012 01:59:30 GMT

I added ojdbc14.jar in the Java Build Path as external jar. I also added the jar in the lib folder of the Web Dynpro project. After that I just wrote the JDBC code in Component Controller and built and deployed the application. No error was received and I was able to get data from the database.

Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

junwu — Wed, 09 May 2012 02:17:13 GMT

yes, that's nw7 project,

there is no project in nw7.3, all are DC. the build path is determined by DC dependency, manually adding jar to the build path will not work

Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Former Member — Wed, 09 May 2012 15:45:14 GMT

Hi Jun,

I tried using the external library this time but still getting the same error:

Exception:java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver ------------------------- Loader Info ------------------------- ClassLoader name: [demo.sap.com/testwd] Loader hash code: 7c583538 Living status: alive Direct parent loaders: [system:Frame] [interface:webservices] [interface:cross] [interface:security] [interface:transactionext] [library:webservices_lib] [library:opensql] [library:jms] [library:ejb20] [service:p4] [service:ejb] [service:servlet_jsp] [library:tc~bl~logging~api] [library:tc~aii~base~offline~facade] [library:tc~cmi] [library:tc~ddic~runtime~facade] [demo.sap.com/oradbear] [sap.com/tc~wd~api] [library:tc~bl~exception~lib] Resources: E:\usr\sap\CEX\J10\j2ee\cluster\apps\demo.sap.com\testwd\servlet_jsp\webdynpro\resources\demo.sap.com\testwd\root\WEB-INF\lib\demo.sap.com~oracledb~oracleJDBC_assembly.jar E:\usr\sap\CEX\J10\j2ee\cluster\apps\demo.sap.com\testwd\servlet_jsp\webdynpro\resources\demo.sap.com\testwd\root\WEB-INF\lib\demo.sap.com~testwd.jar

I removed the jar from the web dynpro build path and lib folder. And then I followed the steps given in the following tutorial: http://scn.sap.com/docs/DOC-7637

Any idea what might be going wrong now?

Thanks & Regards,

Ankur Garg

Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Former Member — Wed, 09 May 2012 16:08:36 GMT

I have finally been able to run my application without any errors. Apart from the tutorial (http://scn.sap.com/docs/DOC-7637), the following thread proved to be a life saver: http://scn.sap.com/thread/1724661

Thanks Jun for your help.

Re: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

junwu — Wed, 09 May 2012 16:57:15 GMT

good to know you have overcome the issue:)