Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OracleDriver cannot be resolved to a type

843840Aug 11 2008 — edited Aug 12 2008
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2008
Added on Aug 11 2008
2 comments
15,535 views