Hello, I am using EJB for my application WEB. I have a problem, the application this responding to a single user per time. I have formed mssql-ds.xml, where I specify the data base and usr and pass to him with which it will be connected. Why it can be that it blocks to the rest of the users, while one of them is making query? thanks
SQL Server locks the row ,even if you are reading it in a transaction.
Please take a lock at this site
If you have lot of traffic , this locks can escalate to page , table and database level lock.
I guess you are talking abt straight jdbc access from your container.