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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] > -----Original Message----- > From: Joe [mailto:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
