4 Replies Latest reply on Aug 7, 2002 2:02 PM by Dain Sundstrom

    identity data field

    stillshi Newbie

      i have created a table on ms-sqlserver 7.0 as follows:
      id(int,identity),name(varchar),age(varchar).
      then i try to create a record into this table via a ejb client(jboss2.2.2).but the exception throws:

      javax.ejb.CreateException: Could not create entity:java.sql.SQLException: Cannot insert explicit value for identity column in table 'testIdentity' when IDENTITY_INSERT is set to OFF. Severity 16, State 1, Procedure 'SVR-MISC null', Line 1
      ...
      what should i do then? how to insert a record with an identity field with jboss?

      thanks.