I use some tables that auto-generate a primary key upon insert (via trigger). Now, when I perform a <table>Manager.save(pObject), how can I get back the PK?
I cannot change the trigger, and the db is Oracle8i so I can't use getGeneratedKeys() either.
I've tried reloading the returned pObject from the save call, but that throws "The pObject to look for is invalid : not initialized !...
Any ideas?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi there,
I use some tables that auto-generate a primary key upon insert (via trigger). Now, when I perform a <table>Manager.save(pObject), how can I get back the PK?
I cannot change the trigger, and the db is Oracle8i so I can't use getGeneratedKeys() either.
I've tried reloading the returned pObject from the save call, but that throws "The pObject to look for is invalid : not initialized !...
Any ideas?
The save returns the bean. You should be able to retrieve the key from it.