解决问题记录4:kettle数据库连接报错时区问题
问题:Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone
问题:Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.
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数据库时区即可或者在kettle数据库连接的选项中配置serverTimezone参数,我使用的是后者。
show variables like '% time_zone%';
set global time_zone = '+8:00';
kettle中设置serverTimezone参数
更多推荐
所有评论(0)