Hi All,

I am facing a problem with auto_increment..

I have two application and both are using the same database..

when i save some value this auto_increment is getting the old value which is updated already.So in that time i am gettiong exception..

CREATE TABLE CLIENT (
CLIENTID int NOT NULL AUTO_INCREMENT,
SERIALNUMBER varchar(64) NOT NULL,
TIMESTAMP TIMESTAMP NOT NULL,
SERVER varchar(3) NOT NULL,
CONSTRAINT PK_ClientConnLog PRIMARY KEY
(
CLIENTID
)

);


<id name="clientId" type="int" column="CLIENTID" >
<generator class="increment"/>
</id>

i am doing commit properly after my save..


Pls let me know if something wrong in my table creation or problem in the xml file in the above..

thanks.

I guess, two applications causes this problems,
They probably cache the latest ids assigned.
you can use an extra table, to fix this problem.

the Hilo Generator automaticly does this, as given below:

Hi,

thanks for ur reply...
i can't add any table now..

is there anyother possibility to make it work with my current implementation?

i am doing session.flush()...i am not sure still how its taking the values from cache?

thanks.