Spring Boot+Hibernate+PostgreSQL启动时不自动建表且无报错
Spring Boot启动后Hibernate未在PostgreSQL创建表
我刚开始学习Spring Boot,启动应用后发现Hibernate没有根据实体类在PostgreSQL中创建对应表,但应用启动正常且无任何报错信息。以下是我的代码配置、控制台日志及已做的排查操作:
实体类(Student.java)
package com.example.springboot.student; import javax.persistence.*; import java.time.LocalDate; @Entity @Table public class Student { @Id @SequenceGenerator( name = "student_sequence", sequenceName = "student_sequence", allocationSize = 1 ) @GeneratedValue( strategy = GenerationType.SEQUENCE, generator = "student_sequence" ) private Long id; private String name; private String email; private LocalDate dob; private Integer age; public Student() { } public Student(Long id, String name, String email, LocalDate dob, Integer age) { this.id = id; this.name = name; this.email = email; this.dob = dob; this.age = age; } public Student(String name, String email, LocalDate dob, Integer age) { this.name = name; this.email = email; this.dob = dob; this.age = age; } public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public LocalDate getDob() { return dob; } public void setDob(LocalDate dob) { this.dob = dob; } public Integer getAge() { return age; } public void setAge(Integer age) { this.age = age; } @Override public String toString() { return "Student{" + "id=" + id + ", name='" + name + '\'' + ", email='" + email + '\'' + ", dob=" + dob + ", age=" + age + '}'; } }
主应用类(SpringbootApplication.java)
package com.example.springboot; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication public class SpringbootApplication { public static void main(String[] args) { SpringApplication.run(SpringbootApplication.class, args); } }
控制器(StudentController.java)
package com.example.springboot.student; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; @RestController @RequestMapping(path = "api/v1/student") public class StudentController { private final StudentService studentService; @Autowired public StudentController(StudentService studentService) { this.studentService = studentService; } @GetMapping public List<Student> getStudents() { return studentService.getStudents(); } }
服务类(StudentService.java)
package com.example.springboot.student; import org.springframework.stereotype.Service; import java.time.LocalDate; import java.time.Month; import java.util.List; @Service public class StudentService { public List<Student> getStudents() { return List.of( new Student( 1L, "Mariam", "mariam.jamal@gmail.com", LocalDate.of(2000, Month.JANUARY, 5), 21) ); } }
配置文件(application.properties)
spring.datasource.url=jdbc:postgresql://localhost:5432/student spring.datasource.username=postgres spring.datasource.password=admin spring.jpa.hibernate.ddl-auto=create spring.jpa.show-sql=true spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect spring.jpa.properties.hibernate.format_sql=true
依赖配置(pom.xml)
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.7.9</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.example</groupId> <artifactId>springboot</artifactId> <version>0.0.1-SNAPSHOT</version> <name>springboot</name> <description>Demo project for Spring Boot</description> <properties> <java.version>11</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jdbc</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>javax.persistence</groupId> <artifactId>javax.persistence-api</artifactId> <version>2.2</version> <scope>provided</scope> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> <repositories> <repository> <id>clojars</id> <name>Clojars</name> <url>https://repo.clojars.org/</url> </repository> </repositories> </project>
控制台启动日志
. ____ _ __ _ _ /\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.7.9) 2023-03-09 06:30:19.292 INFO 14164 --- [ main] c.e.springboot.SpringbootApplication : Starting SpringbootApplication using Java 11.0.17 on DESKTOP-RL97UQV with PID 14164 (D:\springboot\target\classes started by byoun in D:\springboot) 2023-03-09 06:30:19.294 INFO 14164 --- [ main] c.e.springboot.SpringbootApplication : No active profile set, falling back to 1 default profile: "default" 2023-03-09 06:30:19.673 INFO 14164 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JDBC repositories in DEFAULT mode. 2023-03-09 06:30:19.679 INFO 14164 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 3 ms. Found 0 JDBC repository interfaces. 2023-03-09 06:30:19.962 INFO 14164 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2023-03-09 06:30:19.968 INFO 14164 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2023-03-09 06:30:19.968 INFO 14164 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.71] 2023-03-09 06:30:20.047 INFO 14164 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2023-03-09 06:30:20.048 INFO 14164 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 717 ms 2023-03-09 06:30:20.318 INFO 14164 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2023-03-09 06:30:20.428 INFO 14164 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2023-03-09 06:30:20.514 INFO 14164 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path '' 2023-03-09 06:30:20.524 INFO 14164 --- [ main] c.e.springboot.SpringbootApplication : Started SpringbootApplication in 1.507 seconds (JVM running for 2.216)
已做排查步骤
- 将
spring.jpa.hibernate.ddl-auto配置从create-drop改为create - 确认IDE已成功连接目标PostgreSQL数据库
- 修改过项目的groupId和artifactId
- 查阅相关方案后确认现有配置已覆盖推荐内容
- 在
application.properties中添加logging.level.org.hibernate.SQL=DEBUG,但未输出任何Hibernate相关日志
问题原因及解决方案
核心原因
项目依赖中引入的是spring-boot-starter-data-jdbc,而非spring-boot-starter-data-jpa。JDBC starter仅提供基础JDBC操作支持,不会启用Hibernate的JPA自动配置,导致Hibernate未参与应用启动流程,自然不会执行表创建逻辑。
修复步骤
- 修改
pom.xml,移除spring-boot-starter-data-jdbc依赖,添加spring-boot-starter-data-jpa:
<!-- 移除JDBC starter --> <!-- <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jdbc</artifactId> </dependency> --> <!-- 添加JPA starter --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency>
- 移除
javax.persistence-api依赖,spring-boot-starter-data-jpa已包含JPA API,无需单独引入:
<!-- 删除该依赖 --> <!-- <dependency> <groupId>javax.persistence</groupId> <artifactId>javax.persistence-api</artifactId> <version>2.2</version> <scope>provided</scope> </dependency> -->
- 重新启动应用,Hibernate会根据实体类自动在PostgreSQL中创建对应表,控制台也会输出Hibernate的SQL日志。
内容的提问来源于stack exchange,提问作者Ben
相关产品推荐
相关产品推荐

