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

    Does optimistic locking work with Blobs?

    Pavol Bernhauser Newbie

      Hello,
      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:

      null)

      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.

      Thanks,
      Pavol