You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Joe <jo...@sgweb.com.sg> on 2003/06/04 08:20:09 UTC
RE: Need Help on JDBC Connection - SOLVED!
Hi guys, it seems that once I have move my config from /etc/profile to
/etc/rc.d/rc.local, the problem is solved. Dunno what happened
actually????
Anyway, thanks a lot for your precious time and resources..
Regards,
Joe
-----Original Message-----
From: Joe [mailto:joe.lee@sgweb.com.sg]
Sent: Wednesday, June 04, 2003 12:05 PM
To: 'Tomcat Users List'
Subject: RE: Need Help on JDBC Connection
Hi Mike, thank you so much for your prompt reply. Here's how my
/etc/profile looks like(Did I set it correctly??):
JAVA_HOME=/usr/local/java
CATALINA_HOME=/usr/local/tomcat
ANT_HOME=/usr/local/ant
APACHE_HOME=/usr/local/apache
MYSQL_HOME=/usr/local/mysql
CLASSPATH=${CATALINA_HOME}/common/lib/servlet-api.jar:$MYSQL_HOME/connec
tor/mysql_connector/mysql_connector-java-3.08-stable-bin.jar:${JAVA_HOME
}/lib/tools.jar:${JAVA_HOME}/jre/lib/rt.jar:./
PATH=${PATH}:${JAVA_HOME}/bin:${ANT_HOME}/bin:
MANPATH=${JAVA_HOME}/man:${MANPATH}
export JAVA_HOME ANT_HOME APACHE_HOME MYSQL_HOME CATALINA_HOME CLASSPATH
PATH MANPATH
And here's my jsp source code,
<%@ page contentType="text/html; charset=iso-8859-1" language="java"
import="java.sql.*" errorPage="" %>
<html>
<head>
<title>Admin</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<H1>Admin Details</H1>
<%
//Step 1com.mysql.jdbc.Driver
//Class.forName("org.gjt.mm.mysql.Driver");
Class.forName("org.gjt.mm.mysql.Driver");
//Step 2
Connection myConn =
DriverManager.getConnection("jdbc:mysql://192.168.1.74/mex", "name",
"password");
//Step 3
Statement stmt=myConn.createStatement();
//Step 4
ResultSet myResultSet = stmt.executeQuery("SELECT * FROM
admin");
//Step 6
if (myResultSet != null)
{
//Step 7
while (myResultSet.next())
{
String aid = myResultSet.getString("id");
String username = myResultSet.getString("username");
String password = myResultSet.getString("password");
String name = myResultSet.getString("name");
%>
<table border="1" width="400">
<tr>
<td><%=aid%></td>
<td><%=username%></td>
<td><%=password%></td>
<td><%=name%></td>
</tr>
<% //Step 8
} /* of while */
} /* of if */
//Step 9 and 10
myConn.close();
%>
</table>
</body>
</html>
Regards,
Joe
-----Original Message-----
From: mike jackson [mailto:mjackson@cdi-hq.com]
Sent: Wednesday, June 04, 2003 11:53 AM
To: 'Tomcat Users List'
Subject: RE: Need Help on JDBC Connection
Those errors are remarkably unhelpful, at least to me.
I don't know that there's enough information there. Perhaps a snippet
of the page would help. Specifically the point when you load the driver
class (which I'm assuming is in the jsp, although that's not the best
place for it) and the point when you get the connection from the
database.
It could be that the error is somewhere else in the page, but that's a
good first point to start looking at. My guess is that it's probably
the point when you get a connection or perhaps when you're trying to get
a statement. But that's only a guess.
--mikej
-=------
mike jackson
mjackson@cdi-hq.com
> -----Original Message-----
> From: Joe [mailto:joe.lee@sgweb.com.sg]
> Sent: Tuesday, June 03, 2003 7:01 PM
> To: 'Tomcat Users List'
> Subject: Need Help on JDBC Connection
>
> Hi all, does anyone knows that's the case of this error:
>
> This happened when I tried to access MySQL Database from remote
client.
> I'm sorry that I miss out some of the important codes previously.
>
> Regards,
> Joe
>
>
> HTTP Status 500 -
>
>
------------------------------------------------------------------------
> --------
>
> type Exception report
>
> message
>
> description The server encountered an internal error () that prevented
> it from fulfilling this request.
>
> exception
>
> org.apache.jasper.JasperException: com.mysql.jdbc.Driver
> at
>
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
> va:254)
> at
>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:256)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java:191)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
>
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241
> 5)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :180)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
> lve.java:171)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:641)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :172)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:641)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
> java:174)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
>
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> at
>
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:59
> 4)
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
> onnection(Http11Protocol.java:392)
> at
>
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:56
> 5)
> at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
> .java:619)
> at java.lang.Thread.run(Thread.java:536)
>
>
> root cause
>
> javax.servlet.ServletException: com.mysql.jdbc.Driver
> at
>
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContex
> tImpl.java:536)
> at org.apache.jsp.dbquery_jsp._jspService(dbquery_jsp.java:112)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
> va:210)
> at
>
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:256)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java:191)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
>
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241
> 5)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :180)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
> lve.java:171)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:641)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :172)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:641)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
> java:174)
> at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
> nvokeNext(StandardPipeline.java:643)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 80)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
>
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> at
>
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:59
> 4)
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
> onnection(Http11Protocol.java:392)
> at
>
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:56
> 5)
> at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
> .java:619)
> at java.lang.Thread.run(Thread.java:536)
>
>
>
>
------------------------------------------------------------------------
> --------
>
> Apache Tomcat/4.1.24
>
> -----Original Message-----
> From: Jason Bainbridge [mailto:jason@jblinux.org]
> Sent: Tuesday, June 03, 2003 6:51 PM
> To: Tomcat Users List
> Subject: Re: Need Help on JDBC Connection
>
> On Tue, 3 Jun 2003 18:46, Joe wrote:
> > description The server encountered an internal error () that
prevented
> > it from fulfilling this request.
> > exception
> > org.apache.jasper.JasperException: com.mysql.jdbc.Driver
> > ...
>
> You cut out the all important part, what is the rest of the message?
>
> --
> Jason Bainbridge
> KDE Web Team - http://kde.org
> webmaster@kde.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org