I configured an XA Datasource working with oracle. My Application is mostly CMP 2.0 but some selects are done directly to the DB on non entity bean tables.
When in transaction thal works with entity beans, if I do a select directly to the DB by doing getConnection on the Datasource will I get the same connection that JBoss is using to persist the CMPs or a different one.? If it is a different connection from the same datasource would commit and rollback work on both connections?
If the datasource were a local non XA datasource would the behavior be different?