Diogo, I dug a bit deeper and fixed the underlying problem, both on the master and on the develop branch.
The issue was this: When we have a SQL table or SQL result with a column of type BOOL, then the The PostgreSQL JDBC driver reports the type of that column as BIT(1), but the values in the column will still be "t" and "f" as in PostgreSQL. This confused D2RQ, which expects BIT(1) columns to actually contain bit strings. As a result, any value of such a column ended up being interpreted as true. The fix: When on PostgreSQL, we now inspect the reported JDBC type name for BIT columns. If it is "BOOL", then we know that the column is actually of a boolean type, and treat it as such. So I recommend that you get the latest version of the "master" branch (if you use SPARQL) or of the "develop" branch (if you only use dump-rdf) from git, and build it. If you're not set up to get code from git and build it yourself, then just let me know, and I'll upload a build somewhere for you. Best, Richard On 21 Sep 2013, at 19:10, Richard Cyganiak <rich...@cyganiak.de> wrote: > Hi Diogo, > > I've been able to reproduce the problem. It's an issue with the > interpretation of boolean results in D2RQ v0.8.1. The issue has been fixed on > the develop branch as part of the engine re-implementation, but the problem > is still present on the master branch. > > For now, I recommend you use the R2RML preview build, which is a snapshot of > the develop branch: > http://download.d2rq.org/d2rq-r2rml-preview-v4.tar.gz > > It fixes this particular problem, and dump-rdf is reliable on develop. I > don't recommend this version for use with SPARQL yet. > > (In your mapping, where it has dtnasc, you probably meant rhc.dtnasc?) > > Best, > Richard > > > On 20 Sep 2013, at 20:55, Diogo FC Patrao <djogopat...@gmail.com> wrote: > >> Hi Richard, >> >> Have my mapping cleared something? >> >> If you need anything else, let me know. >> >> Thanks, >> >> -- >> diogo patrão >> >> >> >> >> On Tue, Sep 17, 2013 at 9:00 AM, Diogo FC Patrao <djogopat...@gmail.com> >> wrote: >> Hi Richard >> >> I'm providing a minimal example of a problematic map and there you go - two >> classmaps. >> >> If I dump-rdf the mapping below, I get 36086 instances of both classes >> vocab:PacienteMaiorDe18Anos and vocab:Quimioterapia; however, if I comment >> out the first mapping (map:18a), I end up with 10625 instances of >> vocab:Quimioterapia. Which is correct. When I use the same mapping on >> D2R-server, and run a SELECT count(*) on each class, I got 36086 for >> PacienteMaiorDe18Anos and 10625 for Quimioterapia. >> >> I thought that it would get the first class map instances and apply the >> other classes to all of them. However, if I swap the order, I get the same >> results as above. >> >> Let me know if you need further details. >> >> dfcp >> >> >> @prefix map: <#> . >> @prefix db: <> . >> @prefix vocab: >> <http://www.cipe.accamargo.org.br/ontologias/estudo_clinico.owl#> . >> @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> . >> @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . >> @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . >> @prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> . >> @prefix d2r: >> <http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/config.rdf#> . >> @prefix jdbc: <http://d2rq.org/terms/jdbc/> . >> >> >> <> a d2r:Server; >> rdfs:label "rhc"; >> d2r:sparqlTimeout 0; >> d2r:port 2024; >> . >> >> >> map:database a d2rq:Database; >> d2rq:jdbcDriver "org.postgresql.Driver"; >> d2rq:jdbcDSN "jdbc:postgresql://localhost/bancos_clinicos"; >> d2rq:username "whatever"; >> d2rq:password "whatever"; >> jdbc:autoReconnect "true"; >> jdbc:zeroDateTimeBehavior "convertToNull"; >> . >> >> # >> # >> # >> map:18a a d2rq:ClassMap; >> d2rq:dataStorage map:database; >> d2rq:uriPattern >> "http://www.cipe.accamargo.org.br/ontologias/estudo_clinico.owl#paciente/@@rhc.rgh_mv@@";; >> d2rq:class vocab:PacienteMaiorDe18Anos; >> d2rq:containsDuplicates "true"; >> d2rq:condition "dtnasc < now() - interval '18 year'"; >> . >> >> map:qt a d2rq:ClassMap; >> d2rq:dataStorage map:database; >> d2rq:uriPattern >> "http://www.cipe.accamargo.org.br/ontologias/estudo_clinico.owl#paciente/@@rhc.rgh_mv@@";; >> d2rq:class vocab:Quimioterapia; >> d2rq:containsDuplicates "true"; >> d2rq:condition "rhc.quimio like '1%'"; >> . >> >> >> >> >> -- >> diogo patrão >> >> >> >> >> On Tue, Sep 10, 2013 at 2:37 PM, Diogo FC Patrao <djogopat...@gmail.com> >> wrote: >> Yes, 0.8.1. >> >> -- >> diogo patrão >> >> >> >> >> On Tue, Sep 10, 2013 at 2:33 PM, Richard Cyganiak <rich...@cyganiak.de> >> wrote: >> On 10 Sep 2013, at 18:27, Diogo FC Patrao <djogopat...@gmail.com> wrote: >>> For the record, I have the same database in MySQL as well, with the same >>> structure, and rdf-dump went well with the same mappings. >> >> That's interesting. Off the top of my head I can't think of any reason why >> this would be happening. >> >> I assume this is v0.8.1? >> >> Richard >> >> >> >>> >>> Cheers, >>> >>> -- >>> diogo patrão >>> >>> >>> >>> >>> On Tue, Sep 10, 2013 at 2:25 PM, Richard Cyganiak <rich...@cyganiak.de> >>> wrote: >>> On 10 Sep 2013, at 17:39, Diogo FC Patrao <djogopat...@gmail.com> wrote: >>>> Anyone have any thoughts on that? >>> >>> Something funky going on in the mapping? Accidentally overlapping URI >>> patterns? It's very hard to say without additional details. I doubt that it >>> has anything to do with the use of PostgreSQL. >>> >>> Try removing stuff from the mapping until you have a minimal mapping that >>> shows the problem. >>> >>> Best, >>> Richard >>> >>> >>>> >>>> -- >>>> diogo patrão >>>> >>>> >>>> >>>> >>>> On Fri, Sep 6, 2013 at 4:24 PM, Diogo FC Patrao <djogopat...@gmail.com> >>>> wrote: >>>> Hello >>>> >>>> I'm trying to dump a postgresql database with dump-rdf, however the >>>> generated RDF maps all instances to all classes at the same time. >>>> >>>> Anyone having the same problem? >>>> >>>> -- >>>> diogo patrão >>>> >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> How ServiceNow helps IT people transform IT departments: >>>> 1. Consolidate legacy IT systems to a single system of record for IT >>>> 2. Standardize and globalize service processes across IT >>>> 3. Implement zero-touch automation to replace manual, redundant tasks >>>> http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk_______________________________________________ >>>> d2rq-map-devel mailing list >>>> d2rq-map-devel@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel >>> >>> >>> ------------------------------------------------------------------------------ >>> How ServiceNow helps IT people transform IT departments: >>> 1. Consolidate legacy IT systems to a single system of record for IT >>> 2. Standardize and globalize service processes across IT >>> 3. Implement zero-touch automation to replace manual, redundant tasks >>> http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk_______________________________________________ >>> d2rq-map-devel mailing list >>> d2rq-map-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel >> >> >> >> >> ------------------------------------------------------------------------------ >> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! >> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint >> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack >> includes >> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. >> http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk_______________________________________________ >> d2rq-map-devel mailing list >> d2rq-map-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel > > > ------------------------------------------------------------------------------ > LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! > 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint > 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes > Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. > http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk > _______________________________________________ > d2rq-map-devel mailing list > d2rq-map-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel ------------------------------------------------------------------------------ LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk _______________________________________________ d2rq-map-devel mailing list d2rq-map-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
