hibernate/hibernate-orm · error · HibernateException

Cannot retrieve the generated identity, because 'hibernate.j

Error message

Cannot retrieve the generated identity, because 'hibernate.jdbc.use_get_generated_keys' was disabled and the dialect does not support selecting the last generated identity

What it means

Error "Cannot retrieve the generated identity, because 'hibernate.jdbc.use_get_generated_keys' was disabled and the dialect does not support selecting the last generated identity" thrown in hibernate/hibernate-orm.

Source

Thrown at hibernate-core/src/main/java/org/hibernate/id/insert/BasicSelectingDelegate.java:41

	public BasicSelectingDelegate(EntityPersister persister) {
		super( persister, EventType.INSERT, false, false );
		this.persister = persister;
	}

	@Override
	public TableMutationBuilder<?> createTableMutationBuilder(
			Expectation expectation,
			SessionFactoryImplementor factory) {
		return new TableInsertBuilderStandard( persister, persister.getIdentifierTableMapping(), factory );
	}

	@Override
	protected String getSelectSQL() {
		final String identitySelectString = persister.getIdentitySelectString();
		if ( identitySelectString == null
				&& !dialect().getIdentityColumnSupport().supportsInsertSelectIdentity() ) {
			throw new HibernateException( "Cannot retrieve the generated identity, because '"
					+ USE_GET_GENERATED_KEYS
					+ "' was disabled and the dialect does not support selecting the last generated identity" );
		}
		return identitySelectString;
	}
}

View on GitHub (pinned to fad1729dce)

Solutions

1. Enable hibernate.jdbc.use_get_generated_keys, or use a dialect/database that supports selecting the last generated identity.
2. Switch to sequence-based id generation if the database supports it.

When it happens

Trigger: Thrown when the database did not return the expected generated key/identity value after an insert.

Common situations: Typical situations: JDBC driver not returning generated keys; use_get_generated_keys disabled with a dialect lacking identity selection; triggers interfering with key retrieval.

AI-assisted analysis of hibernate/hibernate-orm@fad1729dce (2026-08-22). Data as JSON: /api/errors/a6fdbfdd11315d5b. Report an issue: GitHub.