问题一:Failed to determine a suitable driver class
问题描述:
[user-center:192.168.1.62:0000] [,] 2021-08-12 18:00:41.531 WARN 21208 [main] [com/baomidou/mybatisplus/autoconfigure/MybatisPlusAutoConfiguration.class]: Unsatisfied dependency expressed through method ‘sqlSessionFactory’ parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dataSource’ defined in class path resource [com/alibaba/druid/spring/boot/autoconfigure/DruidDataSourceAutoConfigure.class]: Invocation of init method failed; nested exception is org.springframework.boot.autoconfigure.jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver class
解决方法:
方法一:
修改启动文件注解
@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
我没有解决此问题
方法二:
particular profile you may need to activate it (no profiles are currently active).
注意到没有配置文件生效,也许是配置文件有问题。将user-center.yaml应改为application.yml系统才能识别。
问题二:The server time zone value ‘�й���ʱ��’ is unrecognized or represents more than one time zone
问题描述:
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.
分析:
问题描述中提示没有发现或者存在多个时区问题。
解决方法:
在数据源url中增加一个serverTimezone.
serverTimezone=Asia/Shanghai