0 Replies Latest reply on Jan 23, 2003 3:50 PM by Fendy

    MS SQL Server IDENTITY column

    Fendy Newbie


      Please help. I am trying to get JBoss 3.0.4 EJB to work with MS SQL Server 7.0. I was able to retrieve and update the existing data. However, when I tried to insert a new row. I got the this exception:
      javax.ejb.CreateException: Could not create entity:java.sql.SQLException: Cannot insert explicit value for identity column in table 'TAddress' when IDENTITY_INSERT is set to OFF

      I searched the web, and found there is a <pk-identity> tag in JBoss 2.4 to solve the problem. Does anyone know a solution in JBoss 3.0?

      Thank you.