0 Replies Latest reply on May 14, 2002 8:36 AM by still

    select-for-update AND commit-options

    still

      i use jboss2.2.2 on windows2k
      I have created a CMP entityBean and its client.
      since the datasource maybe modified from out of the jboss ,i think it is correctly set the <commit-options/>
      to true and also the <select-for-update/>.

      when i only set <commit-options/> to true,it is ok.All the modification will be automatically updated in the entitybean.and when i set <select-for-update/> to true
      (i think it will be more ok) a lot of Exceptions were thrown out.the following lines:

      java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
      javax.transaction.TransactionRolledbackException: Load failed; nested exception is:
      java.sql.SQLException: Line 2: FOR UPDATE clause allowed only for DECLARE CURSOR. Severity 15, State 2, Procedure 'DataServer null', Line 2; nested exception is:
      ............

      who could tell me why i can not set the
      "<select-for-update/>" to true or anything i missed?

      thx in advance