Actually I am using WebSphere5.1.2 and CloudScape V5.1. And I am using dialect as below
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>

And my CMODOne.hbm.xml looks like this

<hibernate-mapping>
<class name="com.hibernate.CMODModuleOne" table="CMODMODULEONE">
<id name="CMODOneID" column="CMODONEID">
<generator class="org.hibernate.id.TableHiLoGenerator">
<param name="table">MODULEMASTERS</param>
<param name="column">LASTTRANSCATIONNO</param>
</generator>
</id>
<property name="description"/>
</class>
</hibernate-mapping>

Step1:When I try to insert a row in the CMODMODULEONE table, the LASTTRANSCATIONNO coloumn of MODULEMASTERS table was getting updated once(as "1"). And the CMODONEID column of CMODMODULEONE was showing "1". ( This is executing perfectly. Problem comes in the next step)

Then When I try to add inserting two row after the above step 1 in the CMODMODULEONE table, the LASTTRANSCATIONNO coloumn of MODULEMASTERS table was getting updated once(changed to "2") and another entry with "0" has been inserted. And the CMODONEID column of CMODMODULEONE was showing "1", "32768","32769".

It should update as "3" in the LASTTRANSCATION column of MODULEMASTERS table and the CMODONEID column of CMODMODULEONE would show "1", "2","3". Instead of this it was showing incorrectly.

Can anyone help me regarding this..

Any solution is highly appreciated.

Thanks,
A.C.Vinith Kumar