Re: [Virtuoso-users] Problem adding external datasource

2011-01-20 Thread CStadler
Hi Patrick& Hugh, Thank you very much for the great support - setting the environment variables ($ODBCINI and $ODBCINSTINI) and adjusting the content of the corresponding files according to the provided example solved my issue :) >> [Hugh wrote:] BTW, as you are using the commercial product a

Re: [Virtuoso-users] Problem adding external datasource

2011-01-20 Thread Patrick van Kleef
Hi Claus, As I've seen on the list that someone recently managed to get RDF views working with spatial queries, I also wanted to give it another try. However, when I go to: Conductor->Database->External Data Sources -> Configure Data Sources then whenever I click on any of the add dsn buttons

Re: [Virtuoso-users] SPARQL Update problems

2011-01-20 Thread Lars Marius Garshol
* Ivan Mikhailov > > The parameter name should be "query=", not "update=" . In addition, the > supported syntax is "original" SPARUL, not SPARQL 1.1 variant, so it's > INSERT DATA IN { } . This brought me a lot closer, but it's still not working, and I'm not really sure why: query=INSERT+DAT

Re: [Virtuoso-users] SPARQL Update problems

2011-01-20 Thread Lars Marius Garshol
* Ivan Mikhailov > > The parameter name should be "query=", not "update=" . In addition, the > supported syntax is "original" SPARUL, not SPARQL 1.1 variant, so it's > INSERT DATA IN { } . Aha! Now that explains things. Thank you! :-) -- Lars Marius Garshol lar...@ontopia.net

Re: [Virtuoso-users] SPARQL Update problems

2011-01-20 Thread Ivan Mikhailov
Hello Lars, The parameter name should be "query=", not "update=" . In addition, the supported syntax is "original" SPARUL, not SPARQL 1.1 variant, so it's INSERT DATA IN { } . Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2011-01-20 at 16:13 +0100, Lar

Re: [Virtuoso-users] SPARQL Update problems

2011-01-20 Thread Lars Marius Garshol
* Kingsley Idehen > > You have to explicitly enable this functionality for security reasons. Fair enough. > For SPARUL you need to grant "SPARQL_UPDATE" privileges to user "SPARQL" . Unfortunately, that doesn't seem to work. I tried doing it with isql, but get: OpenLink Interactive SQL (Virtu

Re: [Virtuoso-users] SPARQL Update problems

2011-01-20 Thread Kingsley Idehen
On 1/20/11 10:13 AM, Lars Marius Garshol wrote: I'm trying to use the SPARQL Update functionality in Virtuoso, but struggling to figure out what the endpoint is. I've tried http://localhost:8890/sparql/ but that doesn't seem to accept SPARQL Update. I found a hint in the manual that says:

[Virtuoso-users] SPARQL Update problems

2011-01-20 Thread Lars Marius Garshol
I'm trying to use the SPARQL Update functionality in Virtuoso, but struggling to figure out what the endpoint is. I've tried http://localhost:8890/sparql/ but that doesn't seem to accept SPARQL Update. I found a hint in the manual that says: > If SPARQL_UPDATE role is granted to SPARQL user,

[Virtuoso-users] SPARQL Update problems

2011-01-20 Thread Lars Marius Garshol
I'm trying to use the SPARQL Update functionality in Virtuoso, but struggling to figure out what the endpoint is. I've tried http://localhost:8890/sparql/ but that doesn't seem to accept SPARQL Update. I found a hint in the manual that says: > If SPARQL_UPDATE role is granted to SPARQL user

Re: [Virtuoso-users] Changing default isolation level

2011-01-20 Thread Hugh Williams
Hi Abhi, Yes, you would set accordingly in the "[Parameters]" section of the virtuoso.ini file and restart the Virtuoso server, as detailed in the server configuration parameters documentation at: http://docs.openlinksw.com/virtuoso/dbadm.html#configsrvstupfiles Best Regards Hugh Willi

[Virtuoso-users] Changing default isolation level

2011-01-20 Thread Abhi
Thiswiki says that changing DefaultIsolation parameter in virtuoso.ini file changes the default isolation level. The virtuoso.ini file that came along with virtuos(from ubuntu repos) do

Re: [Virtuoso-users] Java spatial problem

2011-01-20 Thread Hugh Williams
Hi Hoan, You need to bypass the Jena parser which does not understand the Virtuoso specific "bif:xxx" functions in your query and pass directly to Virtuoso for execution as detailed in our Jena Provider documentation at: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtJenaP

Re: [Virtuoso-users] Problem adding external datasource

2011-01-20 Thread Hugh Williams
Hi Claus, This is a known issue that will be fixed in the next release. In the meantime you will need to edit the odbc.ini file in the Virtuoso "bin" directory (by default) or where ever the $ODBCINI environment variable is pointing to and manually add the DSN from command line and test that i

[Virtuoso-users] Problem adding external datasource

2011-01-20 Thread CStadler
Hi, As I've seen on the list that someone recently managed to get RDF views working with spatial queries, I also wanted to give it another try. However, when I go to: Conductor->Database->External Data Sources -> Configure Data Sources then whenever I click on any of the add dsn buttons (user,

[Virtuoso-users] Java spatial problem

2011-01-20 Thread Nguyen Mau Quoc Hoan
I was successfully creating RDF Views in Virtuoso,but there are some problem when I queried from Java,problem about some spatial function (but It work when I query from virtuoso sparql end point) public class IntersectsExample { > public static void main(String[] args) { // TODO Auto-generated

Re: [Virtuoso-users] CONSTRUCT query result order

2011-01-20 Thread Timo Westkämper
Hello Ivan. Thanks for the detailed answer. I will then do the ordering afterwards. Br, Timo Westkämper Hello Timo, It is not ignored when bindings are sorted to get proper "cut" via LIMIT and OFFSET. However the triples made according to variable values from that bindings form a _set_ of dist