[問題] JSP連mysql的錯誤訊息
我很確定connection有用完即關,但是我只要query次數達10次左右,
mysql就會瞬斷,且出現以下例外訊息:
com.mysql.jdbc.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.
然後再也撈不到任何資料,過一下子,mysql又自動活起來,這時候撈資料就有了,
我的mysql是4.0.26版,JDBC Driver是用mysql-connector-java-5.1.12-bin
,用ODBC的方式也是會出現例外,資料量只有60筆,已經想無對策了,
想問看看大家有沒有解決方式,再不行我只好改用其他的database了。
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 122.123.196.103
→
06/06 02:52, , 1F
06/06 02:52, 1F
→
06/06 02:53, , 2F
06/06 02:53, 2F
→
06/06 16:03, , 3F
06/06 16:03, 3F
→
06/07 13:45, , 4F
06/07 13:45, 4F
推
06/07 23:43, , 5F
06/07 23:43, 5F
→
06/12 16:19, , 6F
06/12 16:19, 6F