FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categoriescayenne
postedNov 26, '06 at 12:06a
activeNov 26, '06 at 12:06a
posts1
users1
websitecayenne.apache.org

1 user in discussion

Tore Halset (JIRA): 1 post

People

Translate

site design / logo © 2022 Grokbase