[#CAY-711] SQLTemplate data row query of PostgreSQL Blob

Cayenne

SQLTemplate data row query of PostgreSQL Blob

Created: 26/Nov/06 12:05 AM Updated: 09/Nov/08 01:14 AM

Return to search

Component/s:

Cayenne Core Library

Affects Version/s:

None

Fix Version/s:

3.0M1

Time Tracking:

Not Specified

Environment:

PostgreSQL oid blob

Resolution Date:

26/Nov/06 12:20 AM

Description

« Hide

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.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Repository	Revision	Date	User	Message
ASF	#479241	Sun Nov 26 00:18:33 UTC 2006	torehalset	~~CAY-711~~: SQLTemplate data row query of PostgreSQL Blob
				Files Changed
				MODIFY /incubator/cayenne/main/trunk/core/cayenne-jdk1.4/src/main/java/org/apache/cayenne/access/types/DefaultType.java MODIFY /incubator/cayenne/main/trunk/core/cayenne-jdk1.4/src/main/java/org/apache/cayenne/dba/TypesMapping.java

[ Permlink | « Hide ]

Tore Halset added a comment - 26/Nov/06 12:20 AM

Checked in an improvement to DefaultType that handles Blob as a specific type. This makes "select #result('imagedata' 'java.sql.Blob' 'imagedata') from person" work on PostgreSQL.

Tore Halset made changes - 26/Nov/06 12:20 AM

Field	Original Value	New Value
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]

[ Permlink | « Hide ]

Andrus Adamchik added a comment - 08/Jul/07 06:16 PM

bulk-closing resolved trunk issues

Andrus Adamchik made changes - 08/Jul/07 06:16 PM

Status

Resolved [ 5 ]

Closed [ 6 ]

Ari Maniatis made changes - 09/Nov/08 01:14 AM

Fix Version/s		3.0M1 [ 10124 ]
Fix Version/s	3.0 [ 10091 ]

Henri Yandell made changes - 21/Mar/09 07:51 AM

Project Import

Sat Mar 21 00:51:04 PDT 2009 [ 1237621864637 ]