Professional Web Applications Themes

Inconsistant results when selecting BLOB data with 8.1 - IBM DB2

Operating system : windows 2000 DB2 8.1 fixpack2 I have a table with a BLOB column. I am testing the process of writing to the blob column and reading it back using JDBC. I can do this without a problem as long as I have a single thread running the test. If I have more than one thread, it appears that the BLOB data written by one thread overwrites the BLOB data read by the other thread. The test runs as follows. Thread1: save 'I am Thread 1" in the BLOB column for the row with id = 1. Thread2: ...

  1. #1

    Default Inconsistant results when selecting BLOB data with 8.1

    Operating system : windows 2000
    DB2 8.1 fixpack2

    I have a table with a BLOB column. I am testing the process of writing
    to the blob column and reading it back using JDBC. I can do this
    without a problem as long as I have a single thread running the test.
    If I have more than one thread, it appears that the BLOB data written
    by one thread overwrites the BLOB data read by the other thread. The
    test runs as follows.

    Thread1: save 'I am Thread 1" in the BLOB column for the row with id =
    1.
    Thread2: save 'I am Thread 2" in the BLOB column for the row with id =
    2.
    Thread1: read from the BLOB column for the row with id = 1. The
    inputstream contains "I am Thread2". The expected value is "I am
    Thread1"

    Each thread gets its own connection object.

    Do you know what I could be doing wrong? Any help will be greatly
    appreciated.

    thanks
    reddy
    Reddy Rachamallu Guest

  2. #2

    Default Re: Inconsistant results when selecting BLOB data with 8.1

    Reddy Rachamallu <rrachamalluhotmail.com> wrote:
    > Operating system : windows 2000
    > DB2 8.1 fixpack2
    >
    > I have a table with a BLOB column. I am testing the process of writing
    > to the blob column and reading it back using JDBC. I can do this
    > without a problem as long as I have a single thread running the test.
    > If I have more than one thread, it appears that the BLOB data written
    > by one thread overwrites the BLOB data read by the other thread. The
    > test runs as follows.
    >
    > Thread1: save 'I am Thread 1" in the BLOB column for the row with id =
    > 1.
    > Thread2: save 'I am Thread 2" in the BLOB column for the row with id =
    > 2.
    > Thread1: read from the BLOB column for the row with id = 1. The
    > inputstream contains "I am Thread2". The expected value is "I am
    > Thread1"
    >
    > Each thread gets its own connection object.
    Could you possibly post the code so that others could have a look at it and
    recreate your scenario?

    --
    Knut Stolze
    Information Integration
    IBM Germany / University of Jena
    Knut Stolze Guest

Similar Threads

  1. #38921 [NEW]: pdo lost the first row data:with firebird blob data
    By achun dot shx at gmail dot com in forum PHP Bugs
    Replies: 2
    Last Post: January 27th, 12:54 PM
  2. inserting and selecting BLOB data in db2
    By Poul Møller Hansen in forum PHP Development
    Replies: 0
    Last Post: November 3rd, 09:41 PM
  3. #25118 [Opn->Ver]: can't store data in blob fields
    By kalowsky@php.net in forum PHP Development
    Replies: 0
    Last Post: October 22nd, 11:47 PM
  4. #25118 [Fbk]: can't store data in blob fields
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: August 28th, 08:17 AM
  5. PHP, MySQL, Blob data type
    By Alex Yu in forum Macromedia Dreamweaver
    Replies: 3
    Last Post: July 29th, 04:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139