Index of modules
Module sql
Name: sql
Title: Executor de comandes SQL
Namespace: http://sql.matrix.org/
Service: SQLManagerService
Port: SQLManagerPort
Java package: org.matrix.sql
Version: 1.0
Status: FINAL
Authors: Abel Blanque
WSDL: sql.wsdl
Imports:
prefix namespace
xs http://www.w3.org/2001/XMLSchema
mime http://www.w3.org/2005/05/xmlmime
mx http://base.matrix.org/

[Types] [Operations]

Types

Struct QueryParameters
Name: QueryParameters
QName: sql:QueryParameters
Java class name: org.matrix.sql.QueryParameters
Properties:
name xml type occurs nillable read only references
parameters sql:QueryParameter 0..N true false
Related operations:
Struct QueryParameter
Name: QueryParameter
QName: sql:QueryParameter
Java class name: org.matrix.sql.QueryParameter
Properties:
name xml type occurs nillable read only references
name xs:string 0..1 false false
value xs:anyType 0..1 false false
Struct QueryTable
Name: QueryTable
QName: sql:QueryTable
Java class name: org.matrix.sql.QueryTable
Properties:
name xml type occurs nillable read only references
columnName xs:string 0..N true false
queryRow sql:QueryRow 0..N true false
Related operations:
Struct QueryRow
Name: QueryRow
QName: sql:QueryRow
Java class name: org.matrix.sql.QueryRow
Properties:
name xml type occurs nillable read only references
values xs:anyType 0..N true false

Operations

Operation executeDriverQuery
Name: executeDriverQuery
Signature: executeDriverQuery (sql {xs:string}, parameters {sql:QueryParameters}, driver {xs:string}, url {xs:string}, username {xs:string}, password {xs:string}) => queryTable {sql:QueryTable}
Java signature: org.matrix.sql.QueryTable executeDriverQuery(String sql, org.matrix.sql.QueryParameters parameters, String driver, String url, String username, String password)
Parameters:
name xml type occurs nillable read only references
sql xs:string 1 false false
parameters sql:QueryParameters 1 false false
driver xs:string 1 false false
url xs:string 1 false false
username xs:string 1 false false
password xs:string 1 false false
Response:
name xml type occurs nillable read only references
queryTable sql:QueryTable 1 false false
Sample input message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:executeDriverQuery xmlns:ns2="http://sql.matrix.org/">
      <sql>{xs:string}</sql>
      <parameters>
        <parameters>
          <name>{xs:string}</name>
          <value>{xs:anyType}</value>
        </parameters>
      </parameters>
      <driver>{xs:string}</driver>
      <url>{xs:string}</url>
      <username>{xs:string}</username>
      <password>{xs:string}</password>
    </ns2:executeDriverQuery>
  </S:Body>
</S:Envelope>
Sample output message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:executeDriverQueryResponse xmlns:ns2="http://sql.matrix.org/">
      <queryTable>
        <columnName>{xs:string}</columnName>
        <queryRow>
          <values>{xs:anyType}</values>
        </queryRow>
      </queryTable>
    </ns2:executeDriverQueryResponse>
  </S:Body>
</S:Envelope>
Operation executeAliasQuery
Name: executeAliasQuery
Signature: executeAliasQuery (sql {xs:string}, parameters {sql:QueryParameters}, alias {xs:string}, username {xs:string}, password {xs:string}) => queryTable {sql:QueryTable}
Java signature: org.matrix.sql.QueryTable executeAliasQuery(String sql, org.matrix.sql.QueryParameters parameters, String alias, String username, String password)
Parameters:
name xml type occurs nillable read only references
sql xs:string 1 false false
parameters sql:QueryParameters 1 false false
alias xs:string 1 false false
username xs:string 1 false false
password xs:string 1 false false
Response:
name xml type occurs nillable read only references
queryTable sql:QueryTable 1 false false
Sample input message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:executeAliasQuery xmlns:ns2="http://sql.matrix.org/">
      <sql>{xs:string}</sql>
      <parameters>
        <parameters>
          <name>{xs:string}</name>
          <value>{xs:anyType}</value>
        </parameters>
      </parameters>
      <alias>{xs:string}</alias>
      <username>{xs:string}</username>
      <password>{xs:string}</password>
    </ns2:executeAliasQuery>
  </S:Body>
</S:Envelope>
Sample output message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:executeAliasQueryResponse xmlns:ns2="http://sql.matrix.org/">
      <queryTable>
        <columnName>{xs:string}</columnName>
        <queryRow>
          <values>{xs:anyType}</values>
        </queryRow>
      </queryTable>
    </ns2:executeAliasQueryResponse>
  </S:Body>
