JDBC compliance

From: Abel Muiño <abel(dot)muinho(at)mundo-r(dot)com>
To: PostgreSQL JDBC List <pgsql-jdbc(at)postgresql(dot)org>
Subject: JDBC compliance
Date: 2003-01-07 16:27:36
Message-ID: 1041956855.15028.19.camel@calculin.casadeabel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello.

I'm evolving an application where BLOBs and CLOBs where being used over
Oracle. Now I'm extending this to use other databases, but I've found
that PostgreSQL support for them is "broken".

According to the JDBC standard (downloadable from
http://java.sun.com/products/jdbc/download.html#corespec30) section
16.3.2: "The setBinaryStream and setObject methods may also be used to
set a Blob object as a parameter in a PreparedStatement object.".

But postgres' JDBC driver uses "bytea" database type for
setBinaryStream and "oid" (large object interface) when using getBlob.

I have worked around it by falling back to the 7.1 compatible mode,
where Large Objects were used for both, but I would like to know which
is the current state of this issue.

Thanks a lot.

--
Abel.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Candis Thomas 2003-01-07 19:16:20 JDBC Driver -- getImportedKeys
Previous Message Michael Paesold 2003-01-07 15:15:46 Re: [JDBC] Problem: commit doesn´t work