SQLTemplate data row query of PostgreSQL Blob

• Key: CAY-711
• Type: Improvement
• Status: Closed
• Resolution: Fixed
• Priority: Minor
• Assignee: Tore Halset
• Reporter: Tore Halset
• Component/s: Cayenne Core Library
• Fix Version/s: 3.0M1

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.