使用JDBC连接到mysql数据库时出现此错误。
Database.getConnection() Error -->The server time zone value 'EEST' 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.
那是我的连接代码。
public static Connection getConnection(){ try { Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/management", "root", "root"); return con; } catch (ClassNotFoundException | SQLException e) { // TODO Auto-generated catch block System.out.println("Database.getConnection() Error -->" + e.getMessage()); return null; } }
我认为Mysql和系统的时区不匹配存在问题。因此最好将值设置为同步。