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