Thanks Scott. What's the best way to get familiar with SPARQL? Coming from the relational world (SQL Server) this is a bit of a different concept. We are currently evaluating this product for use on a project now. Of course I needed the knowledge yesterday! :)
On May 20, 11:24 am, Scott Henninger <[email protected]> wrote: > Mark; Yes, this is the best way to proceed. The D2RQ wizard in TBC > will get the full schema from the database. This itself is a bit of > an issue and we are looking to improve on this. It wouldn't be > expected that D2RQ will make sense of blob columns, but the TBC > behavior should admittedly be better about letting you know where the > problem occurs. > > So for now the best practice is to run the wizard and edit the mapping > model in Composer. It is an RDF file and the key mappings are > instances of d2rq:ClassMap and d2rq:PropertyBridge, both subclasses > of d2rq:ResourceMap. You can also manipulate these properties of > these instances to change the format of the label (primary keys are > often used), create join tables, etc. The Composer D2RQ Help page > points to the reference for the D2RQ mapping language that is used in > the mapping model created by the wizard. > > -- Scott > > On May 20, 7:32 am, Mark <[email protected]> wrote: > > > > > > > > > I just removed it from the mapping and schema files and it appears to > > be working. Is this the best way though? I don't need these columns in > > my Ontology so maybe this is? > > > On May 20, 8:26 am, Mark <[email protected]> wrote: > > > > Yes, thank you. After looking thru the log file more carefully it is > > > erroring out on a column that has the image datatype. What is the > > > best way around this error? Can I just remove these columns from the > > > schema and mapping file? Do I have to make a view to the table and > > > remove this column? > > > > On May 19, 4:56 pm, David Price <[email protected]> wrote: > > > > > This kind of error is often caused because there's a column datatype in > > > > a table being opened that D2RQ does not support. The details in the > > > > (Window, Show View) Error Log often explain the problem in more detail. > > > > > Cheers, > > > > David > > > > > On 5/19/2011 8:20 PM, Gokhan Soydan wrote: > > > > > > Mark, > > > > > > Can you open the Mapping or the Schema ontologies on their own? > > > > > > Gokhan > > > > > > On 5/19/2011 7:30 AM, Mark wrote: > > > > >> Hi Gokhan, > > > > > >> Yes, I used the Create Mapping files for D2RQ Relational Database > > > > >> option on import. I did not get an error on creating the import file > > > > >> and nothing in the error log. However when I load the -Test.rdf file > > > > >> I get the following error: > > > > > >> Operation failed. > > > > > >> On: May 19, 2011 10:23:42 AM > > > > > >> Reason: > > > > >> org.topbraidcomposer.core.io.FailedImportException: The following > > > > >> URIs > > > > >> could not be imported:<http://datamining.org/ProChain-Test.owl> > > > > > >> at > > > > >> org.topbraidcomposer.core.io.TBCIO.loadImportedModels(TBCIO.java: > > > > >> 225) > > > > > >> at org.topbraidcomposer.core.io.TBCIO$2$1.run(TBCIO.java:310) > > > > > >> at java.lang.Thread.run(Unknown Source) > > > > > >> Let me know if there's anything I can supply. > > > > > >> Thanks, > > > > >> Mark > > > > > >> On May 18, 4:51 pm, Gokhan Soydan<[email protected]> wrote: > > > > >>> Mark, > > > > > >>> Did you use "Create Mapping Files for D2RQ Relational Database > > > > >>> Interface" wizard of TopBraid Composer? Did you get any exception in > > > > >>> the > > > > >>> Error Log? Could you send the exception? > > > > > >>> Gokhan > > > > > >>> On 5/18/2011 12:00 PM, Mark wrote: > > > > > >>>> Hi new to TopBraid and running into a problem importing a SQL > > > > >>>> server > > > > >>>> database. From what I understand each table must have a primary > > > > >>>> key or > > > > >>>> a unique key. In the database I'm importing, each of the tables > > > > >>>> has a > > > > >>>> primary key several have foreign keys. It appears to import > > > > >>>> correctly, > > > > >>>> a mapping file, schema file all get created without errors... But > > > > >>>> when > > > > >>>> I go to load the test file to run some queries against I receive an > > > > >>>> error that it cannot load the mapping file and something about > > > > >>>> untyped > > > > >>>> data in an import file. If I look at the import tab it has not > > > > >>>> imported the mapping file. Anyone run into this? > > > > > -- > > > > Managing Director and Consultant > > > > TopQuadrant Limited. Registered in England No. 05614307 > > > > UK +44 7788 561308 > > > > US +1 336-283-0606 -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. 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-users?hl=en
