Re: [Virtuoso-users] Dump arbitrary query result as N-Triples

2011-03-02 Thread Claus Stadler
Hi, Thanks for your reply. I was able to get it working. I am posting my script here for reference - variables could be renamed to something more human readable, but at least it is capable of dumping huge result sets (multiple GB). * Bascially you pass in a sparql select query that has 3 vari

[Virtuoso-users] Mistyping of automatically generated DataTable columns in ADO.Net Provider

2011-03-02 Thread Rob Vesse
Hi all Found what may or may not be a bug in the ADO.Net provider. Not sure if the behaviour is intentional or incorrect. If I create a DataTable and don't specify any columns then make a SPASQL query via the ADO.Net provider and fill the DataTable using the VirtuosoDataAdapter then everythin

Re: [Virtuoso-users] sql: and bif: prefixes not working in SPARQL queries

2011-03-02 Thread Martin Gerlach
Hi Ivan, thank you, the parantheses are indeed the solution to our problem. The Virtuoso OpenSource version that produced the problem is 06.01.3126 We did not experience the problem with version 06.01.3127 Cheers Martin On 02.03.2011 11:07, Ivan Mikhailov wrote: Hello Martin, Expressions in

[Virtuoso-users] Major bug with Virtuoso SPARQL Results

2011-03-02 Thread Rob Vesse
Hi all I've found what appears to be a major bug with Virtuoso's SPARQL results for one specific query namely: SELECT DISTINCT ?g WHERE { GRAPH ?g { ?s ?p ?o } } When this query is executed results come back as elements in the XML results rather than as elements. If you remove the DISTINCT

Re: [Virtuoso-users] Dump arbitrary query result as N-Triples

2011-03-02 Thread Rumi Tsekova
Hi Claus, As described in http://docs.openlinksw.com/virtuoso/fn_exec.html, the "rows" parameter is "An output array with one element per result row containing an array with the leftmost column as element 0 and so forth". Processing further the result can be done for ex. such as: exec (,

Re: [Virtuoso-users] Dump arbitrary query result as N-Triples

2011-03-02 Thread Ivan Mikhailov
Hello Claus, sparql define output:format "NT" construct { ?s a ?t } from virtrdf: where { ?s a ?t }; works, the doc is slightly out-of-date there. For iteration over result-set of an arbitrary query, use exec_next() http://docs.openlinksw.com/virtuoso/fn_exec_next.html in a loop that begins with

Re: [Virtuoso-users] sql: and bif: prefixes not working in SPARQL queries

2011-03-02 Thread Ivan Mikhailov
Hello Martin, Expressions in SPARQL result list need parentheses, like define sql:signal-void-variables 1 select ?s ?ld ?le (bif:length(?ld)) as ?l ... The rationale for this syntax is that for some expressions it is impossible to distinguish between one column with long expression or two column

Re: [Virtuoso-users] sql: and bif: prefixes not working in SPARQL queries

2011-03-02 Thread Martin Gerlach
Hi, Virtuoso Edition is OpenSource: Version: * Version: 06.01.3126 * Build: Feb 19 2010 Installed a few days ago on an Ubuntu system using the ubuntu/debian package. The exact query should not be important as I observed the problem no matter which query I fired as long as it used sql

Re: [Virtuoso-users] Virtuoso SR175, rebuilt indexes and now crashes

2011-03-02 Thread Roberto GarcĂ­a
Dear all, I'm experiencing again the following exception when loading data into VOS 6.1.2 through Jena: SR175: Uniqueness violation : Violating unique index RDF_QUAD_POGS on table DB.DBA.RDF_QUAD. Transaction killed. Last time I tried to solve the problem following the indications in the message