Re: [Virtuoso-users] load command from jdbc

2012-01-12 Thread Ivan Mikhailov
Hello Marcelo, LOAD is not a Virtuoso SQL command, it's an ISQL one. The ISQL checks the command to be executed, whether it's of special isql-ish syntax or not, it executes commands it understand and send the rest to the server, unchanged. There's no way to mimic ISQL's behavior right on the

Re: [Virtuoso-users] Multiple instances - One SPARQL endpoint

2012-01-12 Thread Hugh Williams
Hi Houda, I can’t see how this can be readily done without the use of SPARQL-FED ie SERVICE keyword. Why do you have data in separate Virtuoso Quad Store instances on the same machine rather than in a single Virtuoso Quad Store instance, is the data in each instance the same or different ?

Re: [Virtuoso-users] MODIFY statement doesn't work properly

2012-01-12 Thread Percy Enrique Rivera Salas
Hi Hugh, I provided a wrong example =( the right one is the following Virtuoso 22023 Error SR007: Function sprintf needs a string or UNAME or NULL as argument 2, not an arg of type INTEGER (189) MODIFY http://test.com/ delete {?s ?p ?o} insert {?s_new ?p ?o} where { { SELECT

Re: [Virtuoso-users] MODIFY statement doesn't work properly

2012-01-12 Thread Ivan Mikhailov
Hello Percy, I'd write either MODIFY http://test.com/ delete {?s ?p ?o} insert {?s_new ?p ?o} where { { SELECT iri(bif:replace( str(?s),http://test.com/link,http://test.com/extra/link; ) ) AS ?s_new ?s ?p ?o WHERE {?s ?p ?o filter (regex (str(?s), http://test.com/link;)) } } } or

Re: [Virtuoso-users] MODIFY statement doesn't work properly

2012-01-12 Thread Ivan Mikhailov
Percy, Two additional notes. 1. The reported error is a result of an error in CONSTRUCT's error diagnostics, will fix that. 2. Note that the query selects everything from all graphs (and thus makes inserts), whereas you probably intended to select from http://test.com/ only. To limit the

Re: [Virtuoso-users] MODIFY statement doesn't work properly

2012-01-12 Thread Hugh Williams
Hi Percy, Note, Ivan does most of the work on the Virtuoso SPARQL engine so you should follow his advise ... Although I would like to point out that even your last query runs successfully for me against an open source 6.1.4 or commercial 6.3 build, thus are you running against an open source

Re: [Virtuoso-users] load command from jdbc

2012-01-12 Thread Marcelo Aliquintuy
Hello Ivan . Thanks for your answer, a try run the command but i got the next error: Error 22023: [Virtuoso Driver][Virtuoso Server]HT057: The STRING session in string_output_string is longer than 10Mb. Either use substring to access it in parts or place less data in it. at line 10 of

Re: [Virtuoso-users] MODIFY statement doesn't work properly

2012-01-12 Thread Percy Enrique Rivera Salas
Hugh, By the way, I got the same error in VOS 6.1.4 Virtuoso 22023 Error SR007: Function sprintf needs a string or UNAME or NULL as argument 2, not an arg of type INTEGER (189) Best Regards, Percy 2012/1/12 Hugh Williams hwilli...@openlinksw.com Hi Percy, Note, Ivan does most of the