JSP-database problem

[Ramesh Sunkara]

hi guys,
THANK YOU FOR YOUR TIME.

import java.sql.*;
import javax.sql.*;
import oracle.jdbc.driver.OracleDriver;

public class dvrRequest
  {

	public static void main(String args[])throws SQLException
	{

	    	  try {
              			Class.forName ("oracle.jdbc.driver.OracleDriver");
        			} catch (ClassNotFoundException e) {
              		e.printStackTrace();
        		}


	  	 String cs="jdbc:oracle:thin:@16.138.77.50:1521:VSDINT";

	  	 Connection con=DriverManager.getConnection(cs,"dvradmin","dvr*admin");
		   	
	  	 String sql="SELECT  *  FROM DVR_REQUEST_TB";

                     	 Statement ps=con.createStatement();

	 	  ResultSet rs=ps.executeQuery(sql);

	  	  while(rs.next())
		  {
                      	    System.out.println(rs.getInt(1));
		  }
	  	 rs.close();ps.close();con.close();
	      	
                }
}

The CLASSPATH which i set is : C:\Program Files\Tomcat 5.5\common\lib\servlet-api.jar;C:\ORACLE\product\10.2.0\client_1\jdbc\lib\classes12.jar;C:\Program Files\Tomcat 5.5\common\lib\ojdbc14.jar;C:\Program Files\Java\jdk1.6.0_18\bin;

I installed ORACLE CLIENT10g for accessing a network database.


THE ABOVE CODE WORK FINE. I AM ABLE TO GET DATA ,,, BUT WHEN I USED THAT CODE IN JSP AM UNABLE TO CONNECT TO DB.

MY JSP CODE

<%@page import = "java.io.*, java.util.*, java.lang.*, javax.servlet.*, javax.servlet.http.*,java.sql.*,oracle.jdbc.driver.OracleDriver"%>

<%

   try {
              	Class.forName ("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) 
                               {
              		e.printStackTrace();
        		}


	  	 String cs="jdbc:oracle:thin:@16.138.77.50:1521:VSDINT";

	  	 Connection con=DriverManager.getConnection(cs,"dvradmin","dvr*admin");
		   	
	  	 String sql="SELECT  *  FROM DVR_REQUEST_TB";

                     	 Statement ps=con.createStatement();

	 	  ResultSet rs=ps.executeQuery(sql);
	  	  while(rs.next())
		  { %>
                     
     	
 <ul>
		<li><a class="noeffect" href="javascript:document.s1.Play();">
		<span class="number">1</span><span class="auto"></span><span class="name"> 
		<%out.println(rs.getInt(1));%></span><span class="time">4:11am</span></a></li>
		<li>
	<%  }
	  	 rs.close();ps.close();con.close();
%>

AM GETTING THIS ERROR:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: oracle/jdbc/driver/OracleDriver (wrong name: oracle/jdbc/OracleDriver)
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause

javax.servlet.ServletException: oracle/jdbc/driver/OracleDriver (wrong name: oracle/jdbc/OracleDriver)
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
	org.apache.jsp.recordings_jsp._jspService(recordings_jsp.java:145)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause

java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver (wrong name: oracle/jdbc/OracleDriver)
	java.lang.ClassLoader.defineClass1(Native Method)
	java.lang.ClassLoader.defineClassCond(Unknown Source)
	java.lang.ClassLoader.defineClass(Unknown Source)
	java.security.SecureClassLoader.defineClass(Unknown Source)
	org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1880)
	org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:889)
	org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1353)
	org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1232)
	org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:125)
	org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)
	java.lang.Class.forName0(Native Method)
	java.lang.Class.forName(Unknown Source)
	org.apache.jsp.recordings_jsp._jspService(recordings_jsp.java:82)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.

[Harpreet Singh janda]

Put oracle driver jar in lib folder of your application.

[Bear Bibeault]

You will find the caps lock key on your keyboard, most probably to the left of the A key. Please turn it off!

Read this: KeepItDown

[Srilakshmi Vara]

Error is clearly saying that Driver jar is missing. Try to put Oracle driver library in lib and try again.