Using select strategy (id generated by oracle trigger)

[Michael Houlo]

Dear,

My bean id is generated by an oracle sequence which is incremented and affected by a trigger.
I have to specify it in my bean, i see a lot of example on internet, but always with xml files... I'm using annotations..

Here is what i tryed :

@id
@GeneratedValue(generator="trig-gen")
@GenericGenerator(name="trig-gen", strategy="select", parameters = @Parameter(name="key",value="TAB_ID"))
public long getId(){...}

I have an unknown property "TAB_ID"

If i disable the oracle trigger and use this following code, it works.. Hibernate will manage the sequence, but that's not what i want..

@Id
@GeneratedValue(strategy= GenerationType.AUTO,generator="mygen")
@SequenceGenerator(name="mygen",sequenceName="SCHEMA.SEQUENCE")
@Column(name="TAB_ID",unique=true..)
public long getId(){...}

Since the bean doesn't know the id is managed by oracle, when i do "save(myObj)", the record is correctly inserted, but the id returned is "0" ..
Furthermore, when i use saveOrUpdate(myObj), even if the id already exist (i'm updating an existing record), hibernate will insert a new record instead of updating the existing one...

Could you tell me how to do ?
Thanks a lot !