Re: Oracle Blob update: Missing IN or OUT parameter at index:: 2

From: Mike Kienenberger (mkienen..mail.com)
Date: Wed Nov 23 2005 - 13:10:01 EST

  • Next message: Andrus Adamchik: "Re: Oracle Blob update: Missing IN or OUT parameter at index:: 2"

    It's an optimistic lock :) You know me so well.

    I take it that optimistic locking isn't supported on blobs yet?

    On 11/23/05, Andrus Adamchik <andru..bjectstyle.org> wrote:
    > Is "DATA" a part of a PK or an optimistic lock by any chance?
    >
    > Andrus
    >
    >
    > On Nov 23, 2005, at 8:20 PM, Mike Kienenberger wrote:
    >
    > > Any ideas what could be causing this?
    > >
    > > INFO QueryLogger: UPDATE CONTENT_DATA SET DATA = EMPTY_BLOB() WHERE
    > > CONTENT_ID = ? AND DATA = ?
    > > INFO QueryLogger: [bind: 280, < 44 6F 20 79 6F 75 20 68 61 76 65 20
    > > 77 68 61 74 20 69 74 20 74 61 6B 65 73 2E 2E 2E 0D 0A 0D 0A 2E 2E 2E
    > > 74 6F 20 72 75 6E 20 61 20 6D 75 6C 74 69 2D 6D 69 6C 6C 69 6F 6E 20
    > > 64 6F 6C 6C 61 72 20 62 75 73 69 6E 65 73 73 20 74 68 61 74 20 70 72
    > > 6F 76 69 64 65 73 20 61 6E 20 65 73 73 65 6E 74 69 61 6C 20 73 65 72
    > > 76 69 63 65 20 74 6F 20 39 30 2C 30 30 30 20 49 6E 74 65 72 69 6F 72
    > > 20 72 65 73 69 64 65 6E 74 73 3F 0D 0A 0D 0A 47 56 45 41 27 73 20 44
    > > 69 73 74 72 69 63 74 20 34 20 4E 6F 6D 69 6E 61 74 69 6E 67 20 43 6F
    > > 6D 6D 69 74 74 65 65 20 73 65 65 6B 73 20 42 6F 61 72 64 20 6F 66 20
    > > 44 69 72 65 63 74 6F 72 20 63 61 6E 64 69 64 61 74 65 73 2E 20 56 69
    > > 65 77 20 74 68 65 20 62 69 6C 6C 20 69 6E 73 65 72 74 20 68 74 74 70
    > > 3A 2F 2F 77 77 77 2F 67 76 65 61 2F 63 6F 6D 2F 62 69 6C 6C 2D 69 6E
    > > 73 65 72 74 20 66 6F 72 20 6D 6F 72 65 20 69 6E 66 6F 72 6D 61 74 69
    > > 6F 6E 2E 0D 0A >]
    > > INFO QueryLogger: *** error.
    > > java.sql.SQLException: Missing IN or OUT parameter at index:: 2
    > >
    >
    >



    This archive was generated by hypermail 2.0.0 : Wed Nov 23 2005 - 13:10:03 EST