db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-161) PostgreSQL Blob type mapping should be OID in v8
Date Wed, 07 Mar 2007 06:41:24 GMT

    [ https://issues.apache.org/jira/browse/DDLUTILS-161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12478693

Thomas Dudziak commented on DDLUTILS-161:

Mhmm, AFAICT bytea is the correct type (see e.g. http://www.postgresql.org/docs/8.1/static/datatype-binary.html
vs. http://www.postgresql.org/docs/8.1/static/datatype-oid.html). Also, blobs work fine (there
are unit tests for that and they pass in PostgreSql 8.1 using the 8.1 driver).
Could you give more info as to what you did to produce this error ? E.g. the model XML, the
connection info, Ant/code snippet etc.

> PostgreSQL Blob type mapping should be OID in v8
> ------------------------------------------------
>                 Key: DDLUTILS-161
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-161
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core - PostgreSql
>         Environment: PostgreSQL 8.1.8 on Fedora core 6 (i386).
>            Reporter: Richard Bounds
>         Assigned To: Thomas Dudziak
> For PostgreSQL v8 JDBC drivers the blob type maps to OID, not BYTEA:
> from here: http://doc.postgresintl.com/jdbc/ch08.html
>  "....To use the Large Object functionality you can use either the LargeObject class
provided by the PostgreSQLâ„¢ JDBC driver, or by using the getBLOB() and setBLOB() methods...."

> When using PostgreSQL (v7 or v8) with the v7 JDBC drivers BYTEA works fine, but with
the v8 drivers you get an error message:
> ERROR: column "binvalue" is of type bytea but expression is of type oid

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message