JDBC XAConnection and implicit transactions

Hi!

Half-half OT, but since I suspect the answer to be hidden in the connector
spec...

Several app servers does not allow you to execute select statements through
a jdbc Connection obtained from an XADatasource, unless you are in a context
of a JTA transaction.

WebLogic 7++ and WebSphere 4+ are examples of such app servers.


 1) ut.begin()
 2) Obtain XA connection
 3) sql select
 4) xaconn.close()
 5) ut.commit()

 ...works...while...

 1) Obtain XA connection
 2) sql select

 ...doesn't...


Is this behaviour mandated by any spec of the J2EE bundle, or by the J2EE
spec it self?


/Johan

===========================================================================
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff CONNECTOR-INTEREST".  For general help, send email to
[email protected] and include in the body of the message "help".