jdbc:mysql://localhost:3306/mydb?autoReconnect=true&useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Hongkong
jdbc:mysql://localhost:3306/mydb
autoReconnect=true
useUnicode=true&characterEncoding=utf8
useSSL=false
serverTimezone=Hongkong
autoReconnectForPools=true
failOverReadOnly=true
maxReconnectsautoReconnect=true
initialTimeoutautoReconnect=true
connectTimeout=100
socketTimeoutsocket=1000
在使用数据库连接池的情况下,最好设置如下两个参数:
autoReconnect=true&failOverReadOnly=false
需要注意的是,在xml配置文件中,url中的&符号需要转义成&。比如在tomcat的server.xml中配置数据库连接池时,mysql jdbc url样例如下:
jdbc:mysql://localhost:3306/test?user=root&password=&useUnicode=true&characterEncoding=gbk
&autoReconnect=true&failOverReadOnly=false
—
参考:
https://www.cnblogs.com/yokoboy/archive/2013/03/01/2939315.html
MySQL官网文档: http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html
https://www.huaweicloud.com/articles/e70b4852d363bdad2cce3be977590d38.html