hi all,

i think i have got a simple problem but i was not be able to find the trick. So, here my mapper :

<!-- BUTCE -->
<class name="tr.com.usta.ITBMuhasebeOrtak.core.dvo.muhasebe.Butce" table="U_BUTCE">
<id name="butcekod" column="BUTCEKOD">
</id>
<property name="hesapkod" column="HESAPKOD" length="30" not-null="false"/>
<property name="borc" column="BORC" type="double" not-null="true"/>
<property name="alacak" column="ALACAK" type="double" not-null="true"/>
<property name="dovizborc" type="double" column="DOVIZBORC" not-null="true"/>
<property name="dovizalacak" column="DOVIZALACAK" type="integer" not-null="true"/>
<property name="pbkod" column="PBKOD" length="5" not-null="false"/>
<property name="tarih" column="TARIH" type="date" not-null="false"/>
<property name="aciklama2" column="ACIKLAMA2" length="100" not-null="false"/>
<property name="aciklama" column="ACIKLAMA" length="100" not-null="false"/>
</class>

This table uses sequence to get id for 'BUTCEKOD'. After i call my select method to get data from table it gets data as i see from console Logging but after selection it tries to update also. Like that :

update
U_BUTCE
set
HESAPKOD=?,
BORC=?,
ALACAK=?,
DOVIZBORC=?,
DOVIZALACAK=?
PBKOD=?,
TARIH=?,
ACIKLAMA2=?,
ACIKLAMA=?
where
BUTCEKOD=?

Why hibernate needs to update the result list. Is it related with the table that takes its id from sequence?

Regards,

It could be bacause of datatype mismatch. I had this problem before. I had an attribute in Class A defined as 'short' but was reading it as Integer.

So hibernate was doing a dirty check and thought that the values have been changed after it was loaded and hence flushing it back to the database.

Hope this helps