only 1 local transaction if jms uses the same db?

[weiqingh]

hi there,

i have an MDB that also does some database operations. i would like to have the message receive and jdbc work be in the same transaction. however, i am using a sybase that doesn't support XA.

i was wondering if i configure jms to use the same sybase to store messages, would i get only 1 local transaction instead of 2? i.e. the database work and message acknologement will be committed together.

thanx.

[adrian.brock]

No, it doesn't work that way.

The JMS branch is stored in a JMS XAResource
which is only persisted to the db during prepare()

I thought you could get XA for sybase, maybe
it costs more?

Regards,
Adrian