数据库连接端口问题

ssh操作数据库时出现这个问题,后来发现数据库连接端口错误的问题。

 

Communications   link   failure   due   to   underlying   exception:  

**   BEGIN   NESTED   EXCEPTION   **  

java.io.EOFException
MESSAGE:   Can   not   read   response   from   server.   Expected   to   read   4   bytes,   read   0   bytes   before   connection   was   unexpectedly   lost.

STACKTRACE:

java.io.EOFException:   Can   not   read   response   from   server.   Expected   to   read   4   bytes,   read   0   bytes   before   connection   was   unexpectedly   lost.
at   com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997)
at   com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)
at   com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
at   com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at   com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at   com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at   com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at   com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
at   org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at   jdbcConnect.DBconnect.executePreQuery(DBconnect.java:214)
at   Inc.chkuser.checklogin(chkuser.java:84)
at   org.apache.jsp.orderset_jsp._jspService(orderset_jsp.java:97)
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.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
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:102)
at   org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at   org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at   org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at   org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at   org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at   org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at   org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at   org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at   java.lang.Thread.run(Thread.java:595)


**   END   NESTED   EXCEPTION   **


连接池设置
                                    <Resource
                                                name= "jdbc/song "
                                                type= "javax.sql.DataSource "
                                                driverClassName= "com.mysql.jdbc.Driver "
                                                password= "haishui "
                                                maxIdle= "20 "
                                                maxWait= "5000 "
                                                username= "mysql "
                                                url= "jdbc:mysql://210.21.206.200/enshine "
                                                maxActive= "80 "

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值