Fwd: [JDBC] BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Aug 01 2005 - 11:38:08 EDT

  • Next message: Andrus Adamchik: "vacation note"

    FYI: my email exchange with PostgreSQL folks regarding BLOB mapping
    to PostgreSQL "bytea" type. They recommend using "oid" instead.
    Anyone has experience with PostgreSQL oids as BLOBs?

    Andrus

    Begin forwarded message:

    > From: Andrus Adamchik
    > Date: August 1, 2005 7:35:15 PM GMT+04:00
    > To: Kris Jurka
    > Subject: Re: [JDBC] BUG #1780: JDBC driver "setNull" throws for
    > BLOB and CLOB
    >
    >
    > Kris,
    >
    >> You need to use
    >> oid as the underlying type, or if you want to use bytea you need
    >> to use
    >> setBytes or setNull(x, Types.BINARY).
    >>
    >>
    >
    > I suspected that this problem could be due to our misinterpretation
    > of PostgreSQL data types. "bytea" seemed the closest thing to BLOB,
    > and it worked like one in almost all of our tests. But I'll give
    > oid a try.
    >
    > Thanks
    > Andrus

    This archive was generated by hypermail 2.0.0 : Mon Aug 01 2005 - 11:38:06 EDT