[redland-dev] SPARQL queries in rdfproc using Virtuoso

[Rimvydas]

Hi,

Thank you!

I used the latest ones:
$ rdfproc -v
1.0.10
and
redland-bindings-1.0.10.1 (for Python)

On Mon, May 10, 2010 at 2:05 PM, Hugh Williams <hwilliams at openlinksw.com>wrote:

> Hi Rimvydas,
>
> We are going to check this against the latest Virtuoso 6.1.3127 builds. Can
> you please confirm which version of Redland you built against 1.0.8 , 1.0.9
> or other ? As the last version we tested against was 1.0.8 ...
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software
> Web: http://www.openlinksw.com
> Support: http://support.openlinksw.com
> Forums: http://boards.openlinksw.com/support
> Twitter: http://twitter.com/OpenLink
>
> On 10 May 2010, at 00:39, Rimvydas wrote:
>
> Hi,
>
> I recompiled redland once again:
> ...
> checking for UnixODBC support... yes
> ...
> Triple stores enabled   : memory file hashes trees mysql sqlite postgresql
> virtuoso
>
> Running the test confirms what I observed:
>
> $ utils/redland-virtuoso-test "dsn='VOS',user='usr',password='psw'"
>   1: Remove all triples in <http://red> context
> **PASSED**: removed context triples from the graph
>   2: Add triples to <http://red> context
> **PASSED**: add triple to context
>   3: Print all triples in <http://red> context
> [[
> ]]
> **PASSED**:
>   4: Count of triples in <http://red> context
> **PASSED**: graph has 6 triples
>   5: Exec:  ARC  aa bb
> **FAILED**: Failed to get arc
>   6: Exec:  ARCS  aa cc
> : matching nodes: 0
> **PASSED**:
>   7: Exec:  ARCS-IN  cc
> **PASSED**: matching arcs: 0
>   8: Exec:  ARCS-OUT  aa
> **PASSED**: matching arcs: 0
>   9: Exec:  CONTAINS aa bb1 cc
> **PASSED**: the graph contains the triple
>  10: Exec:  FIND aa - -
> **PASSED**: matching triples: 0
>  11: Exec:  HAS-ARC-IN cc bb
> **FAILED**: the graph does not contain the arc
>  12: Exec:  HAS-ARC-OUT aa bb
> **FAILED**: the graph does not contain the arc
>  13: Exec:  SOURCE  aa cc
> **FAILED**: Failed to get source
>  14: Exec:  SOURCES  bb cc
> : matching nodes: 0
> **PASSED**:
>  15: Exec:  TARGET  aa bb
> **FAILED**: Failed to get target
>  16: Exec:  TARGETS  aa bb
> : matching nodes: 0
> **PASSED**:
>  17: Exec:  REMOVE aa bb1 cc
> **PASSED**: removed triple from the graph
>  18: Exec:  QUERY "CONSTRUCT {?s ?p ?o} FROM <http://red> WHERE {?s ?p
> ?o}"
> rdf_model.c:1393: (librdf_model_query_execute) assertion failed: object
> pointer of type librdf_query is NULL.
> **FAILED**: Query of model with 'CONSTRUCT {?s ?p ?o} FROM <http://red>
> WHERE {?s ?p ?o}' failed
> rdf_query.c:390: (librdf_free_query) assertion failed: object pointer of
> type librdf_query is NULL.
> rdf_query.c:390: (librdf_free_query) assertion failed: object pointer of
> type librdf_query is NULL.
>  19: Exec1:  QUERY_AS_BINDINGS "SELECT * WHERE {graph <http://red> { ?s ?p
> ?o }}"
> rdf_model.c:1393: (librdf_model_query_execute) assertion failed: object
> pointer of type librdf_query is NULL.
> **FAILED**: Query of model with 'SELECT * WHERE {graph <http://red> { ?s
> ?p ?o }}' failed
> rdf_query.c:390: (librdf_free_query) assertion failed: object pointer of
> type librdf_query is NULL.
> rdf_query.c:390: (librdf_free_query) assertion failed: object pointer of
> type librdf_query is NULL.
>  20: Exec2:  QUERY_AS_BINDINGS "SELECT * WHERE {graph <http://red> { ?s ?p
> ?o }}"
> rdf_model.c:1393: (librdf_model_query_execute) assertion failed: object
> pointer of type librdf_query is NULL.
> **FAILED**: Query of model with 'SELECT * WHERE {graph <http://red> { ?s
> ?p ?o }}' failed
> rdf_query.c:390: (librdf_free_query) assertion failed: object pointer of
> type librdf_query is NULL.
> rdf_query.c:390: (librdf_free_query) assertion failed: object pointer of
> type librdf_query is NULL.
> =============================================
> PASSED: 12  FAILED:  8
>
>
> Maybe it is somehow related with Virtuoso's version I use (6.1.1.3127)?
>
>
> On Mon, May 10, 2010 at 1:24 AM, Hugh Williams <hwilliams at openlinksw.com>wrote:
>
>> Hi Rymvydas,
>>
>> Have you built the Redland Storage Provider into your Redland RDF
>> Framework library as detailed at:
>>
>>
>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFDriverRedland
>>
>>  and ran the provides storage test programs to verified its operation ?
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software
>> Web: http://www.openlinksw.com
>> Support: http://support.openlinksw.com
>> Forums: http://boards.openlinksw.com/support
>> Twitter: http://twitter.com/OpenLink
>>
>> On 9 May 2010, at 20:44, Rimvydas wrote:
>>
>> > I can add triples to virtuoso using rdfproc, but SPARQL queries just
>> don't seem to work.
>> >
>> > Triple is added successfully:
>> > $ rdfproc -r xml -s virtuoso -t "user='usr',password='psw',dsn='VOS'"
>> somecontext add aa bb cc
>> > rdfproc: added triple to the graph
>> >
>> > Triple can be found using "find" command:
>> > $ rdfproc -r xml -s virtuoso -t "user='usr',password='psw',dsn='VOS'"
>> somecontext find aa bb cc
>> > Matched triple: {[aa], [bb], "cc"} with context [somecontext]
>> > rdfproc: matching triples: 1
>> >
>> > However, SPARQL queries return 0 results:
>> > $ rdfproc -s virtuoso -t "user='usr',password='psw',dsn='VOS'"
>> somecontext query sparql - "SELECT * WHERE {?s ?p ?o}"
>> > rdfproc: Query returned bindings results:
>> > rdfproc: Query returned 0 results
>> >
>> > Am I missing something here?
>> >
>> > Note: I can run a similar query successfully in ODBC's ISQL like this:
>> > CALL DB.DBA.SPARQL_EVAL('SELECT * FROM NAMED <somecontext> {GRAPH
>> <somecontext> {?s ?p ?o}}', NULL, 0)
>> > ...
>> > 1 row fetched
>> >
>> > --
>> > Rimvydas
>> > _______________________________________________
>> > redland-dev mailing list
>> > redland-dev at lists.librdf.org
>> > http://lists.librdf.org/mailman/listinfo/redland-dev
>>
>>
>
>
> --
> Rimvydas Naktinis
>
>
>


-- 
Rimvydas Naktinis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.librdf.org/pipermail/redland-dev/attachments/20100510/ca78624f/attachment-0001.htm