1.问题:这是在使用MySQL 8.0以上版本(MySQL连接驱动和版本都是8.0以上)的时候出现的问题错误
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=GMT%2B8
2.数据库的日期时间字段的值为:0000-00-00 00:00:00
com.mysql.cj.exceptions.DataReadException: Zero date value prohibited
解决:zeroDateTimeBehavior=convertToNull
原因:数据库的日期时间字段的值为:
0000-00-00 00:00:00
在application.yml的完整示例
spring:
datasource:
url: jdbc:mysql:///mydb1?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false
username: root
password: 1234
driver-class-name: com.mysql.cj.jdbc.Driver
3. Field authenticationManager in com.qf.ability.auth.application.AuthServerConfiguration required a bean of type 'org.springframework.security.authentication.AuthenticationManager' that could not be found.
authenticationManager 需要一个无法找到的“org.springframework.security.authentication.AuthenticationManager”类型的 bean。
忘了加Bean粗心大意吐了
4. javax.servlet.ServletContext.getVirtualServerName()...
好像是导入servlet-api,SpringBoot自带了,起了冲突
去找一下是不是自己导入Tomcat的servlet-api
5. a.c.s.dashboard.metric.MetricFetcher : Failed to fetch metric from
访问sentinel实时监控不显示
意思是找不到这个地址
可以ping一下
已解决,关闭windows防火墙