What is wrong with this page?

I have a jsp page that I have copied below. Below that is the error that I recieve when I try to run this page. I don't know if it was necessary to copy all of it but I did it anyways. I am trying to access a database and when I do I get this error. please please please. help me to figure this out. I have been working on this too long!

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

<% try { %>

<% Class.forName("oracle.jdbc.driver.OracleDriver"); %>

<html>

<body>

<center>JSP Page that accesses a database and prints the results</center>

<% Connection con = DriverManager.getConnection("jdbc:borg.something.net:1521", "username", "passwd"); %>

<% Statement statement = con.createStatement();

ResultSet resultSet = statement.executeQuery("SELECT * FROM oracle"); %>

<P> The results are:

</P>

<UL>

<% while (resultSet.next()) { %>

<LI><% String myData = resultSet.getString(1); %></LI>

<% System.out.println(myData); %>

<% } %>

</UL>

<% } catch (SQLException e) {

out.println(e.getMessage());

while((e.getNextException()) != null) {

out.println(e.getMessage());

}

} %>

</body>

</html>

errror--

A Servlet Exception Has Occurred

Exception Report:

javax.servlet.ServletException: oracle.jdbc.driver.OracleDriver

at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:442)

at org.apache.jsp.dbaccess3_jsp._jspService(dbaccess3_jsp.java:136)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:200)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:453)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:254)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:194)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:255)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:225)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2252)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:875)

at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:952)

at java.lang.Thread.run(Thread.java:484)

Root Cause:

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

at org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java:1111)

at org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java:976)

at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:176)

at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:116)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:120)

at org.apache.jsp.dbaccess3_jsp._jspService(dbaccess3_jsp.java:71)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:200)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:453)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:254)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:194)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:255)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:225)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2252)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:875)

at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:952)

at java.lang.Thread.run(Thread.java:484)

[7824 byte] By [dUb] at [2007-9-26 1:51:55]
# 1

Your problem is right here:

Root Cause:

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

You're application server doesn't know where to find your Oracle JDBC driver. If you haven't done so already, you needed to get the Oracle JDBC drivers from http://technet.oracle.com (classes12.zip). Then add classes12.zip to your classpath, which differs depending on your appserver (Tomcat -> wrapper.properties, Jserv -> jserv.properties, Jrun -> jsm.properties, etc.)

-Derek

beattris at 2007-6-29 3:00:58 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
You need to get the Oracle JDBC driver and put it into your classpath. It may have come with Oracle itself.
Enygma42 at 2007-6-29 3:00:58 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...