Java连接mysql数据库时出现的问题记录

古城微笑少年丶 2024-04-17 06:05 11阅读 0赞

# Unknown initial character set index ‘255’ received from server. #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]  
解决办法

在dataSource配置url最后面加上useUnicod=true&characterEncoding=utf-8  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 1]

# The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver #

开发数据库相关的项目时，出现如下的异常：org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

解决办法：

根据提示需要在配置数据库的连接信息中，在MySQL的URL后面加上“serverTimezone=UTC”

# Unknown system variable ‘tx\_isolation’ #

今天在进行本机的数据库连接的时候出现了一个问题：

Caused by: java.sql.SQLException: Unknown system variable ‘tx_isolation’

一开始以为是隔离级别的问题，但是最终排查出来了问题是mysql-connector-java的版本太低，数据库的版本太高 因此将mysql-connector-java升级到最新版本就解决了问题.

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/16/455ebebeb11147849076e968b8f1400c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/16/df41aa79961040b0ab2ccf66f2fddaf6.png