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) 个答案