Hi,

I am very much new to Hibernate.

I found a very strange error in my application.

I am trying to save data in a Oracle table.

When I do this stand alone (1 single user), everything works fine.

When multiple users try to save data in the same tbale almost at the same time, like the QA guys trying to test the save functionality, it fails and throws errors.

Can anyone let me know what could be the reason for this. Is there anything to be done at hibernate end.

Thanks

Kindly paste the exception and hibernate configeration

Regards
Gokul

Hi,

I have a table with primary key as integer and auto generated
When I try to save into this table, by using getHibernateTenplate.save.... method,

the errro thrown is

One or more records you are trying to insert or update is already present in the database table.

This is kind of wierd becasue the primary key is auto generated and I am passing a null value while saving it. I have also tried to send -1 instead of null.

Still no luck.

Thanks
Jasmina

dont pass the value primary key coz it will b autogenerated by hibernate as below:

<class name="com.iflex.fcr.dataSelect.Account" table="TEST">
<id name="id" column="ID" type="integer">
<generator class="native" />
</id> <!-- will generate primary key id automatically -->
<property name="name" column="NAME" type="string" />
</class>

so u jst passthe other fields and try to save it.

hope it will work,
waiting for ur reply whether it works or not

Regards,
dont forget to give rate

I meant to say that I tried to fill the value of id as null in the value object.

The id field has to be there in the object else how will I map it to the database table.

So while saving, when I fill in the object (value object), I do not provide any value to the id. Hence the id in the Value Object goes null while saving.

Thanks
Jasmina

for example :

class Account
{
getter setter methods including id
}

Account a;
a.setId() /* no need to set id, hibernate will automatically decide n wil insert it */
a.setName("ABC");
session.save(a);

so ID (primary kye) is not in picutre at all while saving the records,coz it is automatically done by hibernate by:

<id name="id" column="ID" type="integer">
<generator class="native" />
</id>
which will b in ur hbm file.

hope u understant or want more clearance...

Regards

What generator-class are you using to generate the id? Posting your mapping-file would help us very musch because we wouldn't have to guess at your configuration.
My guess is that you're using generator="increment" which works fine in a singletreaded environment but will surely fail when running a multithreaded application (because increment isn't threadsafe). You'll have to use something like hilo, native, sequence,.... instead.