Oracle RAC is not a supported database at this time, so I can't say whether or not it will work straight off.
Regarding prepare, once a transaction branch has been successfully prepared, then once the database has come up, the transaction recovery manager will decide whether to commit or roll it back.
Thanks, can you think of any circumstances under which it might be possible for a message to end up in the database, but not in the 'in memory queues' of the JMS servers?
I guess if the message was successfully inserted into the db, then the db threw an exception that prevented it being added to the queue.
Although, as I say, this is really moot since we haven't tested with Oracle RAC or not anyway.
I guess something like that must have happened. It is a little suspect that it happened to two messages, but it is possible some batching may have been involved.
Im aware RAC isnt supported, Im just trying to get to the bottom of why this happens.
Thanks for your help again ;)