我正在嘗試使用 MySQL 數據庫啟動 spring boot 項目,但是數據庫有一些問題。我嘗試啟動我的應用程序,并且服務器正在運行但休眠不創建表等。這是我的代碼:用戶實體 @Entity public class User { @Id @GeneratedValue(strategy = IDENTITY) private Long id; private String firstName; private String lastName; private String email; private String password; private String description; private String profile_photo; private LocalDate create; private LocalDate update; @OneToMany(mappedBy = "eventOwner") private List<Event> ownedEvents; public Long getId() { return id;}public void setId(Long id) { this.id = id;}public String getFirstName() { return firstName;}public void setFirstName(String firstName) { this.firstName = firstName;}public String getLastName() { return lastName;}public void setLastName(String lastName) { this.lastName = lastName;}public String getEmail() { return email;}public void setEmail(String email) { this.email = email;}public String getPassword() { return password;}public void setPassword(String password) { this.password = password;}public String getDescription() { return description;}public void setDescription(String description) { this.description = description;}public String getProfile_photo() { return profile_photo;}public void setProfile_photo(String profile_photo) { this.profile_photo = profile_photo;}public LocalDate getCreate() { return create;}public void setCreate(LocalDate create) { this.create = create;}public LocalDate getUpdate() { return update;}public void setUpdate(LocalDate update) { this.update = update;}public List<Event> getOwnedEvents() { return ownedEvents;}public void setOwnedEvents(List<Event> ownedEvents) { this.ownedEvents = ownedEvents;}}
3 回答

斯蒂芬大帝
TA貢獻1827條經驗 獲得超8個贊
將 spring.jpa.hibernate.ddl-auto = create-drop更改為update。它在啟動時刪除數據庫,因此不會找到所需的事件表來更改任何內容。

天涯盡頭無女友
TA貢獻1831條經驗 獲得超9個贊
在我的情況下,我得到這個異常的問題是,一些表的名稱是為 postgreSQL 保留的。例如?!跋矚g”或“用戶”。改名為:
@Table(name="likes")
它工作得很好。也許有人有同樣的問題。

紫衣仙女
TA貢獻1839條經驗 獲得超15個贊
這似乎是與保留的PostgreSQL 字有關的錯誤。與最佳答案(SupaMario's)類似,在將我的一個列名從
@Column(name = "name", nullable = false)
至
@Column(name = "employee_name", nullable = false)
添加回答
舉報
0/150
提交
取消