1. Hey Guest Did you know you can win an Honor 10 phone worth ₹33,000 and an additional ₹70,000 in paytm vouchers, just by replying to some threads and taking part in the discussions happening in the Honor Hub?

    What are you waiting for? Start commenting and start winning! Remember to read the instructions posted here.

    Dismiss Notice

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