db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: [jira] Updated: (DERBY-898) setAutoCommit(false) is not working properly for local connection with ClientXADataSource
Date Fri, 03 Feb 2006 21:13:09 GMT
> The problem in this case was that the  server side connection was  set to autocommit true.

 > Even when the client has autocommit on, the server side connection should be autocommit
 > false and let the client drive the commits.

Hi Kathey,

I wonder if you could take a moment and expand on this idea a bit, because when
I first read it, I was surprised.

My first reaction when I saw DERBY-898 was to expect that the autocommit state
on the server and the client ought to match, and that when the autocommit state
on the client was changed, that change would be propagated to the server.

Thus, I expected to see you changing the client so that when setAutoCommit(false)
was called on the client, a message was sent to the server to turn autocommit
off on the server side.

Is this something specific to XA distributed transactions, or is it just a
fundamental aspect of how the Network Server behaves that all transaction
control should be performed by the client?



View raw message