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:
For more information on JIRA, see:

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
postedNov 26, '06 at 12:06a
activeNov 26, '06 at 12:06a

1 user in discussion

Tore Halset (JIRA): 1 post



site design / logo © 2022 Grokbase