我使用的是 Spring Boot 版本 2.5.2 、spring data jpa 和 MySQL Database
CREATE TABLE Timesheet (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`tsYear` VARCHAR(4) NOT NULL,
`weekNumber` INT NOT NULL,
`startDate` DATE NOT NULL,
`endDate` DATE NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE TimesheetDays (
`id` INT NOT NULL AUTO_INCREMENT,
`timesheetId` BIGINT(20) NOT NULL,
`dayNumber` INT NOT NULL,
`dayDate` DATE NOT NULL,
PRIMARY KEY (`id`),
CONSTRAINT `tsdTimesheetId`
FOREIGN KEY (`timesheetId`)
REFERENCES Timesheet (`id`)
);
@Entity
@Table(name = "timesheet")
public class Timesheet {
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@OneToMany(cascade = {CascadeType.PERSIST, CascadeType.MERGE }, mappedBy = "timesheet")
private List<TimesheetDay> days = null;
}
@Entity
@Table(name = "timesheetdays")
public class TimesheetDay {
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@ManyToOne
private Timesheet timesheet;
}
當我嘗試保存（timesheet 和 timesheetdays）時，對于 timesheetdays 表，hibernate 生成了錯誤的列。
[2m2021-11-05 18:29:44.147[0;39m [32mDEBUG[0;39m [35m15036[0;39m [2m---[0;39m][2m[nio-8080-exec-2][0; 39m [36morg.hibernate.SQL [0;39m [2m:[0;39m insert into timesheetdays (daydate, daynumber, timesheet_id) 值 (?, ?, ?) [2m2021-11-05 18:29:44.147[0;39m [32mTRACE[0;39m [35m15036[0;39m [2m---[0;39m][2m[nio-8080-exec-2][0; 39m [36mo.h.type.descriptor.sql.BasicBinder [0;39m [2m:[0;39m] 系結引數 [1] as [DATE] - [2017-12-20] [2m2021-11-05 18:29 :44.148[0;39m [32mTRACE[0;39m [35m15036[0;39m [2m---[0;39m][2m[nio-8080-exec-2][0;39m [36mo.h.type.descriptor] .sql.BasicBinder [0;39m [2m:[0;39m] 系結引數 [2] 作為 [INTEGER] - [1] [2m2021-11-05 18:29:44.148[0;39m [32mTRACE[0;39m [] 35m15036[0;39m [2m---[0;39m [2m[nio-8080-exec-2][0;39m [36mo.h.type.descriptor.sql.BasicBinder [0;39m [2m:[0]] ;39m 系結引數 [3] 為 [INTEGER] - [18] [2m2021-11-05 18:29:44.148[0;39m [33m WARN[0;39m [35m15036[0;39m [2m---[0]] ;39m [2m[nio-8080-exec-2][0;39m [36mo.h.engine.jdbc.spi.SqlExceptionHelper [0;39m [2m:[0;39m SQL 錯誤：1054，SQLState：42S22 [2m2021] -11-05 18:29:44。148[0;39m [31mERROR[0;39m [35m15036[0;39m [2m---[0;39m [2m[nio-8080-exec-2]][0;39m [36mo.h.engine.jdbc. spi.SqlExceptionHelper [0;39m [2m:[0;39m] 'field list' 中的未知列 'timesheet_id'
由于生成的列名是timesheet_id，它不起作用。如果生成的列名變成timesheetid，它就會起作用。
請幫助解決這個問題
uj5u.com熱心網友回復：
您需要添加@JoinColumn注釋以在TimesheetDay物體中專門提供列名稱值。
@ManyToOne
@JoinColumn(name="timesheetid")
private Timesheet timesheet;
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/350024.html
上一篇：為什么實作Hibernate@OneToMany關系會出現此錯誤？“物體映射中的重復列：XXX.Address列：id”