Yes, including that directive also did not help until I mapped the primary key as one of the properties.
On Fri, Mar 26, 2010 at 7:32 AM, Ivan Mikhailov <[email protected]>wrote: > Hello Jesse, > > On Thu, 2010-03-25 at 16:30 -0400, Jesse Sightler wrote: > > I am continuing to evaluate the RDF View mapping capabilities of > > Virtuoso. The whitepaper on the subject is useful, but I'm still > > having issues manually generating a mapping (needed in our case, as we > > want to match a specific vocabulary). > > > > > > Given a sample table: > > create table "testrdfview"."DBA"."vehicle" > > ( > > "id" INTEGER, > > "manufacturer_id" INTEGER, > > "vehicleName" VARCHAR(255), > > PRIMARY KEY ("id") > > ); > > > > with data: > > insert into "testrdfview"."DBA"."vehicle" (id, manufacturer_id, > vehicleName) values (1,1,'S2000'); > > > > insert into "testrdfview"."DBA"."vehicle" (id, manufacturer_id, > vehicleName) values (1,1,'Accord'); > > > > And the following mappings: > > sparql > > > > prefix testrdfview: <http://www.nowhere.com/testrdfview/#> > > > > create iri class testrdfview:vehicle > > "http://^{URIQADefaultHost}^/testrdfview/vehicle/id/%d#this"; > (in _id integer not null) . ; > > > > sparql > > > > prefix testrdfview: <http://www.nowhere.com/testrdfview/#> > > create quad storage testrdfview:graph > > from "testrdfview"."DBA"."vehicle" as vehicle_tbl > > { > > create testrdfview:qm-vehicle as graph iri("http:// > ^{URIQADefaultHost}^/testrdfview#") > > { > > testrdfview:vehicle (vehicle_tbl."id") a testrdfview:vehicle ; > > testrdfview:vehicle_name vehicle_tbl.vehicleName as > testrdfview:dba-vehicle-name . > > } > > } > > ; > > > > However, running a query against the expected graph ( > http://localhost:8890/testrdfview#) with this sparql returns no results: > > > > select * { ?s ?p ?o } > > You've created an RDF View in a new storage, namely testrdfview:graph, > but query the default one, virtrdf:DefaultQuadStorage. > > If I try the proper storage, I get > > sparql define input:storage <http://www.nowhere.com/testrdfview/#graph> > select * where { graph ?g { ?s ?p ?o }}; > g > s > p o > VARCHAR > VARCHAR > VARCHAR VARCHAR > > _______________________________________________________________________________ > > http://localhost.localdomain:8550/testrdfview# > http://localhost.localdomain:8550/testrdfview/vehicle/id/1#this > http://www.w3.org/1999/02/22-rdf-syntax-ns#type > http://www.nowhere.com/testrdfview/#vehicle > http://localhost.localdomain:8550/testrdfview# > http://localhost.localdomain:8550/testrdfview/vehicle/id/1#this > http://www.nowhere.com/testrdfview/#vehicle_name > Accord > > as expected. > > If you do not want to specify a storage in the query, "alter quad > storage virtrdf:DefaultQuadStorage", not create a new one. > > Best Regards, > > Ivan Mikhailov > OpenLink Software > http://virtuoso.openlinksw.com > > >
