Re: [Virtuoso-users] Select from group graph in SQL

2012-12-13 Thread Hugh Williams
Hi Dimitris, The way it can be done is to use theVirtuoso sparql_to_sql_text() function (http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html) to determine the SQL query the query including the graph group is translated to ie sparql_to_sql_text ('select * from { ?s ?p ?o }'), then l

Re: [Virtuoso-users] debuging Transaction deadlock

2012-12-13 Thread Hugh Williams
Hi Marcelo, Transactional and update intensive SPARQL update (SPARUL) operations should be performed with Virtuoso transaction isolation level set to “Read Committed” (2), in the Virtuoso INI file and restart, as detailed at; http://wikis.openlinksw.com/dataspace/owiki/wiki/VirtuosoW

[Virtuoso-users] debuging Transaction deadlock

2012-12-13 Thread Marcelo Aliquintuy
Hi. I got some Transaction deadlock when make select or insert. I use Transactions and I want to know if I can debug the transaction in virtuoso to find the breaking transaction. In ISQL status() i can see if i have any deadlock only. attach stacktrace below. Best Regards!. org.springframework

Re: [Virtuoso-users] Fetching types for a large number of concepts

2012-12-13 Thread David Brooks
What about: SELECT ?c ?t { ?cncpt foaf:isPrimaryTopicOf ?c . ?cncpt a ?t . FILTER (?cncpt = || ?cncpt = || ... ) } with no FILTER if you want all concepts. Regards, Dave On 14/12/12 1:15 AM, Parsa Ghaffari wrote: Hi folks, What's the best way to retrieve types (rdf:type) of a lar

[Virtuoso-users] Fetching types for a large number of concepts

2012-12-13 Thread Parsa Ghaffari
Hi folks, What's the best way to retrieve types (rdf:type) of a large amount of concepts, in association with the concept itself? For instance: [Barack_Obama:Person, United_States:Place,...] I came up with this query: SELECT ?c ?t { { a ?t. foaf:isPrimaryTopicOf ?c} UNION { a ?t. foaf

Re: [Virtuoso-users] Wrong graph URI

2012-12-13 Thread Kingsley Idehen
On 12/12/12 11:20 AM, Gregory Williams wrote: On Dec 12, 2012, at 7:24 AM, Kingsley Idehen wrote: The problem is that these graphs are purpose specific. For instance, they don't have anything to do with DBpedia, they are installed by for use by our Faceted Browser (re. ). Basically, this is w