Error: 500
Location: /myowndir/app1/testdb1.jsp
Internal Servlet Error:
javax.servlet.ServletException: No suitable driver
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:459)
at
app_00031._0002fapp_00031_0002ftestdb_00031_0002ejsptestdb1_jsp_3._jspServic
e(_0002fapp_00031_0002ftestdb_00031_0002ejsptestdb1_jsp_3.java:97)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:177)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:210)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:484)
Root cause:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537)
at java.sql.DriverManager.getConnection(DriverManager.java:199)
at
app_00031._0002fapp_00031_0002ftestdb_00031_0002ejsptestdb1_jsp_3._jspServic
e(_0002fapp_00031_0002ftestdb_00031_0002ejsptestdb1_jsp_3.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:177)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:210)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:484)
i am using win2000 professional and access 2000
what's the problem?
any settings need to make in the tomcat?
thank you!!
<snip>
Try asking again in comp.lang.java.databases - the folks there are more
likely to be able to answer your question.
--
Jon Skeet - <sk...@pobox.com>
http://www.pobox.com/~skeet/
If replying to the group, please do not mail me too
>i have tried to change the ODBC settings in both System DSN and User DSN,
>but still can't access the database...
>the following error comes out:
>
>
>Error: 500
>Location: /myowndir/app1/testdb1.jsp
>Internal Servlet Error:
>
>javax.servlet.ServletException: No suitable driver
Darren, have you installed the JDBC:ODBC bridge?
--
Regards,
Ken Kalish
there is no Java cartel
Error: 500
Location: /myowndir/app1/testdb1.jsp
Internal Servlet Error:
javax.servlet.ServletException
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:459)
at
app_00031._0002fapp_00031_0002ftestdb_00031_0002ejsptestdb1_jsp_8._jspServic
e(_0002fapp_00031_0002ftestdb_00031_0002ejsptestdb1_jsp_8.java:97)
Root cause:
java.sql.SQLException
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:285)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:376)
at
app_00031._0002fapp_00031_0002ftestdb_00031_0002ejsptestdb1_jsp_8._jspServic
e(_0002fapp_00031_0002ftestdb_00031_0002ejsptestdb1_jsp_8.java:78)