Hi Nico,
As Tim suggested in his response to you, if the JDBC driver is being used then
you should be able to simply set the timeout with "set result_timeout =<value>"
such that SPARQL queries only run to that period of time max after which
partial results available will be returned, as works from isql and is how the
JDBC Driver which is another SQL interface should behave:
$ /opt/virtuoso/bin/isql oplusbench1:1111
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> set result_timeout = 2000;
Done. -- 336 msec.
SQL> sparql select * where {?s ?p ?o};
s
p
o
VARCHAR
VARCHAR
VARCHAR
_______________________________________________________________________________
http://www.openlinksw.com/virtrdf-data-formats#default-iid
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat
http://www.openlinksw.com/virtrdf-data-formats#default-iid-nullable
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat
http://www.openlinksw.com/virtrdf-data-formats#default-iid-nonblank
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat
http://www.openlinksw.com/virtrdf-data-formats#default-iid-nonblank-nullable
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat
.
.
.
http://demo.openlinksw.com/schemas/thalia#Toronto
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat
http://demo.openlinksw.com/schemas/thalia#TorontoInstructor
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat
http://demo.openlinksw.com/schemas/thalia#TorontoLecture
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat
http://demo.openlinksw.com/schemas/thalia#TorontoPlace
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat
*** Error S1TAT: [Virtuoso Driver][Virtuoso Server]RC...: Returning incomplete
results, query interrupted by result timeout. Activity: 181R rnd 199R
seq 0P disk 0B / 0 messages
at line 2 of Top-Level:
sparql select * where {?s ?p ?o}
SQL>
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 21 May 2010, at 16:35, N.Stieler wrote:
> Hi again,
>
> this timeout is a timeout for the Driver and it is closing the connection
> after the set time, and I didn't get a result.
>
> But the timeout I am looking for is for the DB(TripleStore) and I would like
> to receive a subset of the complete result (As it is descript in the link
> (http://docs.openlinksw.com/virtuoso/anytimequeries.html)).
>
> Thank you,
> Nico
>
> -----Original Message-----
> From: Hugh Williams [mailto:[email protected]]
> Sent: 20 May 2010 13:42
> To: N.Stieler
> Cc: 'Virtuoso Users List'
> Subject: Re: [Virtuoso-users] query with timeout
>
> Hi Nico,
>
> The JDBC Timeout param is detailed at:
>
> http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software
> Web: http://www.openlinksw.com
> Support: http://support.openlinksw.com
> Forums: http://boards.openlinksw.com/support
> Twitter: http://twitter.com/OpenLink
>
> On 20 May 2010, at 12:52, N.Stieler wrote:
>
>> Hello All,
>>
>> I want to set a timeout for a query.
>>
>> I have already found this URL:
>> http://docs.openlinksw.com/virtuoso/anytimequeries.html
>>
>> But I am using the JDBC Driver for Virtuoso.
>>
>> Is it possible to use a timeout there?
>>
>> Bye
>> Nico
>>
>> --
>> The Open University is incorporated by Royal Charter (RC 000391), an exempt
>> charity in England & Wales and a charity registered in Scotland (SC 038302).
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Virtuoso-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
