SQL Server locks the row ,even if you are reading it in a transaction. Please take a lock at this site
http://www.developerfusion.com/show/1688/4/ 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. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3860433#3860433 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3860433 ------------------------------------------------------- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
