Spring Boot项目无法自动创建数据库表问题求助

核心问题分析 #

日志显示Found 0 JPA repository interfaces，说明Spring未扫描到JPA仓库接口；同时实体类注解错误、配置缺失、依赖冲突也会直接导致自动建表失败。

具体解决方案 #

1. 修复JPA仓库扫描问题 #

你的ProductRepository接口未添加@Repository注解，显式添加该注解可确保Spring正确识别并扫描仓库：

package com.myproject.ecommerce.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
import com.myproject.ecommerce.entity.Product;

@Repository
public interface ProductRepository extends JpaRepository<Product,Long> {
    
}

若仓库仍未被扫描，可在主启动类中指定扫描路径：

package com.myproject.ecommerce;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.boot.autoconfigure.domain.EntityScan;

@SpringBootApplication
@EnableJpaRepositories(basePackages = "com.myproject.ecommerce.repository")
@EntityScan(basePackages = "com.myproject.ecommerce.entity")
public class ECommerceApplication {
    public static void main(String[] args) {
        SpringApplication.run(ECommerceApplication.class, args);
    }
}

2. 修正实体类注解错误 #

@NotBlank注解仅适用于字符串类型，你在long类型字段（id、price、seller_id）上使用该注解会触发校验异常，影响JPA映射：

package com.myproject.ecommerce.entity;

import java.util.Set;

import com.fasterxml.jackson.annotation.JsonIgnore;
import jakarta.persistence.CascadeType;
import jakarta.persistence.Column;
import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
import jakarta.persistence.ManyToMany;
import jakarta.persistence.Table;
import jakarta.validation.constraints.Min;
import jakarta.validation.constraints.NotBlank;
import jakarta.validation.constraints.NotNull;
import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

@AllArgsConstructor
@NoArgsConstructor
@Setter
@Getter
@Entity
@Table(name = "product")
public class Product {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "product_id", nullable = false)
    @NotNull
    long id;

    @NotBlank(message = "Product name cannot be blank!!")
    @Column(name = "product_name", nullable = false)
    String name;

    @Min(value = 0, message = "Product price cannot be negative!!")
    @Column(name = "product_price", nullable = false)
    @NotNull
    long price;

    @NotBlank(message = "Product description cannot be blank!!")
    @Column(name = "product_description", nullable = false)
    String description;

    @Column(name = "product_seller_id", nullable = false)
    @NotNull
    long seller_id;

    @JsonIgnore
    @ManyToMany(cascade = CascadeType.ALL,mappedBy = "products")
    Set<Category> categories;
}

3. 添加JPA自动建表配置 #

在application.properties中添加以下配置，开启自动建表并显示格式化的SQL语句：

# 根据需求选择create/create-drop/update/validate
spring.jpa.hibernate.ddl-auto=update
# 显示Hibernate执行的SQL
spring.jpa.show-sql=true
# 格式化SQL输出
spring.jpa.properties.hibernate.format_sql=true

4. 清理冗余数据库驱动依赖 #

pom.xml同时引入MySQL、Oracle、PostgreSQL三个驱动会引发依赖冲突，仅保留当前使用的数据库驱动即可，例如保留MySQL驱动：

<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <scope>runtime</scope>
</dependency>

内容的提问来源于stack exchange，提问作者Zhakav Hesari