Hi Richard
Now I'm able to dump data correctly. Thanks a lot!
--
diogo patrão
On Wed, Sep 25, 2013 at 4:58 AM, Richard Cyganiak <rich...@cyganiak.de>wrote:
> On 24 Sep 2013, at 23:06, Kārlis Čerāns <karlis.cer...@lumii.lv> wrote:
> > would it be possible to get the latest version of the "master" branch
> for Windows, if it is going to appear somewhere?
>
> I've built a snapshot and made it available for download:
> http://download.d2rq.org/d2rq-master-snapshot-20130925.zip
>
> (I've not tested it at all, so let me know if something is horribly broken
> with the build.)
>
> > We are currently using r2rml preview version in our development, not for
> reason of r2rml but rather due to some bugs present in 0.8.1. re property
> discriminated subclasses (on MS SQL Server); something along the lines of
> https://github.com/d2rq/d2rq/issues/154 (r2rml preview works fine in our
> case).
>
> Yes, this issue was fixed on both branches, and both for SQL Server and
> Oracle.
>
> Best,
> Richard
>
>
> >
> > Thanks,
> > Karlis Cerans
> >
> > On 22.09.2013 18:59, Richard Cyganiak wrote:
> >> 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
> >>
>
>
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
