[JBoss-user] [Persistence CMP/JBoss] - Re: ORA-01786: FOR UPDATE of this query expression is not al
Alex, We use row-lockingfalse/row-locking 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=bbop=viewtopicp=3839493#3839493 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3839493 --- This SF.Net email sponsored by Black Hat Briefings Training. Attend Black Hat Briefings Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: ORA-01786: FOR UPDATE of this query expression is not al
Alex, You are right! Mea culpa! In standardjbosscmp-jdbc.xml we use row-lockingfalse/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 View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3839501#3839501 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3839501 --- This SF.Net email sponsored by Black Hat Briefings Training. Attend Black Hat Briefings Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: Q: why EJBQLs run cyclic slowly
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=bbop=viewtopict=49936 Shortly: the new versions of JBoss genereates different SQL code. Oracle RDBMS can not interpret SELECT DISTINCT with FOR UPDATE and this is understandable. 3.2.2RC3 generates the same SQL code without FOR UPDATE clause, so our application runs fine in this version. If we are able to run our applcation on 3.2.4 we can tune the cache size and policy as you recommended. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3839397#3839397 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3839397 --- This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: ORA-01786: FOR UPDATE of this query expression is not al
Thanks for your answer. Of course we use row-lockingfalse/row-locking 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=bbop=viewtopicp=3835630#3835630 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835630 --- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149alloc_id=8166op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: ORA-01786: FOR UPDATE of this query expression is not al
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=bbop=viewtopicp=3835684#3835684 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3835684 --- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149alloc_id=8166op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user