Derek; So we're on the same page now. Most likely the issue is that you are unable to create the connection with Oracle. If you were able to create the connection (the Import... D2RQ...), then there are problems with Oracle access rights or the file does not exist as specified in the Import step.
In terms of schema vs. data, the d2rq wizard separates these by making a -Schema file to hold the schema. The -Test file imports the schema and access all of the data. So the wizard will map both schema and data. -- Scott On Apr 6, 10:27 am, Derek S <[email protected]> wrote: > Hi Scott, > > Thanks for replying. I was attempting to import realtional tables. I > have two tables IC_STRUCTURES and CHEBI_STRUCTURES tables thus: > > SQL> desc ic_structures > Name Null? Type > ----------------------------------------- -------- > ---------------------------- > STRUCTURE_ID NUMBER(8) > REGISTRATION_DATE NOT NULL DATE > FORMULA VARCHAR2(700) > WEIGHT NUMBER(12,4) > STEREO VARCHAR2(40) > OBJECT_TYPE NOT NULL VARCHAR2(3) > OBJECT_CONTENTS BLOB > > SQL> desc CHEBI_STRUCTURES > Name Null? Type > ----------------------------------------- -------- > ---------------------------- > ID NOT NULL NUMBER(20) > COMPOUND_ID NUMBER(15) > INCHI NOT NULL CLOB > TYPE NOT NULL VARCHAR2(30) > DIMENSION NOT NULL VARCHAR2(30) > MOL NOT NULL CLOB > > I reckon your second option is where I am (at the moment). I would > like D2Rq to read the (relational) schema and read the table strcuture > and import into the rdf schema as rdf model. I (think) I should then > be bale to use the d2rq mapping as a RDF view on to the relation data. > - I'd really like to be able to import the data as well, but I'll > cross that bridgw when I come to it. > > so I followed the import>owl/rdf view on realtion using d2rq> this > produced a mapping file, a schema file and a d2rq file. When I attempt > to open the mapping file I get the error. > > cheers, > Derek > > On Apr 6, 3:30 pm, Derek S <[email protected]> wrote: > > > On importing a [Oracle] database via d2rq, I get the following message > > reported by TBC when attempting to open the test file. > > > "Operation Failed > > Reason: > > Warning: Error during import. The import will be ignored > > but as result the model may be incomplete. > > The most recent URI was > > >http://purl.org/dc/elements/1.1/"; > > > Details > > "Server returned HTTP response code: 403 for > > URL:http://purl.org/dc/elements/1.1/"; --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
