This content has been marked as final.
Show 1 reply
-
1. Re: Configure no-tx-datasource: not to acquire shared lock
vickyk Jul 21, 2009 5:47 AM (in response to vigneshmpn)"vigneshmpn" wrote:
I understand that though the read operations are not part of a transaction, the SELECT query would still acquire a shared lock on the data records read until the result is returned
I don't believe it to be the default behaviour, are you guessing this or you have tested it?"vigneshmpn" wrote:
But most part of our business logic run as part of container-managed transaction, and so we don't want the read operations to be part of the transaction unnecessarily.
Using no-tx-datasource inside the Container managed transaction does not make any sense, also setting the transaction isolation level on the no-tx-datasource too would not make sense.