Re: [Virtuoso-users] How to disconnect SPARQL USER

[Patrick van Kleef]

HI Maxime,


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


The http_pending_req() returns a vector e.g.:

    SQL> select http_pending_req();

    VARCHAR
     
_______________________________________________________________________________

    vector(0x04460c78,0x04460cd8,0x04460d08,0x0446e3b8)

    1 Rows. -- 0 msec.

Each of these 4 elements in the vector contains a tuple with the IP  
address, the endpoint and the ID of the request.

To use it, you can create a procedure like this:

    create procedure my_show_http_req()
    {
      declare HTTP_IP  varchar(40);
      declare HTTP_REQ varchar(20);
      declare HTTP_ID  varchar(15);

      result_names (HTTP_IP, HTTP_REQ, HTTP_ID);

      foreach (any req in http_pending_req()) do {
        result(req[0], req[1], req[2]);
      }
    }
    ;



Here is an example:

    SQL> my_show_http_req();

    HTTP_IP             HTTP_REQ       HTTP_ID
    VARCHAR             VARCHAR        VARCHAR
    __________________________________________________

    127.0.0.1           /sparql        46920327908064
    127.0.0.1           /about         46920103636928
    127.0.0.1           /sparql        46919932624640
    127.0.0.1           /describe      46919654535248

    4 Rows. -- 1 msec.


The output of this can then be used with http_kill e.g.:

   SQL>  http_kill ('127.0.0.1', '/sparql', 46920327908064);


Patrick