JMS, DB transaction under same JTA

[niefeng]

Hi all,

I am using JBOSS 4.0.5 GA, Oracle 10 g, and running them on Solaris 10. After reading the wiki http://wiki.jboss.org/wiki/Multiple1PC, does it means that it is not safe to put the DB transaction and JMS transaction under the same JTA?

I have the following scenario. An MDBean will invoke the SLSB to create entity. After that, it will send out JMS msg.

MD Bean --> SLSB --> create "entity A"
--> send JMS

Is it true that if the MD Bean rollback (system crashed for example), it is possible the "entity A" will be commited to the DB while the sending of JMS to the JMS server will fail?

Thanks

[niefeng]

To add on, the transaction that the MD Bean, SLSB, entity bean is "Required"

[jhalliday]

maybe. depends on your configuration.

[justkeys]

If you use transactional jms, and the required tx attribute on mdb and slsb:

the message will only be sent if the db was able to persist,
and the message will not be sent if the db was not able to persist,
and the db will not persist, if the message was unable to be sent
etc: both take part in the same transaction.

This explains how to do tx jms
http://www.odi.ch/prog/jms-tx.php