This content has been marked as final.
Show 2 replies
-
1. Re: Auto incrementing primary key in MS SQL Server 7
earnest Feb 2, 2003 8:05 PM (in response to earnest)urgent help needed on this post...please help
-
2. Re: Auto incrementing primary key in MS SQL Server 7
sebastien_petrucci Feb 5, 2003 4:38 AM (in response to earnest)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)