JSP ERROR Please Help.......

Discussion in 'QnA (read only)' started by kavree, Aug 5, 2004.

Thread Status:
Not open for further replies.
  1. kavree

    kavree New Member

    Joined:
    Jun 25, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    I am using Tomcat server to connect JSP to Access database.
    The error I get is:


    Error: 500
    Location: /myJSPs/DataAccess.jsp
    Internal Servlet Error:

    javax.servlet.ServletException: Unable to load class com.sun.jdbc.odbc.Driver
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:386)
    at _0002fDataAccess_0002ejspDataAccess_jsp_2._jspService(_0002fDataAccess_0002ejspDataAccess_jsp_2.java:103)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)
    at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
    at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
    at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
    at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
    at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
    at java.lang.Thread.run(Thread.java:536)

    Root cause:
    java.lang.ClassNotFoundException: Unable to load class com.sun.jdbc.odbc.Driver
    at org.apache.jasper.runtime.JspLoader.findClass(JspLoader.java:184)
    at org.apache.jasper.runtime.JspLoader.loadClass(JspLoader.java:136)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:262)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:322)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:130)
    at _0002fDataAccess_0002ejspDataAccess_jsp_2._jspService(_0002fDataAccess_0002ejspDataAccess_jsp_2.java:60)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)
    at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
    at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
    at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
    at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
    at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
    at java.lang.Thread.run(Thread.java:536)



    Please Help.

    OR do you have any other way for accessing a database from a JSP ?
     
  2. mod-the-pc

    mod-the-pc Back to School Mr. Bean !

    Joined:
    Apr 1, 2004
    Messages:
    344
    Likes Received:
    5
    Trophy Points:
    18
    Location:
    Chennai
    Try using Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
     
Thread Status:
Not open for further replies.

Share This Page