I'm using jboss and sql server 2000 to develop my j2ee application, and when two clients try to make a query, the first can do it, and the last must wait until the first finalize.
The isolation level configured in the jbosscmp-jdbc.xml is TRANSACTION_READ_UNCOMMITTED.
Can someone help me????
If you are using straight JDBC you can add WITH(NOLOCK) after your FROM clause. This will alow concurrent reading my SQL Server.