我有一個 Scala 代碼,使用 scalalikejdbc 連接并在 MySQL 中執(zhí)行插入操作。代碼運行良好約 2-3 小時,然后拋出com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.我的連接設(shè)置如下:val url = "jdbc:mysql://www.domain.com:3306/schema";val settings = ConnectionPoolSettings( initialSize = 1, maxSize = 2, connectionTimeoutMillis = 100000L, validationQuery = "select 1 from dual");ConnectionPool.add('dbval, url, username, pwd, settings);發(fā)生這種情況的任何原因以及如何解決?
添加回答
舉報
0/150
提交
取消