Обсуждение: JDBC compliance

Поиск
Список
Период
Сортировка

JDBC compliance

От
Abel Muiño
Дата:
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.