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

**kishan.java** · 10-19-2009, 12:29 PM

Hi All,

Can any boady please help me. I am new to java.

I am facing a problem when i am trying to connect oracle DB with jsp.

I set my class path as :C:\Program Files\Java\jdk1.6.0_14\lib;C:\Program Files\Tomcat 6.0\lib\servlet-api.jar;C:\Program Files\Java\jdk1.6.0_14\lib\ojdbc14.jar;.

the error is as below:
org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:522)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)

root cause

javax.servlet.ServletException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:781)
org.apache.jsp.Access_jsp._jspService(Access_jsp.j ava:188)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)

await yout reply.

regards,
kishan

**kishan.java** · 10-19-2009, 12:37 PM

Hi In My JSP page i have used the following code:

<%@ page language="java" import="java.sql.*" %>
<%@ page language="java" import="java.io.*" %>
<%@ page language="java" import="java.sql.Connection" %>
<%@ page language="java" import="java.sql.DriverManager" %>
<%@ page language="java" import="java.sql.Statement" %>

<%
response.setContentType("text/html");

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=null;
ResultSet rst=null;
Statement stmt=null;

try{
String url="jdbc:oracle:thin:@localhost:1521:kishan-d630";
con=DriverManager.getConnection(url,"scott","tiger ");
stmt=con.createStatement();
}
catch(Exception e){
System.out.println(e.getMessage());
}
if(request.getParameter("action") != null){
String name=request.getParameter("name");
String salary=request.getParameter("salary");
stmt.executeUpdate("insert into emp_sal(name,salary) values('"+name+"','"+salary+"')");
rst=stmt.executeQuery("select * from emp_sal");
%>
<html>
<body>
<center>
<h2>Books List</h2>
<table border="1" cellspacing="0" cellpadding ="0">
<tr>
<td><b>S.No</b></td>
<td><b>Employee Name</b></td>
<td><b>Salary</.b></td>
</tr>
<%
int no=1;
while(rst.next()){
%>
<tr>
<td><%=no%></td>
<td><%=rst.getString("name")%></td>
<td> <%=rst.getString("salary")%> </td>
</tr>
<%
no++;
}
rst.close();
stmt.close();
con.close();
%>
</table>
</center>
</body>
</html>
<%}else{%>
<html>
<head>
<title>Employee Entry FormDocument</title>
<script language="javascript">
function validate(objForm){
if(objForm.name.value.length==0){
alert("Please enter Employee Name!");
objForm.name.focus();
return false;
}
if(objForm.salary.value.length==0){
alert("Please enter Salary of employee!");
objForm.salary.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<center>
<form action="Access.jsp" method="post" name="entry" onSubmit="return validate(this)">
<input type="hidden" value="list" name="action">
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td>
<table>
<tr>
<td colspan="2" align="center">
<h2>Book Entry Form</h2></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>Employee Name:</td>
<td><input name="name" type="text" size="50"></td>
</tr>
<tr>
<td>salary:</td><td><input name="salary" type="text" size="50"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
<%}%>

**RamyaSivakanth** · 10-19-2009, 12:58 PM

try to explore ojdbc14.jar whether it has oracle.jdbc.driver.OracleDriver

**r035198x** · 10-19-2009, 05:34 PM

First throw away that code and create a separate class for connecting to databases.
Use JSPs for presentation only.
Then add the oracle driver to your web application's WEB-INF/lib folder.

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

LinkBack

Thread Tools

Search Thread

Display