JBoss and SQLServer 2000

[tavito]

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????

Thank's!!!!

[hariv]

If you are using straight JDBC you can add WITH(NOLOCK) after your FROM clause. This will alow concurrent reading my SQL Server.