2 Replies Latest reply on Feb 28, 2004 1:25 PM by Alexey Loubyansky

    Does optimistic locking work with Blobs?

    Pavol Bernhauser Newbie

      I have CMP entity bean which I tried use with optimistic locking. I've updated jbosscmp-jdbc.xml as manual states. Version number is used as strategy for optimistic locking.

      But saving bean with blob column updated throws exception.

      org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImp
      l [FormatId=257, GlobalId=sonic//27, BranchQual=] status=STATUS_NO_TRANSACTION;
      - nested throwable: (javax.ejb.EJBException: Store failed; CausedByException is:


      When updating of blob field is uncommented, everything works OK.
      Can you tell me if JBoss 3.2.2RC2 supports blob columns for optimistic locking?
      BTW, application works with pessimistic locking.