Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Database Connectivity >> Java Database Connectivity (JDBC)

ClassNotFound problem in Resin

Hi all,

I'm pretty new to this so please bear with me.

I'm developing a web application (in Dreamweaver) using Ajax. I have a JSP script which is waiting for the request from the page to perform some operations on a database. It sends the page an error if any errors are encountered

I am always receiving a "classnotfound" error on the line:

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

Now, I have placed ojdbc14.jar, which contains jdbc/OracleDriver, into resin/lib AND into resin/webapps/ROOT/WEB-INF/lib. I actually created the lib directory inside WEB-INF myself because I read on some other forums that I should do that, but I really have no idea what I'm doing there -_-.

However, I still get the error.

I made a test page to verify that the classloader for resin is loading the jar from resin/lib, and the jar file IS listed as one of the files being loaded.

So basically, I have no idea what's going on.

Please help! Thanks.

p.s. I'm using Dreamweaver 8

[1046 byte] By [omnipotent1a] at [2007-11-27 8:35:58]
«« Error connection to Oracle from JSP
»» Tomcat startup configuration question
# 1
add ojdbc14.jar to [your_web_app]/WEB-INF/lib/ directory then restart resin. http://www.caucho.com/resin-3.1/doc/config-env.xtp http://www.caucho.com/resin-3.1/doc/database-tags.xtp
java_2006a at 2007-7-12 20:32:44 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

This didn't help. I have ojdbc14.jar in the [web_app]/WEB-INF/lib/ directory, as you say, with my resin-web.xml file reading:

<web-app xmlns="http://caucho.com/ns/resin">

<class-loader>

<compiling-loader path="WEB-INF/classes" />

<library-loader path="WEB-INF/lib" />

</class-loader>

</web-app>

It is also in my resin/lib/ directory, my resin/lib/local directory (which is supposed to be common to all web apps according to the resin FAQ), and it is still not working.

The code I have in the jsp page reads:

<%@ page import="java.sql.*" import="java.lang.*" import="java.io.*"%>

<%

String name = request.getParameter("name");

String desc = request.getParameter("description");

response.getWriter().write("");

try{

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

try{

...

Please help!

omnipotent1a at 2007-7-12 20:32:44 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
Database Connectivity
Java Database Connectivity (JDBC)

Database Connectivity Hot Topic

Database Connectivity

All Classified