d2rq/d2rq — Issue #115: LOB Types support
Author: aftiqb
Created: 2012-03-08 20:25:27+00:00
State: open

Handling LOB types is a bit tricky as we run into an issue while querying the database using literal value for LOB type. Inserting literal values as LOB type is fine but querying LOB type using literal values throws exception. For example,

ORA-00932: inconsistent datatypes: expected - got BLOB
: SELECT DISTINCT "SCOTT"."TBL_BLOB"."ID" FROM "SCOTT"."TBL_BLOB" WHERE "SCOTT"."TBL_BLOB"."BLOBFIELD" = 'E324DFDEE32323DEE3540D5371126F' (E0)

Querying LOB Types from SPARQL doesn't look pretty straight-forward. Because we do not know the column type while transforming SPARQL query into an SQL query. We will require to test and verify LOB types on all supported Databases