</S:Envelope>
Operation executeDriverUpdate
Name: executeDriverUpdate
Signature: executeDriverUpdate (sql {xs:string}, parameters {sql:QueryParameters}, driver {xs:string}, url {xs:string}, username {xs:string}, password {xs:string}) => numUpdated {xs:int}
Java signature: int executeDriverUpdate(String sql, org.matrix.sql.QueryParameters parameters, String driver, String url, String username, String password)
Parameters:
name xml type occurs nillable read only references
sql xs:string 1 false false
parameters sql:QueryParameters 1 false false
driver xs:string 1 false false
url xs:string 1 false false
username xs:string 1 false false
password xs:string 1 false false
Response:
name xml type occurs nillable read only references
numUpdated xs:int 1 false false
Sample input message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:executeDriverUpdate xmlns:ns2="http://sql.matrix.org/">
      <sql>{xs:string}</sql>
      <parameters>
        <parameters>
          <name>{xs:string}</name>
          <value>{xs:anyType}</value>
        </parameters>
      </parameters>
      <driver>{xs:string}</driver>
      <url>{xs:string}</url>
      <username>{xs:string}</username>
      <password>{xs:string}</password>
    </ns2:executeDriverUpdate>
  </S:Body>
</S:Envelope>
Sample output message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:executeDriverUpdateResponse xmlns:ns2="http://sql.matrix.org/">
      <numUpdated>{xs:int}</numUpdated>
    </ns2:executeDriverUpdateResponse>
  </S:Body>
</S:Envelope>
Operation executeAliasUpdate
Name: executeAliasUpdate
Signature: executeAliasUpdate (sql {xs:string}, parameters {sql:QueryParameters}, alias {xs:string}, username {xs:string}, password {xs:string}) => numUpdated {xs:int}
Java signature: int executeAliasUpdate(String sql, org.matrix.sql.QueryParameters parameters, String alias, String username, String password)
Parameters:
name xml type occurs nillable read only references
sql xs:string 1 false false
parameters sql:QueryParameters 1 false false
alias xs:string 1 false false
username xs:string 1 false false
password xs:string 1 false false
Response:
name xml type occurs nillable read only references
numUpdated xs:int 1 false false
Sample input message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:executeAliasUpdate xmlns:ns2="http://sql.matrix.org/">
      <sql>{xs:string}</sql>
      <parameters>
        <parameters>
          <name>{xs:string}</name>
          <value>{xs:anyType}</value>
        </parameters>
      </parameters>
      <alias>{xs:string}</alias>
      <username>{xs:string}</username>
      <password>{xs:string}</password>
    </ns2:executeAliasUpdate>
  </S:Body>
</S:Envelope>
Sample output message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:executeAliasUpdateResponse xmlns:ns2="http://sql.matrix.org/">
      <numUpdated>{xs:int}</numUpdated>
    </ns2:executeAliasUpdateResponse>
  </S:Body>
</S:Envelope>
Operation createConnection
Name: createConnection
Signature: createConnection (alias {xs:string}, driver {xs:string}, url {xs:string})
Java signature: void createConnection(String alias, String driver, String url)
Parameters:
name xml type occurs nillable read only references
alias xs:string 1 false false
driver xs:string 1 false false
url xs:string 1 false false
Sample input message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:createConnection xmlns:ns2="http://sql.matrix.org/">
      <alias>{xs:string}</alias>
      <driver>{xs:string}</driver>
      <url>{xs:string}</url>
    </ns2:createConnection>
  </S:Body>
</S:Envelope>
Sample output message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:createConnectionResponse xmlns:ns2="http://sql.matrix.org/">
    </ns2:createConnectionResponse>
  </S:Body>
</S:Envelope>
Operation removeConnection
Name: removeConnection
Signature: removeConnection (alias {xs:string})
Java signature: void removeConnection(String alias)
Parameters:
name xml type occurs nillable read only references
alias xs:string 1 false false
Sample input message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:removeConnection xmlns:ns2="http://sql.matrix.org/">
      <alias>{xs:string}</alias>
    </ns2:removeConnection>
  </S:Body>
</S:Envelope>
Sample output message: 
<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
  <S:Body>
    <ns2:removeConnectionResponse xmlns:ns2="http://sql.matrix.org/">
    </ns2:removeConnectionResponse>
  </S:Body>
</S:Envelope>

Ajuntament de Sant Feliu de Llobregat (C) 2025