[Virtuoso-users] Obtain all graphs

2010-12-02 Thread Vanessa Lopez
Hi all! How can obtain all graph URIs in a given Virtuoso sparql end point? I tried in http://demo.openlinksw.com/sparql with the query SELECT DISTINCT ?g WHERE { GRAPH ?g {?s ?p ?o}} But it just gives me 40001 Error SR172: Transaction deadlocked in

Re: [Virtuoso-users] Obtain all graphs

2010-12-02 Thread Hugh Williams
Hi Vanessa, Please use the following special function for obtaining a list of available graphs in Virtuoso: DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS() Which can be run from an isql command line prompt or the Virtuoso conductor SQL interface. Best Regards Hugh Williams Professional Services

[Virtuoso-users] Support for Lines and Polygons in Virtuoso's Geospatial Extensions

2010-12-02 Thread Wood, Jamey
In playing with a trial copy of Virtuoso 6.2 (Commercial Edition), I've noticed that it appears that its geospatial capabilities only cover points. For example: SQL select st_geomfromtext('LINESTRING(3 4,10 50,20 25)'); *** Error 37000: [Virtuoso Driver][Virtuoso Server]GEO..: Bad geometry

Re: [Virtuoso-users] Obtain all graphs

2010-12-02 Thread Ivan Mikhailov
Hello Vanessa, Finding all graphs on a busy database is indeed a problem. The most popular way is to cheat a bit in hope that every graph contains at least one triple for some rdf:type of some subject. The query SELECT DISTINCT ?g WHERE { GRAPH ?g {?s a ?t}} has much more changes to complete,

Re: [Virtuoso-users] Connecting to a SPARQL end-point (DBpedia) via JDBC?

2010-12-02 Thread Vanessa Lopez
Hi all! Is there any way to access to a public virtuoso SPARQL end point (e.g. http://dbpedia.org/sparql or http://demo.openlinksw.com) via JDBC ? (same as when accessing to it locally) Something like: Class.forName(virtuoso.jdbc3.Driver); con =

Re: [Virtuoso-users] Support for Lines and Polygons in Virtuoso's Geospatial Extensions

2010-12-02 Thread Patrick van Kleef
Hi Jamey, In playing with a trial copy of Virtuoso 6.2 (Commercial Edition), I've noticed that it appears that its geospatial capabilities only cover points. For example: SQL select st_geomfromtext('LINESTRING(3 4,10 50,20 25)'); *** Error 37000: [Virtuoso Driver][Virtuoso

Re: [Virtuoso-users] Connecting to a SPARQL end-point (DBpedia) via JDBC?

2010-12-02 Thread Aldo Bucchi
Vanessa, On Thu, Dec 2, 2010 at 4:34 PM, Vanessa Lopez v.lo...@open.ac.uk wrote: Hi all! Is there any way  to access to a public virtuoso SPARQL end point (e.g. http://dbpedia.org/sparql or http://demo.openlinksw.com)  via JDBC ? (same as when accessing to it locally) Something like:

Re: [Virtuoso-users] Support for Lines and Polygons in Virtuoso's Geospatial Extensions

2010-12-02 Thread Wood, Jamey
Hi Patrick, Thanks for your response. I wonder if anyone could comment on how difficult the remaining work would be. Since the R-Tree indexing part has already been implemented, I wonder if the rest would largely just be a matter of integrating various higher-level functionality from an

Re: [Virtuoso-users] Support for Lines and Polygons in Virtuoso's Geospatial Extensions

2010-12-02 Thread William Waites
* [2010-12-02 13:23:30 -0700] Wood, Jamey jamey.w...@nrel.gov écrit: ] Thanks for your response. I wonder if anyone could comment on how ] difficult the remaining work would be. Since the R-Tree indexing part has ] already been implemented, I wonder if the rest would largely just be a ] matter

Re: [Virtuoso-users] Connecting to a SPARQL end-point (DBpedia) via JDBC?

2010-12-02 Thread Kingsley Idehen
On 12/2/10 2:48 PM, Aldo Bucchi wrote: Vanessa, On Thu, Dec 2, 2010 at 4:34 PM, Vanessa Lopezv.lo...@open.ac.uk wrote: Hi all! Is there any way to access to a public virtuoso SPARQL end point (e.g. http://dbpedia.org/sparql or http://demo.openlinksw.com) via JDBC ? (same as when accessing