0 Replies Latest reply on Jul 30, 2004 5:17 AM by ikigovenku

    Row Locking and JBoss 3.2.5

    ikigovenku Newbie


      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