[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1915) DerbyDialect javadoc

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1915?page=c... ] Steve Ebersole commented on HHH-1915: ------------------------------------- Because our test suite shows problems running against Derby using IDENTITY columns. It almost as if in certain circumstances the just inserted IDENTITY value is not available when performing a later FK check in the same transaction. For example, in the same connection/transaction, the following paradigm fails often: insert into Employee (id) values (default) {generatedEmployeeId} = values identity_val_local() insert into Employer (id) values (default) {generatedEmployerId} = values identity_val_local() insert into EMPLOYER_EMPLOYEE (EMPER_ID, EMPEE_ID) values ( {generatedEmployerId}, {generatedEmployeeId} ) this last insert fails with an FK constraint violation. This happens whether we make the "values identity_val_local()" call seperately or whether we use getGeneratedKeys(). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira