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
