hibernate - 新记录没有得到生成的 id
问题描述
我创建了一个在启动时通过 FlywayDB 迁移的新表:
CREATE TABLE IF NOT EXISTS place_address (
id bigint,
place_id bigint NOT NULL,
street character varying(255) NOT NULL,
postal_code character varying(255) NOT NULL,
city character varying(255) NOT NULL,
country character varying(255) NOT NULL,
address_type character varying(255) NOT NULL,
FOREIGN KEY (place_id) REFERENCES place(id),
CONSTRAINT place_address_pkey PRIMARY KEY (id)
);
我正在创建这样一个实体并将其存储为JpaRepository
:
PlaceAddressEntity placeAddressEntity = new PlaceAddressEntity();
placeAddressEntity.setPlace(placeEntity);
placeAddressEntity.setStreet(establishmentDto.getAddress().getStreet());
placeAddressEntity.setCity(establishmentDto.getAddress().getCity());
placeAddressEntity.setCountry(establishmentDto.getAddress().getCountry());
placeAddressEntity.setPostalCode(establishmentDto.getAddress().getPostalCode());
placeAddressEntity.setAddressType(AddressType.GEOGRAPHIC);
this.placeAddessRepository.save(placeAddressEntity);
但是,这就是我得到的:
2018-09-21 18:42:05.319 WARN 13842 --- [io-8443-exec-10] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 23502
2018-09-21 18:42:05.319 ERROR 13842 --- [io-8443-exec-10] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: null value in column "id" violates not-null constraint
Detail: Failing row contains (null, 8, Western Road 2-20, NW10 7LW, Greater London, United Kingdom, GEOGRAPHIC).
2018-09-21 18:42:05.322 INFO 13842 --- [io-8443-exec-10] m.a.s.e.CustomRestExceptionHandler : org.springframework.dao.DataIntegrityViolationException
2018-09-21 18:42:05.323 INFO 13842 --- [io-8443-exec-10] m.a.s.e.CustomRestExceptionHandler : org.hibernate.exception.ConstraintViolationException
实体定义为:
@Entity
@Table(name = "place_address")
public class PlaceAddressEntity {
public enum AddressType {
GEOGRAPHIC,
BILLING
}
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@ManyToOne
@JoinColumn(name = "place_id", nullable = false)
private PlaceEntity place;
@Column
private String street;
@Column(name = "postal_code")
private String postalCode;
@Column
private String city;
@Column
private String country;
@Column(name = "address_type")
@Enumerated(EnumType.STRING)
private AddressType addressType;
}
我不知道问题是什么 - 知道我错过了什么吗?
这里也是PlaceAddressRepository
:
public interface PlaceAddessRepository extends JpaRepository<PlaceAddressEntity, Long> {
}
解决方案
这是因为您没有使用自动增量功能
使用id SERIAL PRIMARY KEY
,必须在表定义中设置。
推荐阅读
- c# - EF Core 3.0 替换 IMutableIndex.Npgsql() 方法
- python - 如何抓取仅在登录时显示的课程?
- fullcalendar - fullcalendar nextDayThreshold 不起作用。'00:00:00' 显示的时间少了一天
- reactjs - React 挂钩如何从子 Form.Control 设置对 InputGroup 的关注
- python - 有没有办法在不安装其他任何东西的情况下从音频文件中删除/编辑名为“标签”的元数据条目?
- python - 如何在执行任何语句之前调用连接方法
- google-cloud-platform - Google 部署管理器 - 数据库创建失败
- powershell - 具有多个值的 Switch-Case
- apache - 无法使用本地主机端口 80;启动用户级代理时出错:绑定 0.0.0.0:80:意外错误(EADDRINUSE 失败)
- python-3.x - 在 groupby 之后对同一列应用多个操作