postgresql - Jhipster休眠序列不生成新ID
问题描述
Jhipster 休眠序列未从序列池返回 id
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint "pk_video_catalog" Detail: Key (id)=(2) already
exists. at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutor
Impl.java:2440) at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatemen
t.java:143) at
org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120) at
com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPre
具有序列生成器的实体
public class VideoCatalog extends AbstractAuditingEntity implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "sequenceGenerator")
@SequenceGenerator(name = "sequenceGenerator")
private Long id;
数据库有hibernate_sequence
作为序列
解决方案
推荐阅读
- python-3.x - Python aiohttp.ClientPayloadError 与 Artifactory API
- java - 孙子 instanceof Parent 返回 false
- windows - Can I use WinUSB alongside the built-in HID drivers?
- python - 如何打印第 1 名、第 2 名等直到第 5 名?
- apache - htaccess 不会正确重定向
- deployment - 用于 Nuxt 部署的 Netlify npm run build 失败
- c# - 以编程方式添加列键 id linq
- javascript - 我如何在 HTML5 画布上使用图像而之前页面上没有图像?
- javascript - 在 ReactJS 中将一对随机选择的对象(具有不匹配的某些属性)渲染为扑克牌
- postgresql - Postgres:了解主键序列