数据库连接问题解决

Sat Oct 13 10:54:36 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

解决：添加上useSSL=false

XML中：

jdbc:mysql://ip:3306/proj?serverTimezone=GMT%2B8&useSSL=false

字符串中：

jdbc:mysql://ip:3306/proj?serverTimezone=GMT%2B8&useSSL=false

 

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User 'MyDB01' has exceeded the 'max_connections_per_hour' resource (current value: 100)

解决：调大每小时最多连接数

 

 

使用存储过程时记得对需要的用户添加execute权限；除此之外，还要对用户添加对mysql数据库的select权限。

 

C3P0 APPARENT DEADLOCK

如果使用C3P0时报出上面的死锁的异常，在网上找资料你会得到说是C3P0的bug，解决办法一般说是如下：

C3P0 APPARENT DEADLOCK  https://www.programering.com/a/MDNxgjNwATU.html

不过要知道，当你的连接参数，ip，端口，数据库用户密码等等出现无法连接的时候也会抛出此类异常，所以先检查自己的参数是否有问题。我当时就是换了个IP居然忘了改参数报了这个错。