Attempt to modify an identity column

[manu chaox]

Hi,
I generated classes from database via Hibernate.

Database ddl:

  
Create table aaa (
      id BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY,  
...
 
      Constraint PK_Aaa Primary Key (id)
);
  

Aaa.hbm.xml:

  
<hibernate-mapping>
    <class name="hib.Aaa" table="AAA" >
        <id name="id" type="java.lang.Long">
            <column name="ID" />
            <generator class="increment" />
        </id>
 
...
  

Bussiness logic:
Reading a Aaa from database is ok.
But save a Aaa into database

  
        Long id = new Long(2L);
        Aaa aaa= new Aaa();
//        aaa.setId(id);
...
persistenceLayer.addAaa(aaa);
 
  

throw following exception:

  
Exception in thread "main" org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [hib.Aaa]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [hib.Aaa]
org.hibernate.exception.SQLGrammarException: could not insert: [hib.Aaa]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
...
 
Caused by: java.sql.SQLSyntaxErrorException: Attempt to modify an identity column 'ID'. 
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
...
 
 
Caused by: java.sql.SQLException: Attempt to modify an identity column 'ID'. 
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
...
 
 
Caused by: ERROR 42Z23: Attempt to modify an identity column 'ID'. 
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
...
  

Could you help me please.
[ August 24, 2008: Message edited by: manu chaox ]

[Adeel Ansari]

I believe, you instruct hibernate to generate the id for you, then why are you trying to pass the value for it.

That might be the reason. I assume, you are worried about knowing the value hibernate is gonna generate for you. If thats the case, your save method would return the generated key for you to use further.

Cheers.

[manu chaox]

These exceptions throw with commented setId:

//        aaa.setId(id); i.e. I don't set id of Aaa then I don't pass id for Hibernate.
aaa.setName("Joe");
...

[ August 25, 2008: Message edited by: manu chaox ]

[Adeel Ansari]

Try

<id name="id" column="ID">
   <generator class="increment"/>
</id>

instead of,

<id name="id" type="java.lang.Long">
   <column name="ID" />
   <generator class="increment" />
</id>

[Adeel Ansari]

Originally posted by manu chaox:
These exceptions throw with commented setId:

There is no exception shown in your post.

[manu chaox]

<id name="id" column="ID">
   <generator class="increment"/>
</id>

is the same problem(same exception.)

quote : o riginally posted by manu chaox:
These exceptions throw with commented setId:



There is no exception shown in your post.

Sorry, I thought previous exception(see above).
[ August 25, 2008: Message edited by: manu chaox ]

[Adeel Ansari]

Are you using session.save()?

[Ramesh Srinivasan]

Originally posted by manu chaox:

<id name="id" column="ID">
   <generator class="increment"/>
</id>

is the same problem(same exception.)




Sorry, I thought previous exception(see above).

[ August 25, 2008: Message edited by: manu chaox ]

I believe bad SQL passed for your RDBMS. Check your datasource in your hibernate and configuration. Also check if you are using any db scripts.

[Adeel Ansari]

You can try this, to print the actual SQL on the console.

        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">your.dialect.class</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.format_sql">true</prop>
            </props>
        </property>
 

[Raghu Dg]

<id name="id" column="ID">
<generator class="identity"/>
</id>