有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

java数据。未加载带有spring boot JPA Postresql的sql

我已经编写了一个spring boot应用程序。我想用数据表设置初始数据库数据。sql文件

src/main/resources/application。属性

spring.jpa.hibernate.ddl-auto=create
spring.datasource.url=${JDBC_DATABASE_URL}
spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.initialization-mode=always
spring.jpa.show-sql=true

src/main/java/package_name/model/my_entity

@Entity
@Table(name = "user_entry")
public class User {
    @Id
    @Column(nullable = false, length = 50)
    private String userId;
    @Column(nullable = false, length = 50)
    private String firstName;
    @Column(nullable = false, length = 50)
    private String lastName;
    @Column(nullable = false, length = 50)
    private String password;
    @OneToMany(mappedBy = "owner", cascade = CascadeType.ALL, orphanRemoval = true)
    private Set<SongList> songLists;

    public User() {
    }
    ...
}

src/main/resources/data。sql

insert into user_entry (user_id, first_name, last_name, password) values
('MaMu', 'Maxime', 'Muster', 'pass1234');

但是,在部署期间,数据似乎没有加载到数据库中

编辑:

在我的src/main/resources/application中添加spring.datasource.data= classpath:/data.sql。物业公司解决了这个问题


共 (0) 个答案