How to override sequence generator with explicit value?

I use sequence generator

<id name="id" column="person_id">
<generator class="sequence">
<param name="sequence">person_id_sequence</param>
</generator>
</id>

In rare cases I need to set the id value explicitly. If I set the id then during save() hibernate thinks that object is already in db and falls over on trying to update row rather than insert.

What's the easiest way to override the id?

I guess I can just use assigned generator, then if I need to save new object I have to ask a sequence for next value and set it on object straight in my code. But that's not really clean and I have to always remember to grab the next sequence value and set it on object before saving...

Are there any other solutions? Do I have to write new generator?

Hi

I too am looking for a solution. Have you possibly found one in the mean while?

Martyn

Take a look at the reference manual chapter

10.9 Replicating object between two different datastores

You might be able to use the same approach for your needs ...

Anyway you would have to make sure that your "manual" generated
ID value and the "automatic" assigned ID's have distinct ranges.

Erwin

we had same problem in the past where we were dealing with two different database.


Try to add (or choose one from existing columns) version column to that table.