Special characters in SQL Query in R2RML

Support
1

Stardog server 5.0.5

jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc driver: sqljdbc42-6.0.8112.100.jar

Having in my R2RML Mapping in the SQL query (rr:sqlQuery “”" “”"; ) special characters

example 1: ~
SELECT a.ObjectId, ~a.Officieus as officieelToegekend
FROM [Adres] a

example 2: ^
SELECT a.ObjectId, 1 ^ a.Officieus as officieelToegekend
FROM [Adres] a

Both queries work outside of stardog.

In stardog:
Unable to parse R2RML view query [[SELECT a.ObjectId, ~a.Officieus as officieelToegekend FROM [Adres] a]]: Lexical error at line 1, column x. Encountered: “~” (126), after : “”

Unable to parse R2RML view query [[SELECT a.ObjectId, 1 ^ a.Officieus as officieelToegekend FROM [Adres] ]]: Encountered “^” at line 1, column x.

Any special encoding or escaping to do?

1 Like
2

Meanwhile found a solution

case Officieus WHEN 'true' THEN 'false' WHEN 'false' then 'true' END as officieelToegekend

3

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.