SqlException: Attempt to modify an identity column 'USER_ID'

[Royston Monteiro]

Hi Folks,
The following is my hibernate mapping file:

    
<hibernate-mapping>
  <class name="com.db.birt.data.UserD" table="XMABUT" lazy="false" >
    <id column="USER_ID" name="User_ID" >
        <generator class="identity" />
    </id>
    <property column="USER_NAME" name="User_Name" type="string"/>
    <property column="USER_MAIL" name="User_Mail" type="string"/>
  </class>
</hibernate-mapping>

The following is my Data Class:

   
public class UserD {

    private int User_ID;
    private String User_Name;
    private String User_Mail;

    public int getUser_ID() {
        return User_ID;
    }

    public void setUser_ID(int User_ID) {
        this.User_ID = User_ID;
    }    

    public UserD() {
    }    

    public UserD(String User_Name, String User_Mail) {

        this.User_Name = User_Name;
        this.User_Mail = User_Mail;
    }            

    public String getUser_Mail() {
        return User_Mail;
    }

    public void setUser_Mail(String User_Mail) {
        this.User_Mail = User_Mail;
    }

    public String getUser_Name() {
        return User_Name;
    }

    public void setUser_Name(String User_Name) {
        this.User_Name = User_Name;
    }
}

When I say:

getHibernateTemplate().saveOrUpdate(new UserD('royston', 'roystonthegeek');

I get the exception :

org.apache.derby.client.am.SqlException: Attempt to modify an identity column 'USER_ID'

Any idea why? I am using derby database.
The hibernate documentation says this about identity of the generator:

identity : Supports identify columns in DB2, MySQL, MS SQL Server, Sybase and HypersonicSQL. The returned identifier is of type long, short or int.

Any help would be much appreciated.

Thanks in advance

[Cameron Wallace McKenzie]

Looks like you're trying to update the identifier column on an entity. You can't do that.

Please try your best to use descriptive subject lines. Almost every other post these days is about Hibernate.

Thanks.

-Cameron McKenzie

[Royston Monteiro]

Thanks Cameron.
My question is this:
Shouldn't we declare and map all the fields in the backing object(identity and non-identity fields)?
I have declared all the fields in the object that is mapped to the table:

    
USER_ID //the identiy column
USER_NAME, USER_MAIL //the non identity columns

When I try to add a new row to the database, I create a new instance of this class by setting the USER_NAME and USER_MAIL fields to Strings. The field mapped to the identity column gets its default values of 0. Finally, I attempt to add this new row by calling hibernateTemplate.save(object).

Is this the right way to do it?

Please help.

[Royston Monteiro]

Hi Folks,
Any advise?

[Harpreet Singh janda]

Have you tried to save the object using session.save() method?

[Royston Monteiro]

Harpreet Singh janda wrote:Have you tried to save the object using session.save() method?

I havent tried session.save

I am using spring with hibernate.

These are the logged errors:

Hibernate: insert into DB.XMABUT (USER_ID, USER_NAME, USER_MAIL) values (null, ?, ?)
[05-May-2010:07:17:33] [http-8080-Processor21] [WARN ][   ][  ]
logExceptions() ==> SQL Error: -798, SQLState: 428C9

[05-May-2010:07:17:33] [http-8080-Processor21] [ERROR][   ][  ]
logExceptions() ==> DB2 SQL error: SQLCODE: -798, SQLSTATE: 428C9, SQLERRMC: GRUPPE_ID

[05-May-2010:07:17:33] [http-8080-Processor21] [WARN ][   ][  ]
logExceptions() ==> SQL Error: -516, SQLState: 26501

[05-May-2010:07:17:33] [http-8080-Processor21] [ERROR][   ][  ]
logExceptions() ==> DB2 SQL error: SQLCODE: -516, SQLSTATE: 26501, SQLERRMC: null

[05-May-2010:07:17:33] [http-8080-Processor21] [WARN ][   ][  ]
logExceptions() ==> SQL Error: -518, SQLState: 07003

[Royston Monteiro]

Any more help?