[JIRA] Created: (CAY-711) SQLTemplate data row query of PostgreSQL Blob

From: Tore Halset (JIRA) ("Tore)
Date: Sat Nov 25 2006 - 19:06:04 EST

  • Next message: Tore Halset: "Re: [JIRA] Updated: (CAY-316) stream support for blob/clob"

    SQLTemplate data row query of PostgreSQL Blob
    ---------------------------------------------

             Key: CAY-711
             URL: http://issues.apache.org/cayenne/browse/CAY-711
         Project: Cayenne
            Type: Improvement

      Components: Cayenne Core Library
     Environment: PostgreSQL oid blob
        Reporter: Tore Halset
     Assigned to: Tore Halset
        Priority: Minor
         Fix For: 3.0

    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. 

    -- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/cayenne/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

    This archive was generated by hypermail 2.0.0 : Sat Nov 25 2006 - 19:06:52 EST