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

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 > Hi Percy, > > Note, Ivan does most of the work on the Virtuoso SPAR

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

Hi Ivan, Hugh Worked just perfect =) Thank you for your reply Hugh: Yes I ran against an open source 6.1.3 but I plan to move to the new VOS release Best Regards, Percy 2012/1/12 Hugh Williams > Hi Percy, > > Note, Ivan does most of the work on the Virtuoso SPARQL engine so you > should foll

Re: [Virtuoso-users] load command from jdbc

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 Top-Level:

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

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 6

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

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 only. To limit the selec

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

Hello Percy, I'd write either MODIFY 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";)) } }

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

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 delete {?s ?p ?o} insert {?s_new ?p ?o} where { { SELECT bif:replace(st

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

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 ? Not

Re: [Virtuoso-users] load command from jdbc

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

[Virtuoso-users] load command from jdbc

Hi. I need execute the command load (http://docs.openlinksw.com/virtuoso/isql.html) to load a sql dump. from isql works fine isql> use test_scheme isql> load /var/folders/Lf/LfpHqngMENCf+2aAfoO3IE+++TI/-Tmp-/dump_sql_ext7446201432912089856tmp but from jdbc, I got the next exception: Caused