tomcat的log文件上的错误如何解决？

shasha82 2012-03-21 03:52:44
我测试的时候没有问题，但是发布到服务器上后，就出现大量错误。绝大多数这两种，而且是随机的，似乎网站访问量大了，就大量报错。
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.

	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

	at java.lang.reflect.Constructor.newInstance(Unknown Source)

	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)

	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)

	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

	at sun.reflect.GeneratedConstructorAccessor15.newInstance(Unknown Source)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

	at java.lang.reflect.Constructor.newInstance(Unknown Source)

	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)

	at java.sql.DriverManager.getConnection(Unknown Source)

	at java.sql.DriverManager.getConnection(Unknown Source)

	at com.machina.datalink.DBMysqlLink.getConn(DBMysqlLink.java:14)

	at com.machina.dao.WebShowDAO.getShowProjects(WebShowDAO.java:19)

	at org.apache.jsp.index_jsp._jspService(index_jsp.java:2120)

	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)

	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)

	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)

	at java.lang.Thread.run(Unknown Source)

Caused by: java.net.ConnectException: Connection refused: connect

	at java.net.PlainSocketImpl.socketConnect(Native Method)

	at java.net.PlainSocketImpl.doConnect(Unknown Source)

	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

	at java.net.PlainSocketImpl.connect(Unknown Source)

	at java.net.SocksSocketImpl.connect(Unknown Source)

	at java.net.Socket.connect(Unknown Source)

	at java.net.Socket.connect(Unknown Source)

	at java.net.Socket.<init>(Unknown Source)

	at java.net.Socket.<init>(Unknown Source)

	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)

	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)

	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)

	... 31 more

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
或者
java.lang.NullPointerException

	at com.machina.dao.ParaDAO.getParaName(ParaDAO.java:20)

	at com.machina.dao.SearchDAO.getShowMaProjects(SearchDAO.java:213)

	at com.machina.dao.SearchDAO.getShowProjects(SearchDAO.java:526)

	at org.apache.jsp.search_jsp._jspService(search_jsp.java:144)

	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)

	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)

	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)

	at java.lang.Thread.run(Unknown Source)



com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure



Last packet sent to the server was 0 ms ago.

	at sun.reflect.GeneratedConstructorAccessor19.newInstance(Unknown Source)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

	at java.lang.reflect.Constructor.newInstance(Unknown Source)

	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)

	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)

	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)

	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

	at sun.reflect.GeneratedConstructorAccessor15.newInstance(Unknown Source)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

	at java.lang.reflect.Constructor.newInstance(Unknown Source)

	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)

	at java.sql.DriverManager.getConnection(Unknown Source)

	at java.sql.DriverManager.getConnection(Unknown Source)

	at com.machina.datalink.DBMysqlLink.getConn(DBMysqlLink.java:14)

	at com.machina.dao.ParaDAO.getParaName(ParaDAO.java:19)

	at com.machina.dao.SearchDAO.getShowMaProjects(SearchDAO.java:206)

	at com.machina.dao.SearchDAO.getShowProjects(SearchDAO.java:526)

	at org.apache.jsp.search_jsp._jspService(search_jsp.java:144)

	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)

	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)

	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)

	at java.lang.Thread.run(Unknown Source)

Caused by: java.net.ConnectException: Connection refused: connect

	at java.net.PlainSocketImpl.socketConnect(Native Method)

	at java.net.PlainSocketImpl.doConnect(Unknown Source)

	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

	at java.net.PlainSocketImpl.connect(Unknown Source)

	at java.net.SocksSocketImpl.connect(Unknown Source)

	at java.net.Socket.connect(Unknown Source)

	at java.net.Socket.connect(Unknown Source)

	at java.net.Socket.<init>(Unknown Source)

	at java.net.Socket.<init>(Unknown Source)

	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)

	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)

	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)

	... 33 more
...全文
140 8 打赏 收藏 转发到动态 举报
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
shasha82 2012-03-22
  • 打赏
  • 举报
 回复 
