Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-711

SQLTemplate data row query of PostgreSQL Blob

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 3.0M1, 3.0
    • Core Library
    • None
    • PostgreSQL oid blob

    Description

      Using PostgreSQL oid blob, the PostgreSQL jdbc driver does not know if the oid is a blob or not. The user must issue getBlob to return the blob. getObject will return an Integer with the oid value.

      select imagedata from person (where imagedata is a oid blob column)

      does return an Integer. I guess this is okay as the jdbc driver are not able to provide the Blob as the jdbc type and ResultSet.getObject returns an Integer.

      select #result('imagedata' 'java.sql.Blob' 'imagedata') from person

      does also return an Integer, but should return an Blob.

      Attachments

        Activity

          People

            halset Tore Halset
            halset Tore Halset
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: