Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

database access in jsp

1 view
Skip to first unread message

Darren

unread,
Jun 8, 2001, 11:55:30 AM6/8/01
to
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
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!!


Jon Skeet

unread,
Jun 8, 2001, 12:13:08 PM6/8/01
to
Darren <darr...@hotmail.com> wrote:
> 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:

<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

Ken Kalish

unread,
Jun 8, 2001, 2:34:54 PM6/8/01
to
On Fri, 8 Jun 2001 23:55:30 +0800, "Darren" <darr...@hotmail.com> wrote:

>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

Darren

unread,
Jun 8, 2001, 2:58:10 PM6/8/01
to
sorry...
the previous error should be:

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)

0 new messages