[jboss-user] [JCA/JBoss] - Configure no-tx-datasource: not to acquire shared lock

[vigneshmpn]

I am using JBoss 4.2.3.

Our application queries multiple ODS datasources. As they are read-only operations, all the ODS datasources are configured as no-tx-datasource as we don't need the read operations to be part of any transaction. 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. So we need a configuration so that the read operations (SELECT queries) on the datasources does not acquire shared lock on the data records read. 

We don't want to add "WITH (NOLOCK)" in all our queries. Instead we would like to configure the transaction isolation level to TRANSACTION_READ_UNCOMMITTED for the datasources. But the JBoss documentation mentions that the property <transaction-isolation/> is not applicable for no-tx-datasource.

Is there a way to configure a no-tx-datasource, not to acquire a shared lock on execution of a SELECT query? I could be conceptually wrong about my understanding of no-tx-datasource.

One workaround we thought is to configure them as local-tx-datasource and mention the transaction-isolation property. 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.

I would highly appreciate any help.

Thanks
Vignesh

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4241244#4241244

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4241244