[JBoss-user] [EJB/JBoss] - Re: My simple solution to CMP and MS SQL identity

2006-02-25 Thread rdelaplante
Update: I found out how to return the new ID that was created by MS SQL. Simply replace: return null; with: return this.getCheckInHistoryID(); View the original post : http://staging.jboss.com/index.html?module=bb&op=viewtopic&p=3890787#3890787 Reply to the post : http://staging.jboss.com

[JBoss-user] [EJB/JBoss] - My simple solution to CMP and MS SQL identity

2006-02-25 Thread rdelaplante
I've spent many many hours fighting to be able to insert a record into an MSSQL Server 2000 table that has an auto-incrementing "identity" pk field. There were many solutions offered on the net such as creating a separate entity to keep track of PK's, and other stuff I can't remember. Some of