Hello Marco, i copied the mysql-jdbc driver in common/lib and this time i am getting error as
[Tue Sep 02 14:59:22 IST 2003] error: PoolManager: Exception getting connection from stat : java.sql.SQLException: getConnection() timed-out at com.wrox.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:107 ) 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) Regards, Sathi > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]