Kai, can you try whether you have better luck with this version?
http://download.d2rq.org/d2rq-r2rml-preview-v4.tar.gz
Best,
Richard
> On 8 Jan 2014, at 22:25, Kai Hackemesser <kai.hackemes...@gmail.com> wrote:
>
> Hello,
>
> I am fresh starting with d2rq V0.8.1. I am currently working myself through
> http://d2rq.org/getting-started and try to create a mapping file using
> http://d2rq.org/generate-mapping . The target SQL server is a MS SQL Server
> 2008 instance. The target tables are in the dbo schema. The output is a bit
> frustrating. First I get warnings on generation:
>
> 11:23:10 INFO generate_mapping :: Writing to mapping.ttl
> 11:23:10 INFO ConnectedDB :: Establishing JDBC connection to
> jdbc:jtds:sqlserver://devsql03:1433
> 11:23:11 INFO ConnectedDB :: JDBC database product type: Microsoft
> SQL Server
> 11:23:11 INFO ConnectedDB :: Using vendor class:
> de.fuberlin.wiwiss.d2rq.sql.vendor.SQLServer
> 11:23:11 INFO MappingGenerator :: Generating d2rq:Database instance
> 11:23:11 INFO MappingGenerator :: Filter 'exclude(table(/dbo.spt_.*/0))'
> matches 5 total tables
> 11:23:11 INFO MappingGenerator :: Generating d2rq:ClassMap instance for
> table dbo.spt_fallback_db
> 11:23:11 WARN MappingGenerator :: Sorry, I don't know which columns to
> put into the uriPattern
> 11:23:11 WARN MappingGenerator :: for "dbo.spt_fallback_db" because
> the table doesn't have a primary key.
> 11:23:11 WARN MappingGenerator :: Please specify it manually.
> 11:23:11 INFO MappingGenerator :: Generating d2rq:ClassMap instance for
> table dbo.spt_fallback_dev
> 11:23:11 WARN MappingGenerator :: Sorry, I don't know which columns to
> put into the uriPattern
> 11:23:11 WARN MappingGenerator :: for "dbo.spt_fallback_dev" because
> the table doesn't have a primary key.
> 11:23:11 WARN MappingGenerator :: Please specify it manually.
> 11:23:11 INFO MappingGenerator :: Generating d2rq:ClassMap instance for
> table dbo.spt_fallback_usg
> 11:23:11 WARN MappingGenerator :: Sorry, I don't know which columns to
> put into the uriPattern
> 11:23:11 WARN MappingGenerator :: for "dbo.spt_fallback_usg" because
> the table doesn't have a primary key.
> 11:23:11 WARN MappingGenerator :: Please specify it manually.
> 11:23:11 INFO MappingGenerator :: Generating d2rq:ClassMap instance for
> table dbo.spt_monitor
> 11:23:11 WARN MappingGenerator :: Sorry, I don't know which columns to
> put into the uriPattern
> 11:23:11 WARN MappingGenerator :: for "dbo.spt_monitor" because the
> table doesn't have a primary key.
> 11:23:11 WARN MappingGenerator :: Please specify it manually.
> 11:23:11 INFO MappingGenerator :: Generating d2rq:ClassMap instance for
> table dbo.spt_values
> 11:23:11 WARN MappingGenerator :: Sorry, I don't know which columns to
> put into the uriPattern
> 11:23:11 WARN MappingGenerator :: for "dbo.spt_values" because the
> table doesn't have a primary key.
> 11:23:11 WARN MappingGenerator :: Please specify it manually.
> 11:23:11 INFO MappingGenerator :: Done!
> 11:23:11 INFO ConnectedDB :: Closing connection to
> jdbc:jtds:sqlserver://devsql03:1433
>
> I have seen a mailing list entry from 2009 that mentioned this, but it didn't
> help further. The main problem is that the produced mappings.ttl file
> contains only these spt_* entries, not any of the actual user tables. Ho can
> I get past this?
>
> Cheers,
> Kai
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> d2rq-map-devel mailing list
> d2rq-map-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
