Caused by: com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone...

最新推荐文章于 2023-12-27 07:00:00 发布

原创最新推荐文章于 2023-12-27 07:00:00 发布 · 211 阅读

0 ·

CC 4.0 BY-SA版权

技术分享专栏收录该内容

163 篇文章

订阅专栏

eclipse（java）连接mysql数据库出现异常

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.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at JDBC02.main(JDBC02.java:32)
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: 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.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2243)
	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2267)
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:966)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825)
	... 6 more

其实这是新版mysql JDBC驱动包的问题，新版本做了一些要求改动

必须在连接字符串中指明serverTimezone=GMT%2B8&useSSL=false

		//连接数据库时，必须提供与各种数据库类型相关的参数，如：主机名，端口号，数据库名
		//数据库连接url用于配置这些信息
		String url = "jdbc:mysql://localhost:3306/mysql111?characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false";

以及在加载驱动类时做了改动，需要在mysql后面加上cj

		//加载驱动类
		//Class.forName 方法用于加载指定的类
		//访问不同的数据库需要提供不同的驱动类
		//com.mysql.cj.jdbc.Drive  是mysql的驱动类
		try {
			**Class.forName("com.mysql.cj.jdbc.Driver");**
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}