Have you tried to put the mysql jdbc connector jar file under common/lib?

The problem here is that the file is not found in the classpath.

Hope this will help,

Marco
----- Original Message ----- 
From: "Sathyan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 02, 2003 7:30 AM
Subject: tomcat+j2sdk+mysql-connecto+mysql


> Hello All,
>
> I am new to tomcat and java.
>
> I want to install ipstat-0.9.7 tool which is used for bandwidyh
monitoring.
>
> I started intalling its requirements ...tomcat-4.1.27, j2sdk-1.4.2,
> mysql-connector-java-2.0.14, mysql-3.23.54 in Redhat-9
>
> I installed mysql rpm and j2sdk as binary ans its in
/usr/java/j2sdk1.4.2_01
>
> i have installed tomcat, mysql connector and ipstat in /usr/local/src and
> copied com and org of mysql connector in the
> /usr/local/src/tomcat/shred/lib.
>
> I was to able to browse the example page but not the ipstat page.
>
> Is there any version porblem ...and how to oevrcome this problem
>
> The catalina.out shows following error
>
> Sep 1, 2003 5:51:39 PM org.apache.commons.modeler.Registry loadRegistry
> INFO: Loading registry information
> Sep 1, 2003 5:51:39 PM org.apache.commons.modeler.Registry getRegistry
> INFO: Creating new Registry instance
> Sep 1, 2003 5:51:40 PM org.apache.commons.modeler.Registry getServer
> INFO: Creating MBeanServer
> Sep 1, 2003 5:51:41 PM org.apache.coyote.http11.Http11Protocol init
> INFO: Initializing Coyote HTTP/1.1 on port 8080
> Starting service Tomcat-Standalone
> Apache Tomcat/4.1.27
> Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing, config='org.apache.struts.util.LocalStrings',
> returnNull=true
> Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing, config='org.apache.struts.action.ActionResources',
> returnNull=true
> Sep 1, 2003 5:51:44 PM org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing, config='org.apache.webapp.admin.ApplicationResources',
> returnNull=true
> Sep 1, 2003 5:51:48 PM org.apache.coyote.http11.Http11Protocol start
> INFO: Starting Coyote HTTP/1.1 on port 8080
> Sep 1, 2003 5:51:48 PM org.apache.jk.common.ChannelSocket init
> INFO: JK2: ajp13 listening on /0.0.0.0:8009
> Sep 1, 2003 5:51:48 PM org.apache.jk.server.JkMain start
> INFO: Jk running ID=0 time=1/462
> config=/usr/local/src/jakarta-tomcat-4.1.27/conf/jk2.properties
> [Mon Sep 01 17:51:56 IST 2003]  error: PoolManager: Can't register JDBC
> driver: org.gjt.mm.mysql.Driver : java.lang.ClassNotFoundException:
> org.gjt.mm.mysql.Driver
>         at
>
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav
> a:1444)
>         at
>
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.jav
> a:1289)
>         at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
>         at java.lang.Class.forName0(Native Method)
>         at java.lang.Class.forName(Class.java:141)
>         at
> com.wrox.connectionpool.PoolManager.loadDrivers(PoolManager.java:82)
>         at com.wrox.connectionpool.PoolManager.init(PoolManager.java:69)
>         at com.wrox.connectionpool.PoolManager.<init>(PoolManager.java:23)
>         at
> com.wrox.connectionpool.PoolManager.getInstance(PoolManager.java:31)
>         at com.rsi.ipstat.DBManager.<clinit>(DBManager.java:20)
>         at com.rsi.ipstat.LoginBean.validate(LoginBean.java:21)
>         at
> org.apache.jsp.login_process_jsp._jspService(login_process_jsp.java:63)
>         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.java:2
> 10)
>         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(Application
> FilterChain.java:247)
>         at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
>         at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:256)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
> va:191)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
>         at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
> )
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:171)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
> )
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         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.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         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:601)
>         at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
> ction(Http11Protocol.java:392)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>         at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:619)
>         at java.lang.Thread.run(Thread.java:534)
>
> [Mon Sep 01 17:51:56 IST 2003]  error: stat: Exception getting connection
:
> java.sql.SQLException: No suitable driver
>         at java.sql.DriverManager.getConnection(DriverManager.java:532)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at
>
com.wrox.connectionpool.ConnectionPool.newConnection(ConnectionPool.java:183
> )
>         at
>
com.wrox.connectionpool.ConnectionPool.getPooledConnection(ConnectionPool.ja
> va:171)
>         at
>
com.wrox.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:91)
>         at
>
com.wrox.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:71)
>         at
> com.wrox.connectionpool.PoolManager.getConnection(PoolManager.java:191)
>         at com.rsi.ipstat.DBManager.getUser(DBManager.java:372)
>         at com.rsi.ipstat.LoginBean.validate(LoginBean.java:21)
>         at
> org.apache.jsp.login_process_jsp._jspService(login_process_jsp.java:63)
>         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.java:2
> 10)
>         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(Application
> FilterChain.java:247)
>         at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
>         at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:256)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
> va:191)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
>         at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
> )
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:171)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
> )
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         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.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         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:601)
>         at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
> ction(Http11Protocol.java:392)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>         at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:619)
>         at java.lang.Thread.run(Thread.java:534)
>
> [Mon Sep 01 17:51:56 IST 2003]  error: PoolManager: Exception getting
> connection from stat : java.sql.SQLException: No suitable driver
>         at java.sql.DriverManager.getConnection(DriverManager.java:532)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at
>
com.wrox.connectionpool.ConnectionPool.newConnection(ConnectionPool.java:183
> )
>         at
>
com.wrox.connectionpool.ConnectionPool.getPooledConnection(ConnectionPool.ja
> va:171)
>         at
>
com.wrox.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:91)
>         at
>
com.wrox.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:71)
>         at
> com.wrox.connectionpool.PoolManager.getConnection(PoolManager.java:191)
>         at com.rsi.ipstat.DBManager.getUser(DBManager.java:372)
>         at com.rsi.ipstat.LoginBean.validate(LoginBean.java:21)
>         at
> org.apache.jsp.login_process_jsp._jspService(login_process_jsp.java:63)
>         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.java:2
> 10)
>         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(Application
> FilterChain.java:247)
>         at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
>         at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrap
> perValve.java:256)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
> va:191)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
>         at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
> )
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:171)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
> )
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         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.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         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:601)
>         at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
> ction(Http11Protocol.java:392)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>         at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:619)
>         at java.lang.Thread.run(Thread.java:534)
>
> [Mon Sep 01 17:51:56 IST 2003]  error: IPStat: DBManager :
> java.lang.NullPointerException
>         at com.rsi.ipstat.DBManager.getUser(DBManager.java:374)
>         at com.rsi.ipstat.LoginBean.validate(LoginBean.java:21)
>         at
> org.apache.jsp.login_process_jsp._jspService(login_process_jsp.java:63)
>         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.java:2
> 10)
>         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(Application
> FilterChain.java:247)
>         at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
>         at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:256)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
> va:191)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
>         at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
> )
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:171)
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
> )
>         at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(StandardPipeline.java:641)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         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.invok
> eNext(StandardPipeline.java:643)
>         at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         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:601)
>         at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
> ction(Http11Protocol.java:392)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>         at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:619)
>         at java.lang.Thread.run(Thread.java:534)
>
> java.lang.NullPointerException
>         at
> com.wrox.connectionpool.ConnectionPool.release(ConnectionPool.java:207)
>         at
com.wrox.connectionpool.PoolManager.release(PoolManager.java:223)
>         at com.rsi.ipstat.DBManager$1.run(DBManager.java:25)
> Stopping service Tomcat-Standalone
> java.net.SocketException: Network is unreachable
>         at java.net.PlainSocketImpl.socketConnect(Native Method)
>         at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
>       at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:169)
>         at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
>         at java.net.Socket.connect(Socket.java:452)
>         at java.net.Socket.connect(Socket.java:402)
>         at java.net.Socket.<init>(Socket.java:309)
>         at java.net.Socket.<init>(Socket.java:153)
>         at
> org.apache.jk.common.ChannelSocket.destroy(ChannelSocket.java:384)
>         at org.apache.jk.server.JkMain.stop(JkMain.java:311)
>         at
> org.apache.jk.server.JkCoyoteHandler.destroy(JkCoyoteHandler.java:181)
>         at
> org.apache.coyote.tomcat4.CoyoteConnector.stop(CoyoteConnector.java:1205)
>         at
> org.apache.catalina.core.StandardService.stop(StandardService.java:546)
>         at
> org.apache.catalina.core.StandardServer.stop(StandardServer.java:2225)
>         at
>
org.apache.catalina.startup.Catalina$CatalinaShutdownHook.run(Catalina.java:
> 624)
>
>
> ---------------------------------------------------------------------
> 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]

Reply via email to