0 Replies Latest reply on Jun 25, 2007 5:42 PM by Frank Langelage

    ORDER BY and FOR UPDAE

    Frank Langelage Master

      Since my JBoss App shares the database with a C++-App I'd like to enable <row-locking> for the Entity Beans.
      But this is incompatible with accessing data in a defined order.
      The SQL-statement for a finder "SELECT ... ORDER BY a, b FOR UPDATE" is, at least for Informix DB, illegal.
      You can only use either "ORDER BY" or "FOR UPDATE".
      But I can't do without one of them.

      Any similar experience?
      Any hints how to solve this dilemma?