Hibernate version: 3.2

I am generating the id with a trigger in the DB, that is itself calling a sequence. But I cannot retrieve the generated id for future use in the application.

Something like this:

myObjectToPersist = new ObjectToPersist();
myObjectToPersist.setId(Long.valueOf("-1"));
...

Then, when I want to persist just call:
saveOrUpdate(myObjectToPersist)

After this is executed, on the DB itself the new row is added with the generated id by the trigger. But my persisted object (myObjectToPersist) still contains the "-1" I initially set as dummy (updated by the DB trigger).

This is my mapping (just showing significant code):

...
<id name="id" column="ID" type="long" unsaved-value="-1">
<!--generator class="native"/-->
</id>
...

Any ideas?

Thanks,
Gabriel

hey
i think it is due to your mapping - i am using this mapping for my sequence generation:

<generator class="sequence">
<param name="sequence">customer_sequence</param>
</generator>


and it works very well. Hibernate use my sequence objects in my db to generate correct ids - i dont need to set them my self when i create new objects.

the value of param is the name of my db sequence..

rasmus

The only problem is that I would like to standarize the id creation (also for external access of my hibernate-enabled app), plus the id creation is not just a sequence number.

In the trigger I am using the sequence, plus extra process.

In fact, thank you, I was using the sequence as you are saying and works as a charm.

Any ideas, for that extra functionality, then always use my trigger for id's creation process?

Thanks,
Gabriel

If your table contains some unique business-key you could use the select-generator to retrieve your DB-generated id. Just do something like


If you don't have some unique identifier (apart form the id-property) hibernate will have trouble finding the inserted row that belongs to the object you just persisted.

Greets

piet

check http://forum.hibernate.org/viewtopic.php?t=965442
tested on Oracle 10g (does not work with 8i due to jdbc bug)

i just decided to use the sequence generator. and in the trigger ask if the id is null, then use the sequence. if not (when external access) use the predefined on the row.

Thanks