Re: tomcat+j2sdk+mysql-connecto+mysql
Hello Chris Williams, Thanks for your guides. Now its working well. Regards Sathi Try to isolate the problem. Check that you can get a Connection object by doing something like the following: String driver = ...; String url = ...; String userName = ...; String pw = ...; Connection conn = null; try { Class.forName(driver); conn = DriverManager.getConnection(url, userName, pw); } catch (Exception e) { e.printStackTrace(); } // Do something with conn... if (null != conn) { ... try { conn.close(); } catch (Exception e) {} conn = null; } This will enable you to isolate where your problem lies. If you can get a Connection object then your database and JDBC driver are set up correctly, you have the correct URL for the data source, you have a valid user name and password and the problem lies with the Wrox ConnectionPool class. Otherwise some element of your database setup is incorrect. Check that you are referencing the driver class correctly. When I need to talk to MySQL I use the Connector /J driver available from the MySQL web site: http://www.mysql.com/downloads/api-jdbc-stable.html The name of the driver is: com.mysql.jdbc.Driver Check that you have spelt it correctly. Assume that you are accessing a MySQL database called my_db on localhost. The URL to the datasource takes the form: jdbc:mysql://localhost:3306/im_audit If MySQL is not listening on port 3306, you will need to change the port value. I leave user name and password to you - you can always use root during development. Chris Williams. - 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]
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
Re: tomcat+j2sdk+mysql-connecto+mysql
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