-277 -231 -297 -300 -286 -233 -229 -203 -227 -202 -207 -210 -178 -149 -165 -147 -163 -116 -109 -103
-62 -141 -206 -161 -188 -133
-93 -104 -134 -113 -120
-88 -127 -169 -129 -173
-277 -218 -262 -300 -275 -204 -229 -203 -188 -165 -180 -163 -154 -132 -145 -147 -160 -103 -109
-26 -141 -206 -161 -188 -113
-87 -127 -103 -120
-88 -169 -129 -173
-277 -227 -281 -300 -253 -210 -237 -221 -211 -192 -218 -198 -190 -168 -196 -163 -184 -138 -142 -119
-74 -158 -235 -169 -195 -141 -112 -109 -135 -110 -120
-60 -162 -120
-88 -144 -169 -129 -173
-298 -222 -285 -300 -290 -209 -227 -203 -193 -175 -183 -175 -163 -137 -158 -139 -149 -101
-36 -144 -196 -138 -150 -117
-83 -105 -101
-94 -134 -110
-84 -107 -111 -182 -167 -121 -172 -113 -149
-253 -192 -246 -300 -220 -162 -196 -187 -164 -158 -169 -175 -142 -128 -164 -141 -179 -140
-50 -121 -219 -187 -211 -112 -101 -115 -156 -149 -121
14 -118 -100
-85 -151 -102
-96 -106 -142
-115 -128 -200
-82 -117 -137 -125 -129 -123 -158
-83 -123 -136 -189 -177 -141 -227 -129 -177
-303 -224 -276 -300 -285 -219 -254 -221 -220 -184 -215 -183 -174 -149 -178 -149 -170 -136 -116 -102
-52 -145 -205 -165 -185 -139
-94 -103 -125 -118 -101
-77 -110 -118 -114 -104 -104
-87 -132 -214 -174 -239 -141 -189
-275 -201 -273 -307 -248 -179 -200 -176 -177 -149 -178 -179 -155 -139 -175 -152 -181 -144
-60 -138 -222 -169 -221 -114 -105 -117 -149 -151 -122
-73 -106 -103 -104
-71 -108 -171 -162 -179 -131 -162
-278 -214 -257 -292 -253 -191 -248 -214 -221 -187 -214 -196 -163 -152 -181 -143 -177 -133 -100
-59 -145 -217 -169 -199 -132 -114 -130 -138 -136 -129
-97 -114 -116
-80 -130 -173 -127 -156
-289 -217 -262 -305 -250 -187 -238 -211 -209 -186 -196 -199 -156 -137 -154 -159 -186 -122 -103 -101
-52 -134 -187 -154 -178 -110
-94 -106 -136 -128 -119
-76 -101 -176 -121 -166
-309 -243 -318 -360 -276 -206 -250 -221 -222 -196 -207 -193 -190 -157 -179 -156 -162 -128 -104
-55 -154 -199 -153 -176 -123
-99 -110 -128 -122 -104
-85 -205 -115
-93 -198 -159 -124 -175
-318 -213 -260 -316 -281 -188 -249 -211 -205 -180 -205 -187 -169 -141 -172 -154 -173 -115 -106
-43 -143 -195 -143 -170 -113
-94 -133 -129 -118
-97 -121 -109
-80 -133 -191 -136 -176
-253 -174 -251 -271 -237 -158 -207 -181 -186 -148 -171 -164 -135 -120 -148 -121 -144 -106
-47 -111 -177 -174 -196 -101
-79 -108 -144 -128 -125
-99 -117 -103
-86 -103 -155 -113 -178
-207 -212 -260 -274 -216 -183 -219 -191 -209 -184 -214 -211 -174 -163 -185 -158 -211 -159 -115 -123
-81 -142 -206 -169 -195 -130
-89 -106 -137 -123 -112
-85 -184 -116
-261 -165 -245 -276 -239 -168 -203 -174 -176 -149 -184 -178 -134 -129 -150 -124 -144 -112 -117
-32 -122 -203 -157 -191
-77 -100 -130 -129 -139
-90 -115 -108
-76 -101 -153 -104 -162 -111 -148
-296 -219 -267 -312 -274 -208 -225 -197 -209 -177 -195 -193 -166 -141 -159 -163 -155 -131 -126
-47 -141 -200 -137 -189 -120
-67 -151 -112 -137
-275 -235 -280 -318 -262 -216 -235 -206 -201 -184 -194 -197 -177 -150 -169 -146 -171 -130 -107
-45 -145 -193 -139 -163 -114
-88 -124 -114
-71 -101 -165 -112 -152
-249 -200 -255 -291 -237 -182 -209 -180 -164 -150 -162 -155 -147 -127 -144 -126 -153 -117
-52 -128 -183 -144 -166
-95 -143 -133 -129
-76 -100 -125 -124 -120 -113 -142 -108
-90 -132 -140 -136 -202 -144 -206 -122 -187
-253 -212 -267 -298 -228 -187 -225 -197 -191 -166 -205 -192 -166 -148 -178 -142 -171 -127 -112
-58 -142 -229 -197 -206 -119 -100 -107 -167 -171 -187
-90 -112 -132
-75 -101 -162
-290 -261 -321 -350 -281 -220 -241 -227 -224 -194 -204 -188 -196 -167 -178 -143 -163 -132 -123 -108
-71 -176 -231 -178 -197 -144 -112 -117 -149 -137 -135
-91 -105 -120 -109 -103
-97 -132 -251 -215 -209 -166 -200
-297 -232 -303 -323 -265 -218 -253 -232 -230 -197 -237 -215 -195 -160 -205 -158 -178 -144 -123 -105
-60 -153 -208 -151 -190 -128
-94 -134 -123 -117
-98 -149 -106 -147
-265 -201 -250 -288 -253 -177 -199 -189 -178 -151 -167 -160 -153 -135 -147 -160 -148 -110 -103
-50 -134 -194 -140 -172 -110
-95 -151 -142 -146
-73 -108 -172 -137 -170 -123 -163
-289 -198 -257 -287 -229 -175 -207 -193 -185 -155 -169 -157 -142 -123 -133 -127 -122 -101
-38 -136 -189 -131 -175 -102
-92 -125 -116 -109
-60 -122 -172 -136 -151 -110 -142
-292 -184 -256 -289 -240 -192 -216 -199 -196 -155 -181 -173 -147 -121 -123 -124 -105
-19 -125 -175 -119 -163 -104
-76 -117 -118 -124
-97 -149 -112 -117 -101 -119
-300 -194 -254 -286 -262 -194 -205 -183 -187 -154 -191 -169 -166 -139 -146 -126 -136 -103 -110
-43 -146 -174 -131 -165 -121
-88 -118 -112 -107
-91 -180 -128 -153 -115 -144
-245 -190 -231 -277 -211 -172 -202 -174 -165 -148 -163 -147 -130 -123 -141 -119 -140 -103
-34 -117 -168 -123 -155
-74 -103 -143
-238 -191 -224 -257 -199 -171 -194 -179 -171 -157 -169 -171 -150 -124 -153 -133 -155 -101
-36 -123 -171 -138 -164
-84 -119 -115 -109
-76 -126 -110
-313 -255 -317 -335 -299 -240 -287 -243 -229 -213 -247 -236 -193 -184 -202 -176 -190 -152 -142 -126
-80 -176 -230 -201 -214 -149 -123 -130 -162 -162 -154
-80 -100 -113
-70 -118 -118 -129 -113 -147 -111
-96 -104 -171 -207 -163 -191 -147 -179
-284 -202 -261 -304 -274 -198 -235 -217 -200 -179 -200 -200 -159 -152 -169 -135 -146 -115
-36 -138 -206 -149 -174 -104
-81 -115 -111
-81 -106 -102 -114 -141 -137
-96 -121 -143 -122 -169 -168 -124 -187 -117 -140
-284 -217 -251 -293 -246 -184 -216 -198 -183 -161 -174 -175 -150 -123 -137 -127 -117
-28 -136 -158 -117 -139 -101
-72 -115 -168 -122 -140
-291 -236 -276 -302 -268 -224 -254 -229 -230 -195 -217 -211 -164 -169 -173 -158 -159 -119 -108
-49 -139 -177 -148 -170 -113 -107
-91 -118 -117 -118
-97 -178 -124 -169 -105 -191
-236 -210 -279 -304 -221 -173 -206 -187 -174 -166 -200 -185 -164 -151 -183 -141 -196 -143 -125 -125
-68 -140 -228 -191 -226 -130 -111 -101 -124 -119 -112
-242 -208 -252 -275 -213 -169 -205 -194 -188 -161 -175 -160 -141 -129 -147 -143 -155 -113
-42 -134 -186 -147 -179
-87 -119 -110 -101
-229 -171 -225 -262 -224 -165 -208 -190 -166 -140 -163 -147 -121 -122 -131 -121 -143
-23 -111 -186 -137 -173
-75 -112 -107 -105
-91 -101 -107
-261 -227 -286 -297 -256 -204 -236 -214 -199 -181 -202 -180 -166 -154 -168 -139 -161 -119 -124 -103
-53 -154 -205 -166 -183 -126 -103 -100 -132 -129 -123
-98 -114 -108 -103
-95 -103 -107 -184 -134 -153 -120 -144
-288 -232 -270 -314 -256 -214 -242 -218 -217 -199 -213 -195 -185 -163 -180 -165 -174 -132 -147 -116
-60 -166 -197 -159 -191 -133 -115
-96 -114 -110
-97 -178 -110 -167 -109 -141
-245 -208 -243 -284 -241 -196 -233 -208 -202 -178 -202 -182 -152 -146 -171 -146 -164 -119 -103
-47 -144 -217 -144 -187 -109
-81 -110 -101
-293 -211 -253 -294 -274 -193 -234 -207 -201 -182 -201 -190 -177 -154 -169 -156 -154 -108 -100
-39 -158 -188 -113 -147 -101
-69 -111 -102 -100
-58 -127 -136
-242 -200 -243 -277 -217 -179 -207 -168 -161 -134 -153 -137 -127 -111 -124 -117 -111
-19 -115 -160 -137 -153
-75 -119 -117 -107
-90 -152 -107 -133
-245 -171 -225 -253 -216 -162 -184 -166 -154 -133 -155 -159 -118 -110 -117 -110 -103
-18 -111 -160 -108 -156
-97 -115 -106
-281 -237 -282 -326 -278 -227 -256 -221 -203 -189 -215 -198 -188 -156 -169 -152 -155 -139 -118
-55 -163 -217 -157 -194 -127 -111 -100 -111 -111 -112
-80 -147 -100 -121
-228 -199 -252 -275 -221 -165 -203 -170 -170 -154 -190 -182 -138 -129 -157 -149 -140 -129
-36 -132 -184 -131 -158
-59 -156 -116
-245 -162 -209 -260 -230 -166 -198 -161 -148 -127 -158 -131 -113
-97 -117 -104 -111
-19 -102 -173 -128 -166
-83 -101 -119
-256 -194 -244 -277 -242 -177 -215 -182 -182 -157 -186 -168 -160 -127 -143 -129 -135 -111
-36 -128 -205 -200 -200
-95 -142 -139 -132
-72 -111 -118
-65 -101 -151
-312 -218 -242 -302 -275 -210 -238 -221 -222 -191 -205 -184 -170 -135 -161 -146 -133 -115
-24 -113 -178 -115 -144 -102
-88 -162 -105 -155
-206 -168 -222 -237 -173 -140 -187 -170 -149 -131 -151 -134 -130 -101 -114 -110 -112
-16 -102 -170 -131 -153
-69 -122 -105
-93 -110 -104
-83 -114 -155 -102 -158 -104 -133
-256 -211 -233 -290 -234 -178 -199 -182 -169 -156 -153 -150 -144 -120 -137 -122 -138 -114
-31 -136 -176 -149 -152 -105
-78 -123 -121 -107
-75 -172 -101
-88 -130 -180 -145 -172
-229 -207 -263 -286 -225 -174 -208 -189 -181 -162 -176 -189 -160 -135 -155 -137 -159 -132
-47 -141 -184 -138 -171 -141
-294 -236 -269 -318 -276 -192 -227 -213 -193 -181 -188 -174 -166 -141 -162 -139 -136 -118
-41 -151 -186 -150 -163 -125
-84 -118 -113 -105
-87 -102 -103
-74 -118 -182 -116 -169 -102 -135
-218 -198 -220 -254 -209 -161 -198 -172 -158 -142 -144 -139 -131 -102 -123 -113 -114
-10 -107 -171 -125 -140
-85 -156 -102 -144
-260 -222 -282 -302 -257 -197 -228 -211 -203 -180 -200 -197 -172 -168 -181 -165 -160 -157 -132 -135
-64 -163 -228 -176 -206 -154 -123 -110 -134 -132 -123
-69 -101 -167 -111 -153
-274 -246 -285 -326 -276 -230 -256 -219 -214 -199 -228 -222 -201 -185 -199 -161 -174 -163 -127 -132
-56 -155 -199 -147 -175 -132 -113
-97 -175 -126 -128
-213 -169 -209 -246 -200 -152 -172 -156 -153 -133 -142 -148 -110
-92 -107 -119 -105
-241 -190 -247 -288 -225 -180 -202 -193 -166 -133 -156 -151 -138 -122 -136 -132 -139 -108
-41 -116 -193 -151 -184
-91 -128 -120 -122
-81 -153 -128
-245 -190 -235 -284 -224 -164 -200 -195 -181 -153 -160 -162 -126 -118 -132 -122 -125
-31 -120 -175 -128 -153 -102
-66 -102 -103
-70 -113 -157 -100 -146
-206 -197 -238 -266 -224 -175 -189 -180 -169 -154 -164 -163 -146 -126 -151 -127 -138 -114
-39 -118 -180 -133 -156 -102
-86 -115 -114 -140
-93 -157 -100 -146
-262 -211 -251 -291 -253 -202 -218 -204 -192 -170 -177 -171 -148 -127 -145 -128 -132 -127
-24 -115 -182 -115 -156
-92 -101 -102
-86 -106 -104
-84 -103 -100 -130 -180 -139 -177 -117 -142
-212 -159 -225 -250 -172 -130 -146 -130 -127 -107 -115 -119 -111
-97 -102 -107
-96 -193 -132 -168
-224 -210 -266 -305 -236 -183 -223 -202 -185 -167 -176 -175 -140 -132 -156 -127 -146 -126
-46 -131 -202 -162 -181 -113 -108
-91 -121 -125 -132
-66 -105 -103
-38 -115 -136 -141 -122
-85 -119 -103 -124 -192 -139 -187 -132 -156
-244 -206 -256 -283 -229 -191 -201 -187 -183 -153 -160 -152 -147 -119 -130 -114 -123 -110
-25 -123 -186 -135 -166
-81 -103 -103
-232 -215 -262 -294 -229 -193 -216 -193 -184 -159 -171 -163 -161 -136 -152 -124 -140 -126 -116
-58 -142 -215 -168 -189 -124 -125 -104 -113 -115 -106
-229 -228 -302 -312 -259 -206 -243 -200 -201 -179 -209 -191 -167 -154 -194 -141 -169 -176 -114 -106
-68 -138 -235 -191 -208 -127 -109 -112 -135 -137 -146
-75 -101 -106
-74 -128 -149 -139 -121 -112 -121
-68 -119 -121 -164 -232 -156 -215 -126 -188
-293 -236 -310 -333 -288 -204 -239 -215 -221 -182 -183 -186 -172 -153 -161 -145 -152 -140 -122
-49 -154 -232 -162 -195 -128 -102 -103 -108 -110 -116
-93 -124 -113 -105
-99 -111 -121 -202 -126 -182 -108 -150
-292 -224 -290 -311 -276 -232 -235 -217 -213 -180 -211 -187 -178 -156 -174 -135 -138 -142 -109 -102
-44 -157 -197 -135 -166 -123
-94 -109 -109
-74 -125 -138
-283 -198 -242 -276 -246 -171 -217 -207 -205 -166 -183 -175 -132 -104 -130 -124 -111
-4 -106 -130
-225 -168 -223 -254 -198 -142 -197 -165 -165 -135 -158 -143 -111
-98 -120 -104 -117 -102
-34 -140 -101
-238 -226 -291 -295 -221 -196 -238 -187 -179 -163 -194 -166 -157 -142 -161 -132 -149 -133 -114
-54 -146 -234 -179 -198 -133 -104 -110 -142 -126 -120
-81 -113 -106Java语言中用jdbc连接MySql数据库总是报错 求解 - ITeye问答
错误信息如下：
com.mysql.jdbc.municationsException: Communications link failure
The last packet successfully received from the server was 1,392,390,324,572 milliseconds ago.& The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
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:2214)
at com.mysql.jdbc.ConnectionImpl.&init&(ConnectionImpl.java:773)
at com.mysql.jdbc.JDBC4Connection.&init&(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at dbutil.DBUtils.getConnection(DBUtils.java:38)
at dbutil.DBUtils.main(DBUtils.java:59)
Caused by: com.mysql.jdbc.municationsException: Communications link failure
The last packet successfully received from the server was 1,392,390,324,567 milliseconds ago.& The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.&init&(MysqlIO.java:341)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137)
... 13 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at java.net.Socket.&init&(Socket.java:366)
at java.net.Socket.&init&(Socket.java:209)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
at com.mysql.jdbc.MysqlIO.&init&(MysqlIO.java:290)
... 14 more
Exception in thread "main" java.lang.RuntimeException: 连接数据库失败
at dbutil.DBUtils.getConnection(DBUtils.java:42)
at dbutil.DBUtils.main(DBUtils.java:59)
Caused by: com.mysql.jdbc.municationsException: Communications link failure
The last packet successfully received from the server was 1,392,390,324,572 milliseconds ago.& The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
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:2214)
at com.mysql.jdbc.ConnectionImpl.&init&(ConnectionImpl.java:773)
at com.mysql.jdbc.JDBC4Connection.&init&(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at dbutil.DBUtils.getConnection(DBUtils.java:38)
... 1 more
Caused by: com.mysql.jdbc.municationsException: Communications link failure
The last packet successfully received from the server was 1,392,390,324,567 milliseconds ago.& The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.&init&(MysqlIO.java:341)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137)
... 13 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at java.net.Socket.&init&(Socket.java:366)
at java.net.Socket.&init&(Socket.java:209)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
at com.mysql.jdbc.MysqlIO.&init&(MysqlIO.java:290)
... 14 more
其他代码部分检查没有问题
连接池保留了连接，但是mysql数据库已经回收了连接，修改下数据库配置就可以了
已解决问题
未解决问题