17.2.1. Exposing Stored Procedures as WSDL Services

Virtuoso can be both a provider and a client of WSDL. In this section we will explain how to use Virtuoso to expose procedures as SOAP messages, and then publish them as WSDL consumables.

In the descriptions below, lines preceded by


denote that the command is intended to be issued using the ISQL command line interface to Virtuoso.

Virtuoso procedures can easily be published as WSDL consumables. We follow the same steps as we would take to create SOAP objects and then for every SOAP object Virtuoso automatically generates a WSDL file entry. The default Virtuoso has the user SOAP and reserved HTTP path of /SOAP/ . All procedures that are created in the default qualifier namespace of the SOAP user (WS.SOAP) and have had a 'grant execute to SOAP' permissions established in the database are available to SOAP and thus are automatically available to WSDL. In Virtuoso this is done by requesting the file services.wsdl from the server via HTTP from the /SOAP/ path:


. WSDL files such as this are often referred to as "endpoints" for services.

Virtual directories increase our flexibility by allowing us to map logical HTTP paths to the location /SOAP/ . This means that we can separate WSDL/SOAP functionality, making groups of services available under different locations. We will now demonstrate this:

  1. First, create a new user in the database for creating the stored procedures as SOAP messages:

  2. Now, set the default catalogue/qualifier for the new user to the WS catalogue where we will create procedures to be used as SOAP objects:

  3. Now create a new virtual host definition, using the vhost_define() , so that we can find our SOAP objects later at a desired location.

    SQL>VHOST_DEFINE (vhost=>'*ini*',lhost=>'*ini*',lpath=>'/services',ppath=>'/SOAP/',soap_user=>'SOAPDEMO');

    If the mapping already exists, producing an error in the call above, and is not being used, then you can remove it using the command:

    SQL>VHOST_REMOVE (vhost=>'*ini*',lhost=>'*ini*',lpath=>'/services')
    [Note] Note:

    *ini* is a special indicator telling Virtuoso to take the default values from its initialization file.

  4. Now create a simple SOAPTEST procedure and grant the appropriate privileges to the SOAPDEMO user:

    SQL> create procedure
      WS.SOAPDEMO.SOAPTEST (in par varchar)
      return (upper(par));
    SQL> grant execute on WS.SOAPDEMO.SOAPTEST to SOAPDEMO;
  5. Now test this new SOAP object's availability by using soap_client() . This function would normally return a vector representation of the SOAP object but since we know the dimensions of the object ahead of time we can pin-point the entry using the aref() function as follows:

    SQL> select aref(aref(
    	soap_client (url=>sprintf ('http://localhost:%s/services', server_http_port ()),
    	operation=>'SOAPTEST', parameters=>vector('par', 'demotext')), 1), 1);

    The actual SOAP object looks more like:

    (("SOAPTESTResponse" ) (("CallReturn" ) "DEMOTEXT" ) )

    which was generated in a Virtuoso server log for debugging purposes using the dbg_obj_print() function.

  6. Procedures that exist under the WS.SOAPDEMO namespace and have been granted execution to the new SOAPDEMO user are now available as SOAP services and described by WSDL in this example, Virtuoso would publish them from the URL:


    which will yield the following WSDL description:

    <?xml version='1.0'?>
     xmlns:tns ='services.wsdl'
     xmlns ='http://schemas.xmlsoap.org/wsdl/'
    	<message name='SOAPTEST'>
    		<part name='par' type='xsd:string'/>
    	<message name='SOAPTESTResponse'>
    		<part name='CallReturn' type='xsd:string'/>
    	<portType name='SOAPPortType'>
    		<operation name='SOAPTEST'>
    			<input message='tns:SOAPTEST' name='SOAPTEST'/>
    			<output message='tns:SOAPTESTResponse' name='SOAPTESTResponse'/>
    	<binding name='SOAPBinding' type='tns:SOAPPortType'>
    		<soap:binding style='rpc' transport='http://schemas.xmlsoap.org/soap/http'/>
    		<operation name='SOAPTEST'>
    			<soap:operation soapAction='urn:openlinksw.com:virtuoso_soap_schema#SOAPTEST'/>
    				<soap:body use='encoded' namespace='urn:openlinksw.com:virtuoso_soap_schema' encodingStyle='http://schemas.xmlsoap.org/soap/encoding/' />
    				<soap:body use='encoded' namespace='urn:openlinksw.com:virtuoso_soap_schema' encodingStyle='http://schemas.xmlsoap.org/soap/encoding/' />
    	<service name='SOAPService'>
    		<port name='SOAPPort' binding='tns:SOAPBinding'>
    			<soap:address location='http://example.com/services'/>
    [Tip] See Also:

    The Testing Web Services (VSMX) section describes Virtuoso's ability to also automatically generate a test page for your SOAP services, simply by replacing services.wsdl with services.vsmx in the URL.