我试图将我的spring boot应用程序连接到MYSQL工作台,但我在MYSQL WorkBench中找不到我的任何列。
我的设置:这个application.properties文件
spring.datasource.url=jdbc:mysql://localhost:3306/blog?useUnicode=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.hibernate.ddl-auto=create-drop
spring.jpa.show-sql=true当我在不使用"?useUnicode=true&useLegacyDatetimeCode=false&serverTimezone=UTC“的情况下尝试时,我得到以下错误
HHH000342: Could not obtain connection to query metadata : The server time zone value 'EDT' 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.我的Maven依赖项
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.3.0.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.blogportfolio</groupId>
<artifactId>blog</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>Bala's Blog</name>
<description>Blog portfolio backend</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>文章类
package com.blogbackend.Model;
import com.sun.istack.NotNull;
import lombok.Getter;
import lombok.Setter;
import javax.persistence.*;
import java.util.Date;
@Entity
@Getter
@Setter
@Table (name = "Articles")
public class Article {
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE)
private int id;
@NotNull
@Column(name="articleName")
private String artName;
@NotNull
@Column(name="articleBody")
private String artBody;
@NotNull
@Column(name="articleCategory")
private String artCategory;
@NotNull
@Column(name="articleCreated")
private Date artCreated;
@Column
private Author author;
public Article(int id) {
this.id = id;
}
}当我转到WorkBench时,博客模式是空的。

发布于 2020-06-04 06:16:03
发布于 2020-06-04 06:37:34
您的Article实体的标识生成策略是GenerationType.SEQUENCE。但是MySQL并不直接支持Sequence。
这就是为什么当spring.jpa.hibernate.ddl-auto=create-drop尝试创建模式时失败的原因。
与GenerationType.IDENTITY一起使用AUTO_INCREMENT。
https://stackoverflow.com/questions/62183490
复制相似问题