Discriminator value used as ID when inserting entity to PosgtreSQL ------------------------------------------------------------------ Key: HHH-6580 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6580 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.0, 3.6.1, 3.6.2, 3.6.3, 3.6.4, 3.6.5, 3.6.6 Environment: Tested on Hibernate 3.6.0, but I looked in the code of 3.6.6 and 4.0.0 Beta4 and it looks like it isn't fixed. PostgreSQL 8.4.8 Reporter: Paweł Stawicki Labels: generated Attachments: amorfis-Hibernate-postgreSQL-bug-3ef4fb0.zip When we have inheritance strategy SINGLE_TABLE, and we use discriminator column, this column is the first one in table. Now we want to insert some entity inheriting from this one, and we want PostgreSQL to automatically generate the ID for the new entity. Discriminator column is the first in the table. Hibernate runs IdentityGenerator.GetGeneratedKeysDelegate.executeAndExtract(), which gets ResultSet from PreparedStatement (in Hibernate 3.6.0 it's line 97 in IdentityGenerator). This ResultSet, in case of PostgreSQL, contains whole inserted row, not only ID. This is the problem if ID is not the first column, because then Hibernate get's value from the first column and uses it as ID. It's in IdentifierGeneratorHelper.getGeneratedIdentity() and IdentifierGeneratorHelper.get().

Discriminator value used as ID when inserting entity to PosgtreSQL ------------------------------------------------------------------ Key: HHH-6580 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6580 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.0 Environment: Tested on Hibernate 3.6.0, but I looked in the code of 3.6.6 and 4.0.0 Beta4 and it looks like it isn't fixed. PostgreSQL 8.4.8 Reporter: Paweł Stawicki Labels: generated Fix For: 4.0.1 Attachments: amorfis-Hibernate-postgreSQL-bug-3ef4fb0.zip When we have inheritance strategy SINGLE_TABLE, and we use discriminator column, this column is the first one in table. Now we want to insert some entity inheriting from this one, and we want PostgreSQL to automatically generate the ID for the new entity. Discriminator column is the first in the table. Hibernate runs IdentityGenerator.GetGeneratedKeysDelegate.executeAndExtract(), which gets ResultSet from PreparedStatement (in Hibernate 3.6.0 it's line 97 in IdentityGenerator). This ResultSet, in case of PostgreSQL, contains whole inserted row, not only ID. This is the problem if ID is not the first column, because then Hibernate get's value from the first column and uses it as ID. It's in IdentifierGeneratorHelper.getGeneratedIdentity() and IdentifierGeneratorHelper.get().

Discriminator value used as ID when inserting entity to PosgtreSQL ------------------------------------------------------------------ Key: HHH-6580 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6580 Project: Hibernate ORM Issue Type: Bug Components: core Affects Versions: 3.6.0 Environment: Tested on Hibernate 3.6.0, but I looked in the code of 3.6.6 and 4.0.0 Beta4 and it looks like it isn't fixed. PostgreSQL 8.4.8 Reporter: Paweł Stawicki Assignee: Steve Ebersole Labels: generated Attachments: amorfis-Hibernate-postgreSQL-bug-3ef4fb0.zip When we have inheritance strategy SINGLE_TABLE, and we use discriminator column, this column is the first one in table. Now we want to insert some entity inheriting from this one, and we want PostgreSQL to automatically generate the ID for the new entity. Discriminator column is the first in the table. Hibernate runs IdentityGenerator.GetGeneratedKeysDelegate.executeAndExtract(), which gets ResultSet from PreparedStatement (in Hibernate 3.6.0 it's line 97 in IdentityGenerator). This ResultSet, in case of PostgreSQL, contains whole inserted row, not only ID. This is the problem if ID is not the first column, because then Hibernate get's value from the first column and uses it as ID. It's in IdentifierGeneratorHelper.getGeneratedIdentity() and IdentifierGeneratorHelper.get().

Discriminator value used as ID when inserting entity to PosgtreSQL ------------------------------------------------------------------ Key: HHH-6580 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6580 Project: Hibernate ORM Issue Type: Bug Components: core Affects Versions: 3.6.0 Environment: Tested on Hibernate 3.6.0, but I looked in the code of 3.6.6 and 4.0.0 Beta4 and it looks like it isn't fixed. PostgreSQL 8.4.8 Reporter: Paweł Stawicki Assignee: Steve Ebersole Labels: generated Fix For: 3.6.10, 4.1.0 Attachments: amorfis-Hibernate-postgreSQL-bug-3ef4fb0.zip Time Spent: 1h When we have inheritance strategy SINGLE_TABLE, and we use discriminator column, this column is the first one in table. Now we want to insert some entity inheriting from this one, and we want PostgreSQL to automatically generate the ID for the new entity. Discriminator column is the first in the table. Hibernate runs IdentityGenerator.GetGeneratedKeysDelegate.executeAndExtract(), which gets ResultSet from PreparedStatement (in Hibernate 3.6.0 it's line 97 in IdentityGenerator). This ResultSet, in case of PostgreSQL, contains whole inserted row, not only ID. This is the problem if ID is not the first column, because then Hibernate get's value from the first column and uses it as ID. It's in IdentifierGeneratorHelper.getGeneratedIdentity() and IdentifierGeneratorHelper.get().