Hi, I've found that if I change the row locking tag from "true" to "false" that I overcome the problem. Here is the snippet from jbosscmp-jdbc.xml
< jbosscmp-jdbc > < defaults > < row-locking > false < /row-locking > I presume the reason that this works is because JBoss only outputs a SELECT statement and not a SELECT FOR UPDATE one. Can someone please tell me the implications of leaving row locking set to "false"? Ideally, I would like to leave it at the original value of "true". Is there some other parameter that I can set to give me the same effect of inhibiting the output of a SELECT FOR UPDATE SQL statement on read only EQL type methods. Thanks in anticipation Roger View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3876020#3876020 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3876020 ------------------------------------------------------- This SF.Net email is sponsored by: NEC IT Guy Games. Get your fingers limbered up and give it your best shot. 4 great events, 4 opportunities to win big! Highest score wins.NEC IT Guy Games. Play to win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
