How can I prevent database locking on reads?

[ericcire]

I have a statless session bean that reads from a table, and gets the connection from a datasource.

When reading from the table, it locks the database. How can I prevent this? Do I need a new transaction attribute? Should I set a transaction attribute on the connection I get from the datasource? Do I need to edit the "commit-options" in standardjboss.xml?

[wmprice1240]

Check the documentation for the DBMS that you are using. The area that you want to research I believe is around the subject of the isolation level for a particular transaction.

Regards,

Weston M. Price

[ericcire]

Thanks for your response. I can always call setTransactionIsolation on the connection, but won't that mean bean-managed transactions? I thought there was a way customize how JBoss handles CMT.