JSP ERROR Please Help.......

[kavree]

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.handlePa geException(PageContextImpl.java:386)
at _0002fDataAccess_0002ejspDataAccess_jsp_2._jspServ ice(_0002fDataAccess_0002ejspDataAccess_jsp_2.java :103)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.jasper.runtime.JspServlet$JspServletWra pper.service(JspServlet.java:174)
at org.apache.jasper.runtime.JspServlet.serviceJspFil e(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspSe rvlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.tomcat.core.ServletWrapper.handleReques t(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(Cont extManager.java:559)
at org.apache.tomcat.service.http.HttpConnectionHandl er.processConnection(HttpConnectionHandler.java:16 0)
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(JspL oader.java:184)
at org.apache.jasper.runtime.JspLoader.loadClass(JspL oader.java:136)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 62)
at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:322)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:130)
at _0002fDataAccess_0002ejspDataAccess_jsp_2._jspServ ice(_0002fDataAccess_0002ejspDataAccess_jsp_2.java :60)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.jasper.runtime.JspServlet$JspServletWra pper.service(JspServlet.java:174)
at org.apache.jasper.runtime.JspServlet.serviceJspFil e(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspSe rvlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.tomcat.core.ServletWrapper.handleReques t(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(Cont extManager.java:559)
at org.apache.tomcat.service.http.HttpConnectionHandl er.processConnection(HttpConnectionHandler.java:16 0)
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 ?

[mod-the-pc]

Try using Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")