|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
PostgreSQL oid blob
|
|
| Resolution Date: |
26/Nov/06 12:20 AM
|
|
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.
|
|
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.
|
Show » |
|
Improvement
Closed
Minor
SQLTemplate data row query of PostgreSQL Blob
