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
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
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
Re: tomcat+j2sdk+mysql-connecto+mysql
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]
