[hibernate-issues] [Hibernate-JIRA] Created: (EJB-370) @GeneratedValue and id populated with function (MSSQL 2000)

@GeneratedValue and id populated with function (MSSQL 2000) ----------------------------------------------------------- Key: EJB-370 URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-370 Project: Hibernate Entity Manager Issue Type: Bug Components: EntityManager Affects Versions: 3.2.1 Environment: MSSQL 2000 server, ms sql 2000 jdbc driver, Hibernate EntityManager 3.2.1.GA, JBOSS 4.2.2 GA Reporter: Thierry Accart When a table has its primary key (int id_ populated in SQL with IDENTITY, everything is fine. Now, if you create a sql function getNextID() that returns the next Id for this table, remove the identity setup for this column, and set getNextId() as default value, the entity manager seems to not catch the new value of ID. in extenso : I created a new Entity its ID is 0 in java. I persisted it -> when sql column was setup to Identity, the entitymanager retrieved the new id from SQL -> when sql column was setup to be not null and have default value, the row was inserted in SQL (with the ID given by function call), but the entitymanager did not retrieve the new ID from SQL, keeping 0 as id value. Is it a normal behaviour, or should entityManager retrieve the new Id in any case ? -- 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