As far as I can tell in SQL Server Mgmt Studio, all of the foreign keys in these tables are explicitly defined. I've imported another SQL Server database (smaller, with fewer foreign keys defined) that seems to import OK.
What's the ETA on the upcoming release that includes the updated D2RQ? There's probably no need in me spending too much time debugging if this is likely fixed in the new release. Thanks, Chris On Oct 9, 12:03 pm, Scott Henninger <[email protected]> wrote: > Yes, the version of D2RQ in Composer 3.1 requires that foreign key > relationships are explicitly defined. You can try making those > definitions in SQL Server to see if that works. > > -- Scott > > On Oct 9, 10:49 am, Holger Knublauch <[email protected]> wrote: > > > Ah, this is a known bug in that particular D2RQ version. They have > > thankfully fixed it and the new version will be part of the upcoming > > TBC release. As far as I remember there is a work-around (it had to do > > with the way that foreign keys are handled). I think you can modify > > the mapping file to prevent this error from happening. You may want to > > ask the D2RQ mailing list for details. Or just wait for the next > > release. > > > Holger > > > On Oct 9, 2009, at 6:29 AM, Chris wrote: > > > > The mappings appear to be OK from what I can tell after cleaning out > > > all of the > > > unnecessary entries. I should have been paying more attention to the > > > import error log > > > when loading the x-Test.owl file. > > > > The exception from the 'Failed to import' entry: > > > > java.lang.ClassCastException: de.fuberlin.wiwiss.d2rq.sql.ResultRow$1 > > > cannot be cast to com.hp.hpl.jena.graph.Triple > > > at org.topbraid.core.graph.CachingGraph.addToCache(CachingGraph.java: > > > 213) > > > at org.topbraid.core.graph.CachingGraph.find(CachingGraph.java:306) > > > at org.topbraid.core.graph.CachingGraph.find(CachingGraph.java:297) > > > at org.topbraid.core.graph.CachingGraph.rebuildCache > > > (CachingGraph.java:472) > > > at org.topbraid.core.registry.impl.GraphRegistry.register > > > (GraphRegistry.java:277) > > > at org.topbraidcomposer.core.io.TBCIO.loadModel(Unknown Source) > > > at org.topbraidcomposer.core.io.TBCIO.loadImportedModels(Unknown > > > Source) > > > at org.topbraidcomposer.core.io.TBCIO.loadImportedModels(Unknown > > > Source) > > > at org.topbraidcomposer.core.io.TBCIO$1$1.run(Unknown Source) > > > at java.lang.Thread.run(Unknown Source) > > > > Is this telling me that TBC is having trouble loading or that D2RQ is > > > having trouble > > > with the data itself? How might I track down exactly where in the > > > process that > > > it's bombing out? Are there detailed logs I can turn on somewhere in > > > TBC? > > > > Thanks, > > > Chris > > > > On Oct 7, 12:08 pm, Scott Henninger <[email protected]> > > > wrote: > > >> Chris; the .owlinf file will store the inference graph if you choose > > >> to do that. The -Test.owl file will hold the instance data from the > > >> RDB. > > > >> If the mappings aren't quite right, you can modify the mapping model. > > > >> -- Scott > > > >> On Oct 7, 10:59 am, Chris W <[email protected]> wrote: > > > >>> Per Scott's suggestion to David in an earlier post, I'm trying out > > >>> the > > >>> D2RQ/jTDS/SQLServer config. The import seems to go well. I see the > > >>> proper d2rq, mapping, schema, and test files; they contain proper > > >>> ontologies for the database that I'm connecting to. However, an > > >>> xxx- > > >>> Test.owl.owlinf is never generated and it doesn't appear to be > > >>> querying the database for instances of the classes when I go look > > >>> for > > >>> those. > > > >>> Just to test the data, I exported everything to MySQL using the > > >>> MySQL > > >>> Migration Tool which works like a charm, BTW. Highly recommended. > > >>> Found that > > >>> athttp://stackoverflow.com/questions/129/how-to-export-data-from-sql-se > > >>> .... > > >>> I ran the D2RQ import on that with JDBC and all is well. > > > >>> So I have a working solution, but I'd really like to figure out > > >>> how to > > >>> talk to that native SQL Server DB. I realize this is very likely > > >>> not > > >>> a TBC problem, per se, but the experts seem to be here, so I thought > > >>> I'd post the issue. Any suggestions on where I could troubleshoot? > > >>> User/passwd that I'm using is the database owner, and it's getting > > >>> the > > >>> database tables info, so it doesn't seem to be a connection problem. > > >>> Could it just be a SQL Server glitch? An issue with the jTDS > > >>> driver? > > > >>> Thanks, > > >>> Chris > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TopBraid Composer Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-composer-users?hl=en -~----------~----~----~----~------~----~------~--~---
