In general, the XA JDBC driver class should be used to
configure the datasource.
In some cases where multiple connections in a transaction use the same
datasource, an optimization takes place so that a one phase commit
datasource can be used to process the multiple connections in the
transaction.
However if the userids are different, then separate connection pools
are created for each userid, thus they will appear as multiple resources
in a transaction. Userids are case sensitive, thus a separate connection
pool is created for each case combination of the userid.
|