Thanks Martin, that did the trick!
I tried to put a d2rq:datatype string in there, but uriSqlExpression won't
let me.
Really thanks!
--
diogo patrão
On Thu, Apr 11, 2013 at 10:05 AM, "Martin G. Skjæveland" <mart...@ifi.uio.no
> wrote:
> Hi Diogo,
>
> not having really understood you problem, however, have you tried to
> cast the value to CHAR? I think I had similiar results as you which were
> fixed by casting to CHAR, in my code:
>
> d2rq:sqlExpression "Cast(AsText(apaAreaGross.apaAreaGeometryEWKT) AS
> char)" .
>
> (AsText is a function to convert geometrics to text.)
>
> Martin
>
> On 11/04/13 14:53, Diogo FC Patrao wrote:
> > More info; The mapping below is working perfectly. To me it sounds like
> > a problem with uriSqlExpression,what do you think?
> >
> > map:documentAuthor1 a d2rq:PropertyBridge;
> > d2rq:belongsToClassMap map:Document;
> > d2rq:property :documentAuthor;
> > d2rq:refersToClassMap map:User1;
> > d2rq:condition "users.universal_id is not null";
> > d2rq:join "documents.responsible = users.user_id";
> > .
> >
> > map:documentAuthor2 a d2rq:PropertyBridge;
> > d2rq:belongsToClassMap map:Document;
> > d2rq:property :documentAuthor;
> > d2rq:refersToClassMap map:User2;
> > d2rq:condition "users.universal_id is null";
> > d2rq:join "documents.responsible = users.user_id";
> > .
> >
> > map:User1 a d2rq:ClassMap;
> > d2rq:dataStorage map:Database;
> > d2rq:class :User;
> > d2rq:condition "users.universal_id is not null";
> > d2rq:uriPattern
> > "
> http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#usersUNIV@@users.universal_id@@
> ";
> > .
> >
> > map:User2 a d2rq:ClassMap;
> > d2rq:dataStorage map:Database;
> > d2rq:class :User;
> > d2rq:condition "users.universal_id is null";
> > d2rq:uriPattern
> > "
> http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#usersEHR@@users.user_id@@
> ";
> > .
> >
> >
> >
> > --
> > diogo patrão
> >
> >
> >
> >
> > On Thu, Apr 11, 2013 at 9:40 AM, Diogo FC Patrao <djogopat...@gmail.com
> > <mailto:djogopat...@gmail.com>> wrote:
> >
> > Hi Richard
> >
> > Did another couple of tests and the problem is not really related to
> > SERVICE.
> >
> > This time, I issued the following query directly to D2R-Server:
> >
> > SELECT * WHERE { ?document
> > <http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#documentAuthor>
> ?author
> > . } limit 5
> >
> > The results for ?author are still hex-coded. However, take a look on
> > map:documentAuthor:
> >
> > map:documentAuthor a d2rq:PropertyBridge;
> > d2rq:belongsToClassMap map:Document;
> > d2rq:property :documentAuthor;
> > #d2rq:refersToClassMap map:User;
> > d2rq:join "documents.responsible = users.user_id";
> > d2rq:uriSqlExpression
> > "CONCAT('http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#users
> ',if(
> > users.universal_id is null, concat('EHR',users.user_id),
> > concat('UNIV',users.universal_id) ) )";
> > .
> >
> > Does this point to something?
> >
> > thanks!
> >
> >
> >
> >
> > --
> > diogo patrão
> >
> >
> >
> >
> > On Wed, Apr 10, 2013 at 1:33 PM, Richard Cyganiak
> > <rich...@cyganiak.de <mailto:rich...@cyganiak.de>> wrote:
> >
> > --debug should print the query that ARQ sent. Run that query
> > yourself in D2RQ. And I'm pretty sure it's either Joseki or ARQ
> > messing up the result, and both are Jena products :-)
> >
> > Richard
> >
> >
> > On 10 Apr 2013, at 14:12, Diogo FC Patrao <djogopat...@gmail.com
> > <mailto:djogopat...@gmail.com>> wrote:
> >
> >> BTW2, how can I be sure that those results are coming out of
> >> D2R or are being messed up by ARQ client? I turned on --debug
> >> on my d2r-server, however it won print results.
> >>
> >> Thanks again
> >>
> >> --
> >> diogo patrão
> >>
> >>
> >>
> >>
> >> On Wed, Apr 10, 2013 at 10:10 AM, Diogo FC Patrao
> >> <djogopat...@gmail.com <mailto:djogopat...@gmail.com>> wrote:
> >>
> >> Hi Richard
> >>
> >> I'm writing to them right now. Are you in that list too?
> >>
> >> BTW, Arq is in 2.10.1 version right now; do you think D2R
> >> 0.8.1 would work with that version?
> >>
> >> Thanks
> >>
> >> --
> >> diogo patrão
> >>
> >>
> >>
> >>
> >> On Wed, Apr 10, 2013 at 3:18 AM, Richard Cyganiak
> >> <rich...@cyganiak.de <mailto:rich...@cyganiak.de>> wrote:
> >>
> >> Off the top of my head I can't think of a reason why
> >> this might be happening. I suggest you also try asking
> >> on the Jena list, mentioning that the D2R endpoint
> >> uses the Joseki server code.
> >>
> >> Richard
> >>
> >>
> >> On 9 Apr 2013, at 21:59, Diogo FC Patrao
> >> <djogopat...@gmail.com <mailto:djogopat...@gmail.com>>
> >> wrote:
> >>
> >>> Hello
> >>>
> >>> I noticed a strange effect happening when I issue the
> >>> following query:
> >>>
> >>> SELECT DISTINCT *
> >>> WHERE
> >>> {
> >>> SERVICE <http://0.0.0.0:2020/sparql> { ?document
> >>> <
> http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#documentType>
> >>>
> >>> "exam request" . }
> >>> SERVICE <http://0.0.0.0:2020/sparql> { ?document
> >>> <
> http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#documentAuthor>
> >>>
> >>> ?author . }
> >>> }
> >>> 0.0.0.0:2020/sparql <http://0.0.0.0:2020/sparql>
> >>> points to a d2r-server instance. This query was
> >>> issued not directly to this instance, but rather by a
> >>> command line ARQ over an empty graph.
> >>>
> >>> This query is part of a bigger query that refers to
> >>> several d2r-server instances, and I know that I could
> >>> join both of them in one SERVICE only for
> >>> optimization, but that's not the point.
> >>>
> >>> The point is, instead of getting proper URIs for
> >>> ?author, I'm getting those huge hex data, like
> >>>
> >>>
> <687474703A2F2F7777772E636970652E616363616D6172676F2E6F72672E62722F6F6E746F6C6F676961732F683274632E6F776C237573657273554E495636363837353234353636>
> >>>
> >>> Interestingly enough, converting consecutive pairs of
> >>> those bytes to chars, it turns into a URI!
> >>>
> >>>
> http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#usersUNIV6687524566
> >>>
> >>> Which is a valid answer to ?author.
> >>>
> >>> I have verified that a query without those SERVICE
> >>> keywords works perfectly, when issued directly to
> >>> D2R-server.
> >>>
> >>>
> >>> I'm not really sure whose fault is this, ARQ or D2R.
> >>>
> >>> Any help in order to get things straight will be
> >>> appreciated.
> >>>
> >>> Thanks,
> >>>
> >>>
> >>>
> >>>
> >>> --
> >>> diogo patrão
> >>>
> >>>
> >>>
> ------------------------------------------------------------------------------
> >>> Precog is a next-generation analytics platform
> >>> capable of advanced
> >>> analytics on semi-structured data. The platform
> >>> includes APIs for building
> >>> apps and a phenomenal toolset for data science.
> >>> Developers can use
> >>> our toolset for easy data analysis & visualization.
> >>> Get a free account!
> >>>
> http://www2.precog.com/precogplatform/slashdotnewsletter
> >>> _______________________________________________
> >>> d2rq-map-devel mailing list
> >>> d2rq-map-devel@lists.sourceforge.net
> >>> <mailto:d2rq-map-devel@lists.sourceforge.net>
> >>>
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
> >>
> >>
> >>
> >
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Precog is a next-generation analytics platform capable of advanced
> > analytics on semi-structured data. The platform includes APIs for
> building
> > apps and a phenomenal toolset for data science. Developers can use
> > our toolset for easy data analysis & visualization. Get a free account!
> > http://www2.precog.com/precogplatform/slashdotnewsletter
> >
> >
> >
> > _______________________________________________
> > d2rq-map-devel mailing list
> > d2rq-map-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
> >
>
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> d2rq-map-devel mailing list
> d2rq-map-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
>
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
