Hi Bryan,
as for me, the problem is not on JBoss side. We have a similar scenario and it works great. We use oracle too. How do you perform insert into a file table ? Marek bryan hansen <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent by: cc: (bcc: Marek Sedliak/BYS/SOFTIP) [EMAIL PROTECTED] Subject: [JBoss-user] ejb foreign contsraints question eforge.net 21.03.2002 15:24 I have a question as to if this will work in JBoss. I have tried this in IPlanet (which sucks) and it is not working, but I believe that it should. I have an statless session ejb that starts a user transaction called process. It then calls a statless session ejb named file that inserts some data into an oracle database. When finished with that the process ejb then calls a different stateless session bean named collateral. The collateral table has a foreign key constraint to the file table, but since this is in the same user transaction it has not written the data out to the file table to complete the foreign key constraint. I think that the container should handle this, but other people think otherwise. Any comments? Suggestions? I want to try this in JBoss, but haven't had the time to set it up and a database on a different machine. Thanks, Bryan __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user