一、spring boot在使用thymeleaf时报
javax.servlet.ServletException: Circular view path [index]: would dispatch back to the current handler URL [/index] again. Check your ViewResolver setup! (Hint: This may be the result of an unspecified view, due to default view name generation.)
经过仔细检查发现,在pom.xml未导入thymeleaf包,
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency>
二、在使用mysql数据库查询数据时报,
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
2018-11-02 10:33:25.665 WARN 8384 --- [nio-8080-exec-4] c.a.d.p.v.MySqlValidConnectionChecker : Cannot resolve com.mysq.jdbc.Connection.ping method. Will use 'SELECT 1' instead.
2018-11-02 11:07:04.859 ERROR 6104 --- [nio-8080-exec-4] com.alibaba.druid.pool.DruidDataSource : init datasource error
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.
解决方案:
将application.yaml中的url加上?serverTimezone=GMT
url: jdbc:mysql://localhost:3306/test?serverTimezone=GMT