CODEWITHSUNDEEP
db2rdfsparqljena
GML-VS
GML-VS

Reputation: 1100

DB2 v.10.1 RDF data deletion

Have anybody tried to remove data(triples) from the DB2 RDF simple store(Windows)? (INSERT works fine)

SPARQL DELETE statament:

DELETE { ?document ?property ?value} WHERE{ ?document <http://example.com#begin> 
?begin . 
FILTER(?begin > 200) ?document ?property ?value }

I've got the following exception:

com.ibm.rdf.store.exception.RdfStoreException: DB255006E ERRORCODE=-4499, SQLSTATE=08001. SQLSTATE: 08001.
 at  
com.ibm.rdf.store.internal.jena.impl.update.SingleTripleOperations.removeQuad(Unknown Source)
at com.ibm.rdf.store.internal.jena.impl.update.AbstractTripleOperation.removeQuad(Unknown Source)
.....

db2diag.log:

RETCODE : ZRC=0x87120007=-2028863481=SQLR_SEVERE_PGM_ERROR
"Severe programming error"
DIA8516C A severe internal processing error has occurred.

My Java code:

String queryString = "delete ...";
Dataset ds = RdfStoreFactory.connectDataset(storeP, conn);
GraphStore graphStore = GraphStoreFactory.create(ds) ;
UpdateAction.parseExecute(queryString, graphStore); // exception

 //UpdateAction.parseExecute("DROP ALL", graphStore); // works fine

Thanks!

Upvotes: 0

Views: 463

Answers (1)

GML-VS
GML-VS

Reputation: 1100

The problem solved by adding 

    prop.setProperty("enableExtendedIndicators", "2");

to the DB2 connection.

Upvotes: 1

Related Questions