com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
package com.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.bean.Message;
/*
?* 列表頁面初始化控制
?*
?*/
@SuppressWarnings("serial")
public class ListServlet extends HttpServlet{
?? ?@Override
?? ?protected void doGet(HttpServletRequest req, HttpServletResponse resp)
?? ??? ??? ?throws ServletException, IOException {
?? ??? ?try {
?? ??? ??? ?Class.forName("com.mysql.jdbc.Driver");
?? ??? ??? ?Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3360/micro_message?autoReconnect=true","root","root");
?? ??? ??? ?String sql = "select ID,COMMAND,DESCRIPTION,CONTENT from MESSAGE";
?? ??? ??? ?PreparedStatement statement = conn.prepareStatement(sql);
?? ??? ??? ?ResultSet rs = statement.executeQuery();
?? ??? ??? ?List<Message>messageList = new ArrayList<Message>();
?? ??? ??? ?while(rs.next()){
?? ??? ??? ??? ?Message message = new Message();
?? ??? ??? ??? ?messageList.add(message);
?? ??? ??? ??? ?message.setId(rs.getString("ID"));
?? ??? ??? ??? ?message.setCommand(rs.getString("COMMAND"));
?? ??? ??? ??? ?message.setDescription(rs.getString("DESCRIPTION"));
?? ??? ??? ??? ?message.setContent(rs.getString("CONTENT"));
?? ??? ??? ?}
?? ??? ??? ?req.setAttribute("messageList", messageList);
?? ??? ?} catch (ClassNotFoundException e) {
?? ??? ??? ?e.printStackTrace();
?? ??? ?} catch (SQLException e) {
?? ??? ??? ?e.printStackTrace();
?? ??? ?}
?? ??? ?req.getRequestDispatcher("/WEB-INF/jsp/back/list.jsp").forward(req,resp);
?? ?}
?? ?@Override
?? ?protected void doPost(HttpServletRequest req, HttpServletResponse resp)
?? ??? ??? ?throws ServletException, IOException {
?? ??? ?this.doGet(req, resp);
?? ?}
}
2019-03-12
檢查一下?DriverManager.getConnection中三個參數(shù)的書寫有沒有問題
2018-05-08
數(shù)據(jù)庫連接異常 不出意外應(yīng)該少連接數(shù)據(jù)庫的驅(qū)動包
2018-04-01
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
?? ?at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
?? ?at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
?? ?at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
?? ?at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
?? ?at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
?? ?at com.mysql.jdbc.Util.getInstance(Util.java:386)
?? ?at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
?? ?at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
?? ?at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
?? ?at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
?? ?at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2237)
?? ?at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2158)
?? ?at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
?? ?at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
?? ?at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
?? ?at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
?? ?at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
?? ?at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
?? ?at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
?? ?at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
?? ?at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
?? ?at java.sql.DriverManager.getConnection(DriverManager.java:571)
?? ?at java.sql.DriverManager.getConnection(DriverManager.java:215)
?? ?at com.servlet.ListServlet.doGet(ListServlet.java:30)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
?? ?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:230)
?? ?at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
?? ?at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
?? ?at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
?? ?at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
?? ?at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
?? ?at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
?? ?at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
?? ?at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
?? ?at java.lang.Thread.run(Thread.java:744)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
?? ?at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
?? ?at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
?? ?at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
?? ?at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
?? ?at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
?? ?at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
?? ?at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
?? ?at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
?? ?at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2176)
?? ?... 27 more
Caused by: java.net.ConnectException: Connection refused: connect
?? ?at java.net.DualStackPlainSocketImpl.connect0(Native Method)
?? ?at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
?? ?at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
?? ?at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
?? ?at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
?? ?at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
?? ?at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
?? ?at java.net.Socket.connect(Socket.java:579)
?? ?at java.net.Socket.connect(Socket.java:528)
?? ?at java.net.Socket.<init>(Socket.java:425)
?? ?at java.net.Socket.<init>(Socket.java:241)
?? ?at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
?? ?at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
?? ?... 29 more
四月 01, 2018 2:00:42 下午 org.apache.catalina.core.ApplicationDispatcher invoke
嚴(yán)重: Servlet.service() for servlet jsp threw exception
javax.el.PropertyNotFoundException: Property 'command' not found on type java.lang.String
?? ?at javax.el.BeanELResolver$BeanProperties.get(BeanELResolver.java:193)
?? ?at javax.el.BeanELResolver.property(BeanELResolver.java:267)
?? ?at javax.el.BeanELResolver.getValue(BeanELResolver.java:60)
?? ?at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
?? ?at org.apache.el.parser.AstValue.getValue(AstValue.java:97)
?? ?at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
?? ?at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:923)
?? ?at org.apache.jsp.WEB_002dINF.jsp.back.list_jsp._jspx_meth_c_005fforEach_005f0(list_jsp.java:171)
?? ?at org.apache.jsp.WEB_002dINF.jsp.back.list_jsp._jspService(list_jsp.java:108)
?? ?at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
?? ?at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
?? ?at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
?? ?at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
?? ?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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
?? ?at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)
?? ?at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
?? ?at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
?? ?at com.servlet.ListServlet.doGet(ListServlet.java:49)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
?? ?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:230)
?? ?at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
?? ?at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
?? ?at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
?? ?at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
?? ?at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
?? ?at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
?? ?at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
?? ?at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
?? ?at java.lang.Thread.run(Thread.java:744)
四月 01, 2018 2:00:42 下午 org.apache.catalina.core.StandardWrapperValve invoke
嚴(yán)重: Servlet.service() for servlet ListServlet threw exception
javax.el.PropertyNotFoundException: Property 'command' not found on type java.lang.String
?? ?at javax.el.BeanELResolver$BeanProperties.get(BeanELResolver.java:193)
?? ?at javax.el.BeanELResolver.property(BeanELResolver.java:267)
?? ?at javax.el.BeanELResolver.getValue(BeanELResolver.java:60)
?? ?at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
?? ?at org.apache.el.parser.AstValue.getValue(AstValue.java:97)
?? ?at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
?? ?at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:923)
?? ?at org.apache.jsp.WEB_002dINF.jsp.back.list_jsp._jspx_meth_c_005fforEach_005f0(list_jsp.java:171)
?? ?at org.apache.jsp.WEB_002dINF.jsp.back.list_jsp._jspService(list_jsp.java:108)
?? ?at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
?? ?at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
?? ?at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
?? ?at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
?? ?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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
?? ?at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)
?? ?at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
?? ?at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
?? ?at com.servlet.ListServlet.doGet(ListServlet.java:49)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
?? ?at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
?? ?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:230)
?? ?at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
?? ?at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
?? ?at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
?? ?at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
?? ?at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
?? ?at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
?? ?at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
?? ?at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
?? ?at java.lang.Thread.run(Thread.java:744)