3 Replies Latest reply on May 28, 2009 7:26 PM by alwu-Oracle

    Single quote in SPARQL query


      I have a SPARQL query with a clause like (?affy gb:bioprocess "3\'-phosphoadenosine" .). Oracle Jena adapter translates it into
      sdo_rdf_match('(?affy <gb#bioprocess> "3\'||chr(39)||'-phosphoadenosine")..., which throws the following error when executing the query:
      java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java exception: oracle.spatial.rdf.server.TokenMgrError: Lexical error at line 1, column 50. Encountered: "\'" (39), after : "\"3\\"
      ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 169
      ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 35
      ORA-06512: at line 4

      What does Oracle Jena adapter expect if the SPARQL query has single quote in the literal value? Thanks,