[JBoss-user] [Persistence & CMP/JBoss] - Re: ORA-01786: FOR UPDATE of this query expression is not al

2004-06-22 Thread cslenkey
Alex, You are right! Mea culpa! In standardjbosscmp-jdbc.xml we use false But in jbosscmp-jdbc.xml which is generated by the generator of Software Through Pictures application we generate TRUE I was mindless... Thx View the original post : http://www.jboss.org/index.html?module=bb&op=viewt

[JBoss-user] [Persistence & CMP/JBoss] - Re: ORA-01786: FOR UPDATE of this query expression is not al

2004-06-22 Thread cslenkey
Alex, We use false setting in standardjbosscmp-jdbc.xml as you can see in my comment at Jun 6, 2003 10:19 AM Csaba View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839493#3839493 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=r

[JBoss-user] [Persistence & CMP/JBoss] - Re: Q: why EJBQLs run cyclic slowly

2004-06-21 Thread cslenkey
Dear Alex, I would like to respond to your message. Veranda is one of my collegaues who is out of office today. We have tried the 3.2.4RC2 and we could not use it. I have opend a topich about our problem why we could not use 3.2.4: http://jboss.org/index.html?module=bb&op=viewtopic&t=49936 Shor

[JBoss-user] [Persistence & CMP/JBoss] - Re: ORA-01786: FOR UPDATE of this query expression is not al

2004-05-20 Thread 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 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835684#3835684 Reply to t

[JBoss-user] [Persistence & CMP/JBoss] - Re: ORA-01786: FOR UPDATE of this query expression is not al

2004-05-19 Thread cslenkey
Thanks for your answer. Of course we use false setting. That is the reason why I do not understand what has changed between the two versions. Csaba View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835630#3835630 Reply to the post : http://www.jboss.org/index.ht

[JBoss-user] [Persistence & CMP/JBoss] - ORA-01786: FOR UPDATE of this query expression is not allowe

2004-05-19 Thread cslenkey
Hi, We have an EJB application wich is running now in JBoss-3.2.2RC3. I would like to use this on JBoss-3.2.4RC1 because I have read in the forum that there is a solution to use JOINs and SUBSELECT in querys. When we are running our application we get the: ORA-01786: FOR UPDATE of this query expr