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.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 ?

 

[mod-the-pc]

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