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
