6 Replies Latest reply on Aug 30, 2004 3:00 PM by ceh

    BLOBs and Transactions

    ceh Newbie

      JBoss 3.2.4
      Oracle 9 or 10
      I have a bean with byte[] fields that are stored as BLOBs in the Oracle database. The bean is created with the blobs empty. When I update both blob fields (an image and an audio clip) within a transaction using the setter method, the values get switched in the database. That is, the audio clip ends up in the image field and vice versa. If I do the exact same update, but not within an explicit transaction, the values get entered in the database correctly and can be nicely retreived, etc. I cannot find anything anywhere that speaks to this issue - I appreciate any help.