[jboss-user] [EJB 3.0] - [JDBCExceptionReporter]'last_insert_id' is not a recognized

2007-06-11 Thread shipra
Hi I have been trying to connect to a DB on sql server using EJB3.0. I'm able to retrieve the data from the tables but cannot insert. The tables are 'Address' and 'Person'. The Unique auto generated 'id' of 'Address' table has to be inserted in the 'AddressId' field of Person. Besides other field

[jboss-user] [EJB 3.0] - Re: [JDBCExceptionReporter]'last_insert_id' is not a recogni

2007-06-12 Thread shipra
Hi, Thanks. Actually the id was set as Identity column in the Tables also. I removed the @GeneratedValue from both the entities. But again I'm getting an error. 15:05:25,757 ERROR [JDBCExceptionReporter] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for identit