-
1. Re: ORA-01786: FOR UPDATE of this query expression is not al
lafr May 19, 2004 3:42 PM (in response to cslenkey)One reason for the "for update" clause would be a config line in standardjbosscmp-jdbc.xml /jbosscmp-jdbc.xml:
<row-locking>true</row-locking> -
2. Re: ORA-01786: FOR UPDATE of this query expression is not al
cslenkey May 20, 2004 2:13 AM (in response to cslenkey)Thanks for your answer.
Of course we use <row-locking>false</row-locking> setting.
That is the reason why I do not understand what has changed between the two versions.
Csaba -
3. Re: ORA-01786: FOR UPDATE of this query expression is not al
cslenkey May 20, 2004 9:33 AM (in response to cslenkey)DISTINCT and FOR UPDATE are incompatible. This the reason of the Oracle-01786 error message.
But why does generate different SQL code JBoss3.2.2RC and 3.2.4?
Can anyone help?????
Csaba -
4. Re: ORA-01786: FOR UPDATE of this query expression is not al
aloubyansky Jun 22, 2004 4:28 AM (in response to cslenkey)Unless there <row-locking>true</row-locking> we don't append FOR UPDATE.
-
5. Re: ORA-01786: FOR UPDATE of this query expression is not al
cslenkey Jun 22, 2004 4:42 AM (in response to cslenkey)Alex,
We use <row-locking>false</row-locking> setting in standardjbosscmp-jdbc.xml as you can see in my comment at Jun 6, 2003 10:19 AM
Csaba -
6. Re: ORA-01786: FOR UPDATE of this query expression is not al
cslenkey Jun 22, 2004 5:08 AM (in response to cslenkey)Alex,
You are right! Mea culpa!
In standardjbosscmp-jdbc.xml we use <row-locking>false</row-locking>
But in jbosscmp-jdbc.xml which is generated by the generator of Software Through Pictures application we generate TRUE!!!!
I was mindless...
Thx