Hi, I need to use FOR UPDATE for one of my CMP entity bean. We had <row-locking>true</row-locking> in jbosscmp-jdbc.xml of that CMP Bean.
Now we are upgrading our application from 3.2.1 to 3.2.5, The same CMP bean giving following SQL error. Error = Find failed: java.sql.SQLException: ORA-01786: FOR UPDATE of this query expression is not allowed I found from the docs that I canot use "TRUE" if my QL contains DISTINCT and for some other oracle key words. How to configure FOR UPDATE for findByPrimaryKey, instead of specifying for whole entity. Did anything changed from 3.2.1 to 3.2.5 related to EJB-QL and Row locking? If So, Please let me know what else I should configure to get row locking. Many Thanks Venku View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843715#3843715 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843715 ------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user