{"record":{"id":"138fe5f664cdc9c9","repo":"hibernate/hibernate-orm","slug":"the-database-returned-no-guid-identity-value","errorCode":null,"errorMessage":"The database returned no GUID identity value","messagePattern":"The database returned no GUID identity value","errorType":"exception","errorClass":"HibernateException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/id/GUIDGenerator.java","lineNumber":53,"sourceCode":"\t}\n\n\t@Override\n\tpublic Class<?> getGeneratedType() {\n\t\treturn String.class;\n\t}\n\n\t@Override\n\tpublic Object generate(SharedSessionContractImplementor session, Object obj) throws HibernateException {\n\t\tfinal String sql = session.getJdbcServices().getJdbcEnvironment().getDialect().getSelectGUIDString();\n\t\ttry {\n\t\t\tfinal var jdbcCoordinator = session.getJdbcCoordinator();\n\t\t\tfinal var statement = jdbcCoordinator.getStatementPreparer().prepareStatement( sql );\n\t\t\tfinal var resourceRegistry = jdbcCoordinator.getLogicalConnection().getResourceRegistry();\n\t\t\ttry {\n\t\t\t\tfinal var resultSet = jdbcCoordinator.getResultSetReturn().extract( statement, sql );\n\t\t\t\ttry {\n\t\t\t\t\tif ( !resultSet.next() ) {\n\t\t\t\t\t\tthrow new HibernateException( \"The database returned no GUID identity value\" );\n\t\t\t\t\t}\n\t\t\t\t\treturn resultSet.getString( 1 );\n\t\t\t\t}\n\t\t\t\tfinally {\n\t\t\t\t\tresourceRegistry.release( resultSet, statement );\n\t\t\t\t}\n\t\t\t}\n\t\t\tfinally {\n\t\t\t\tresourceRegistry.release( statement );\n\t\t\t\tjdbcCoordinator.afterStatementExecution();\n\t\t\t}\n\t\t}\n\t\tcatch (SQLException sqle) {\n\t\t\tthrow session.getJdbcServices().getSqlExceptionHelper().convert(\n\t\t\t\t\tsqle,\n\t\t\t\t\t\"could not retrieve GUID\",\n\t\t\t\t\tsql\n\t\t\t);","sourceCodeStart":35,"sourceCodeEnd":71,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/id/GUIDGenerator.java#L35-L71","documentation":"Error \"The database returned no GUID identity value\" thrown in hibernate/hibernate-orm.","triggerScenarios":"Thrown when the database did not return the expected generated key/identity value after an insert.","commonSituations":"Typical situations: JDBC driver not returning generated keys; use_get_generated_keys disabled with a dialect lacking identity selection; triggers interfering with key retrieval.","solutions":["Verify the database's GUID generation function (e.g. newid(), uuid()) works in the configured dialect.","Check the JDBC connection and dialect settings for GUID support."],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"fad1729dce015f908198d57a8d80274a30f905a5","analyzedAt":"2026-08-22T04:13:57.527Z","schemaVersion":2},"datasetVersion":"2026-08-22T09:17:25.309Z"}