public static Connection getConn() {

		Connection conn = null;

		try {

			Class.forName("com.mysql.jdbc.Driver");

		

			//  测试环境

			 conn = DriverManager.getConnection("jdbc:mysql://localhost/aaa?user=aa&password=aa");

		

		} catch (ClassNotFoundException e) {

			e.printStackTrace();

			System.out.println("DBMysqlLink的connection出错。");

		} catch (SQLException e) {

			e.printStackTrace();

		}



		return conn;

	}
shasha82 2012-03-22
  • 打赏
  • 举报
 回复
回楼上的，是自己写的。没用过连接池...
iihero_ 2012-03-21
  • 打赏
  • 举报
 回复
com.machina.datalink.DBMysqlLink.getConn??
这个库是你们自己写的？初步估计是这个库本身的问题。

用比较能用的连接池不好吗？dbcp等等。
shasha82 2012-03-21
  • 打赏
  • 举报
 回复
应该没用连接池...每个函数都是这种结构...然后这些函数放在jsp里。


// 根据id查找ivtor名称

	public static String findIvtorNameById(String id) {

		Connection conn = null;

		PreparedStatement pstmtAct = null;

		ResultSet rsAct = null;

		String temp = "";

		// 活动

		String sqlAct = "select investorName from ivt where id='" + id + "'";

		try {

			conn = DBMysqlLink.getConn();

			pstmtAct = conn.prepareStatement(sqlAct);

			rsAct = pstmtAct.executeQuery();

			if (rsAct != null) {

				while (rsAct.next()) {

					temp = rsAct.getString("investorName");

				}

			} else {

				System.out.println("ivtorName查找失败！");

			}



		} catch (Exception e) {

			e.printStackTrace();

		} finally {

			if (conn != null) {

				try {

					pstmtAct.close();

				} catch (SQLException sx) {

					sx.printStackTrace();

				}

				DBMysqlLink.close(conn);

			}

		}

		return temp;

	}
ACMAIN_CHM 2012-03-21
  • 打赏
  • 举报
 回复
是不是使用了连接池？
shasha82 2012-03-21
  • 打赏
  • 举报
 回复
http://topic.csdn.net/u/20090527/13/3adff71c-7186-415c-a800-ed235500558c.html

后来查出原因是，防火墙有设定，15分钟就销毁timeout连接。。。
结贴。

会是这个问题吗？不过我的时间很短很短...
shasha82 2012-03-21
  • 打赏
  • 举报
 回复
类似于 http://topic.csdn.net/u/20110815/18/D28095E6-27BB-451B-B988-D0776186F657.html 碰到的问题...
Tomcat日志乱码了怎么处理？
2)Tomcat Locathost Log和Tomcat Catalina Log乱码的情况，解决方法和上面一样，只是修改的位置不同，修改下图位置。首先，找到本地tomcat的conf目录下的logging.properties，这个文件中有5个编码的位置。1)对于...
关于IDEA没有显示日志输出？IDEA控制台没有显示Tomcat Localhost Log和Catalina Log 怎么办？
但是我们下载的Tomcat只有一个，这个CATILINA_BASE就是相当于在IDEA工具里面显示的多个Tomcat日志文件恶输出位置。而之前学习IDEA的时候，把这个文件的位置改变了。导致，最后输出IDEA的时候，不会把日志也打印出来...
linux 配置tomcat日志服务器,配置Tomcat输出log文件
最近做的项目总是出现404错误，在控制台...首先在Tomcat的安装目录的common/classes/(非安装的tomcat可以找到tomcat的解压包下面的就可以了)，在这里建一个log4j.properties文件内容是log4j.rootLogger=info,Console...
Tomcat log 中各种日志及日志记录内容
Tomcat log 中各种日志及日志记录内容 内容1 catalina.log 记录tomcat启动时候的信息 localhost.log 记录运行日志 localhost_access_log 存放访问tomcat的请求的所有地址以及请求的路径、时间，请求协议以及返回码...
tomcat-log目录下各日志文件的作用
　这个日期放的估计是利用服务方式启动tomcat作为守护进程的日志记录，因为我的tomcat启动方式是以服务的方式启动的，索引产生这个日志文件记录了服务的启动状态。 3.host-manager.日期.log 　这个估计是放tomcat的...
MySQL

56,678

社区成员

56,708

社区内容

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章