Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large
出現這個錯誤,其實就是你拼接的sql語句太長了,因為的mysql預設接收是不能大于1M的;
解決方案:
修複my.ini(windows)檔案裡面的配置項 max_allowed_packet,
mysql> set global max_allowed_packet = 100 * 1024 * 1024;
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large
出現這個錯誤,其實就是你拼接的sql語句太長了,因為的mysql預設接收是不能大于1M的;
解決方案:
修複my.ini(windows)檔案裡面的配置項 max_allowed_packet,
mysql> set global max_allowed_packet = 100 * 1024 * 1024;