urgent help needed on this post...please help
Either switch to JBOSS 3.2RC1 or change your CMP into BMP...
- By using BMP, you can retrieve yourself your generated pk, in your DB specific manner. (something like "select @@last-id()" - check SQL Server doc)
- With JBOSS 3.2 RC1, you can use generated pk but only with unknown-pk (which may cause a problem in some circomstances). Basically for MS SQL Server, it should work if you have a JDBC 3.0 driver, or maybe by using the 'pk-sql' entity command (checks posts about unknown-pk for JBOSS3.2) and correct SQL (something like "select @@last-id()" - check SQL Server doc)