> >2. I cannot write any workable transaction sample. The scenario is that: >I have a (stateless) session bean which looks up two CMP beans, each of the >CMP beans insert a record (into two different tables). However, I notice >that whatever the result of the 2nd insert (e.g. Oracle raises errors), the >1st insert get committed automatically (this is accomplished by placing a >sleep between the two inserts and select from the Oracle table in SQLPlus). >I have tried using user-transaction and container-managed transactions mode, >but no luck.
Are you using thread control in your ejbs, or did you just add the sleep call for testing? Transactions are managed on a per-thread basis and multi-threaded beans will not work properly. You should not attempt to call any Thread functions (including sleep) from your ejb. > >3. Can you tell me what are the differences between oracle-service.xml and >oracle-xa-service.xml ? Should I use oracle-xa-service.xml ? How to make it >works to use oracle-xa-service.xml ? the oracle-xa-service allows you to use oracle with other XA data sources in a single transaction. If you are only using Oracle, this is not necessary. > >Sorry, for my long paragraphs. I have asked these questions from the JBoss >forums but not much responses and solutions. Attached please also find my >configuration files FYR. Please help. > I didn't see any attached files?? b __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
