Hi,

here is my xml file

<!-- id property. -->
<id name="id"
type="integer"
column="ATTR_ID"
unsaved-value="null"
access="field">
<generator class="assigned"/>
</id>

here is the trigger

CREATE OR REPLACE TRIGGER TRG_VALUE
BEFORE INSERT ON value
FOR EACH ROW
BEGIN
SELECT VALUE_SEQ.NEXTVAL,user,sysdate,user,sysdate
INTO :new.attr_val_id,:new.cuser,:new.cdate,:new.muser,:new.mdate
FROM dual;
END;

When I try to insert, I got an error like

ORA-02289 sequence does not exist
select hibernate_sequence.nextval from dual

Any clue? Thanks much.

anyone here?

Well, to address your posted question, I'd investigate permissions on your sequence.

However, the solution you have proposed will require that hibernate query the DB after an insert in order to get the recently assigned ID. I'm not 100% on how to do that.

What I suggest you do instead is change the generator to a sequence, like this:

You can also add in a <timestamp> for your other columns.

Good luck!
Stephen

I tried this approach,

when I call save() in the code. After save(), I print out the object and it uses value 10000.

however, when i look into the db, the actual value it's used is 10001.

any help from hibernate team?

any help?

Have a look here: http://forum.hibernate.org/viewtopic.php?t=973262