Eclipse Community Forums: EclipseLink » How to obtain the entity ID after persit from a trigger generated value

Home » Eclipse Projects » EclipseLink » How to obtain the entity ID after persit from a trigger generated value(How to obtain the entity ID after persit from a trigger generated value)

How to obtain the entity ID after persit from a trigger generated value [message #1017084]

Fri, 08 March 2013 16:51

Eclipse User

We are using eclipselink via Glassfish 3+, our oracle table has a trigger that generates a PK VARCHAR value from a trigger. The value is generated from the CCYYMMDD of the current date and a sequence value. We can persist the entity without issues but we cannot figure out how to obtain the entity @ID value once the object has been persisted. We set the id value to null when the object is initialized, the id value is then generated by the trigger. We've tried to get the id after the persist with a flush and/or refresh but it's not working.

The trigger and the ID value is controlled by the DBA's and the requirements for the application.

Any solutions to the problem...Thanks.

[Updated on: Fri, 08 March 2013 17:05] by Moderator

Re: How to obtain the entity ID after persit from a trigger generated value [message #1018820 is a reply to message #1017084]

Thu, 14 March 2013 10:28

Eclipse User

You might be able to use @ReturnInsert on the @ID field as described here:
http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/a_returninsert.htm#CIHHEGJE

This has draw backs though, as the sequence cannot be preallocated and so not available until after the persist call has been flushed.

Best Regards,
Chris

Previous Topic:	JPA-RS: @OneToMany: invalid output when retrieving relationship link
Next Topic:	strange problem with error cvc-elt.1 and name space

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 27 06:50:04 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter