This is not a JMS question.
You have configured your datasource to use
but the version of the OracleException you have does
not include the method
and adrian, can you have a method to make mdb use non-XA?
Using non XA mdb (really JMS) will not solve your problem.
You still have two resources that are potentially not consistent.
To answer your specific question,
You can configure the jms provider in jms-ds.xml to use java:/ConnectionFactory
instead of the XA version.