I'm using AR latest and Oracle9Dialect with a trigger on my table for sequence-generated IDs.
NH2.1.0 has added a new trigger-identity generator which provides the ability to return the value of a POID generated by a sequence called from a trigger fired upon insert. In my case, I can't drop / modify the existing insert trigger since it's used by others. Also, the trigger does more than just ID generation. Has anyone come up with a nice way to replicate this functionality with AR latest? Looking for any and all ideas. Otherwise, has anyone had success using another generation strategy to accomplish the same? Native and Assigned both work, but I need the generated ID returned from the INSERT in order to refresh my object. Also, any idea if future releases of AR will support this functionality? Quote: The “trigger-identity” is a NHibernate specific feature where the POID is generated by the RDBMS at the INSERT query trough a BEFORE INSERT trigger. In this case you can use any supported type, including custom type, with the limitation of “single-column” (so far). The query in ORACLE is: INSERT INTO my_entity (Name) VALUES (:p0) returning Id into :nhIdOutParam Thanks. martin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
