On 2/13/12 12:06 PM, Maxime Teissèdre wrote:
Hi,

When i run the http_pending_req(); request during a sparl-end-point requests, nothing is return.

Adding to Patrick's reply to this message: please keep in mind that isql is an SQL client - if a function or procedure does not return a SQL result set, you need to use SELECT in your query to do so.

For functions returning complex types, such as vectors, or vectors of vectors you can either write a stored procedure that makes a SQL result set out of the return values, as per Patrick's example.

If you are debugging stored procedures, there's another handy feature: If you have access to the system console (STDOUT) of the Virtuoso process (i.e. run virtuoso in foreground in terminal for debugging,) you can use dbg_obj_print [1]:

SQL> dbg_obj_print (vector (vector ('foo', 'plugh', null), vector ('bar', 'xyzzy')));

Done. -- 4 msec.
SQL>

Will yield this on STDOUT of the Virtuoso process:

(('foo' 'plugh' <DB NULL> ) ('bar' 'xyzzy' ) )

Another handy function for producing debug output is dbg_printf [2].

Yrjänä

[1] http://docs.openlinksw.com/virtuoso/fn_dbg_printf.html
[2] http://docs.openlinksw.com/virtuoso/fn_dbg_obj_print.html
Maxime.

2012/2/13 Patrick van Kleef <[email protected] <mailto:[email protected]>>

    Hi Maxime,


        I can disconnect Virtuoso's users (isql, php odbc, jdbc jena),
        but SPARQL-End-Point is insensitive to the order
        disconnect_user ('USER'); even using %.

        What is the way to disconnect?


    For HTTP requests you can use the http_kill command.

    http://docs.openlinksw.com/virtuoso/fn_http_kill.html


    Patrick




------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2


_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


--
Mr. Yrjana Rankka        | [email protected]
Developer, Virtuoso Team | http://www.openlinksw.com
                         | Making Technology Work For You

Reply via email to