OracleDriver cannot be resolved to a type
843840Aug 11 2008 — edited Aug 12 2008Hi all..
Iam new to this forum...Actually i have a problem.please help me..
Now iam working with tomcat6.0.16 and oracle10g.
<%@page import="java.sql.*" %>
<%
//Register the drivers
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//Establish connection with the database
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","manager");
//create a sql statement
Statement st=con.createStatement();
//execute the statement
ResultSet rs=st.executeQuery("select * from emptab");
//all rows of emptab are in rs.Now retrive column data
//from rs and display
while(rs.next())
{
out.println(rs.getInt(1));
out.println(rs.getString(2));
out.println(rs.getFloat(3));
out.println("................");
}
//close the connection
con.close();
%>
this is my program...then iam getting following error.please any one can help me?
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 4 in the jsp file: /oradata.jsp
oracle.jdbc.driver.OracleDriver cannot be resolved to a type
1: <%@page import="java.sql.*" %>
2: <%
3: //Register the drivers
4: DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
5: //Establish connection with the database
6: Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","manager");
7: //create a sql statement
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:423)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:316)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:294)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:281)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.
Apache Tomcat/6.0.16