数据库
关注
分享
扫一扫
文章平均质量分 57
行浪
越努力越幸运！
展开
-
The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone问题解决
今天在使用JDBC连接数据库时出了一点问题：Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual l...原创 2018-04-14 15:01:26 · 16168 阅读 · 14 评论 -
Incorrect string value: '\xE5\xBC\xA0\xE7\x82\xAF...' for column 'name' at row 1
Incorrect string value: '\xE5\xBC\xA0\xE7\x82\xAF...' for column 'name' at row 1解决办法：需要修改数据库(或者表，或者字段)编码格式，一般是像这样：ALTER TABLE tbl_contact CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;网上有些批量修改...原创 2018-05-07 16:15:40 · 2321 阅读 · 0 评论 -
数据库连接问题解决
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 mus...原创 2018-10-13 11:32:32 · 435 阅读 · 0 评论 -
Java Web和Android出现的一些问题及解决方法记录
这段时间同时做安卓和Java Web后端，出现和解决一些小问题。记录一下：1.java.sql.SQLException: Data truncated for column 'dead_time' at row 1解决：数据被截断，请检查表字段类型和待添加的数据类型是否一致。我这里dead_time类型使用了int，肯定出问题。2.org.json.JSONExcept...原创 2019-01-05 21:46:46 · 600 阅读 · 2 评论 -
The last packet sent successfully to the server was 51,155,890 milliseconds ago. is longer than the
使用MySQL数据库时出现的异常：Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. ...原创 2019-10-05 14:00:53 · 684 阅读 · 0 评论