Hi, I'm trying to run an entity bean on Orion server 1.5.2, and I'm trying to use triggers and sequences to populate the primary key field of the table whenever a new record is created. The entity bean is invoked from a servlet through a session bean layer. I'm having two problems with this: 1. getting the entity bean to pull back the newly created pk value from the table to its attribute. Do I need to somehow 'refresh' the bean? 2. getting the trigger to increment after each new record create - on first use, it creates one record, but fails to create any more unless you stop and start the app server. We solved this problem for Orion 1.4.5 by setting exclusive-write-access="false" in orion-ejb-jar.xml, but this is not working in the later version. Maybe I'm going about it the wrong way and cannot use triggers. Is this the case? It works fine if I use just the sequence, to retrieve the next value and use this to create the PK in the entity bean, but not with the trigger. Any help would be greatly appreciated. =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
