Élément d'en-tête sqloptions:environmentChangeNotifications

L'en-tête SOAP sqloptions:environmentChangeNotifications permet au client de préciser quelles notifications de modification d'environnement il souhaite recevoir, par exemple :

<SOAP-ENV:Header
  xmlns:SOAP-ENV="https://schemas.xmlsoap.org/soap/envelope/"
  xmlns:sqloptions="https://schemas.microsoft.com/sqlserver/2004/SOAP/Options">
    <sqloptions:environmentChangeNotifications  
         SOAP-ENV:mustUnderstand="1"
         databaseChange="true" | "false" 
         languageChange="true" | "false" 
         transactionBoundary="true" | "false"  />
</SOAP-ENV:Header>

L'option sqloptions:environmentChangeNotifications est affichée en tant qu'en-tête SOAP. L'en-tête est constitué d'un élément nommé sqloptions:environmentChangeNotifications. Cet élément présente quatre attributs facultatifs : databaseChange, languageChange, partnerChange et transactionBoundary ; chacun d'eux correspond à une valeur booléenne. La valeur par défaut de ces quatre attributs est false. Les attributs facultatifs permettent de spécifier les notifications que le client recevra.

Une demande ne peut comporter qu'une seule occurrence de l'option sqloptions:environmentChangeNotifications. L'option ne peut pas figurer dans une réponse. Plusieurs occurrences de l'option engendreront une erreur, tout comme l'existence de contenu dans le nœud sqloptions:environmentChangeNotifications.

Si des sessions SOAP sont utilisées, cette option doit figurer dans la même demande que l'attribut sqloptions:sqlsession initiate. Si elle apparaît dans une demande assortie d'un en-tête sqloptions:sqlSession qui ne contient pas également l'attribut initiate, une erreur est générée.

Voici un fragment de schéma relatif à l'option sqloptions:environmentChangeNotifications :

<xs:element name="environmentChangeNotifications" form="qualified">
    <xs:annotation>
        <xs:documentation>
            Receive environment change notifications.
        </xs:documentation>
    </xs:annotation>
    <xs:complexType>
        <xs:attribute
          name="databaseChange"
          default="false"
          type="xs:boolean"
          form="unqualified">
            <xs:annotation>
                <xs:documentation>
                    Receive notifications of database changes.
                </xs:documentation>
            </xs:annotation>
        </xs:attribute>
        <xs:attribute
          name="languageChange"
          default="false"
          type="xs:boolean"
          form="unqualified">
            <xs:annotation>
                <xs:documentation>
                    Receive notifications of language changes.
                </xs:documentation>
            </xs:annotation>
        </xs:attribute>
        <xs:attribute
          name="transactionBoundary"
          default="false"
          type="xs:boolean"
          form="unqualified">
            <xs:annotation>
                <xs:documentation>
                    Receive notifications of transaction boundaries.
                </xs:documentation>
            </xs:annotation>
        </xs:attribute>
        <xs:attribute name="partnerChange" default="false" type="xsd:boolean" form="unqualified">
            <xs:annotation>
                <xs:documentation>Receive notifications of partner changes.</xs:documentation> 
            </xs:annotation>
         </xs:attribute>
    </xs:complexType>
</xs:element>

Exemples

Dans les exemples suivants, l'en-tête sqloptions:environmentChangeNotifications est utilisé dans des messages de demande et de réponse SOAP.

Demande

POST !HTTPURL! HTTP/1.1
Content-Type: text/xml
Host: !SERVERNAME!
SOAPAction: "https://schemas.microsoft.com/sqlserver/2004/SOAPsqlbatch"
<SOAP-ENV:Envelope  xmlns:SOAP-ENV="https://schemas.xmlsoap.org/soap/envelope/"
                                        xmlns:sql="https://schemas.microsoft.com/sqlserver/2004/SOAP"
                                        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                                        xmlns:sqlparam="https://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlParameter"
                                        xmlns:sqlsoaptypes="https://schemas.microsoft.com/sqlserver/2004/SOAP/types"
                                        xmlns:sqloptions="https://schemas.microsoft.com/sqlserver/2004/SOAP/Options"
> 
  <SOAP-ENV:Header>
    <sqloptions:environmentChangeNotifications  
         SOAP-ENV:mustUnderstand="1"
         databaseChange="true" 
         languageChange="true" 
         transactionBoundary="true" />
  </SOAP-ENV:Header>
  <SOAP-ENV:Body>
    <sql:sqlbatch>
      <sql:BatchCommands>
         SET LANGUAGE Italian
         SELECT @@LANGUAGE as lang   
         USE  AdventureWorks
         BEGIN TRANSACTION testTransaction
         SELECT @@LANGUAGE as language
         COMMIT TRANSACTION testTransaction
       </sql:BatchCommands>
     </sql:sqlbatch>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Réponse

<Response>
  <Version>HTTP/1.1</Version>
  <Status>200</Status>
  <StatusText>OK</StatusText>
  <Headers>
    <Content-Type>text/xml; charset=utf-8</Content-Type>
    <Date>exists</Date>
    <Server>Microsoft-SQL/9.0 Microsoft-HTTPAPI/1.0</Server>
    <Transfer-Encoding>chunked</Transfer-Encoding>
  </Headers>
  <Body>
    <SOAP-ENV:Envelope xml:space="preserve" 
                       xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
                       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
                       xmlns:SOAP-ENV="https://schemas.xmlsoap.org/soap/envelope/" 
                       xmlns:sql="https://schemas.microsoft.com/sqlserver/2004/SOAP" 
                       xmlns:sqlsoaptypes="https://schemas.microsoft.com/sqlserver/2004/SOAP/types" 
                       xmlns:sqlrowcount="https://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlRowCount" 
                       xmlns:sqlmessage="https://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage" 
                       xmlns:sqlresultstream="https://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlResultStream" 
                       xmlns:sqltransaction="https://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlTransaction" 
                       xmlns:sqltypes="https://schemas.microsoft.com/sqlserver/2004/sqltypes">
      <SOAP-ENV:Body>
        <sql:sqlbatchResponse>
          <sql:sqlbatchResult>
            <sqlresultstream:SqlMessage xsi:type="sqlmessage:SqlMessage">
              <sqlmessage:Class>0</sqlmessage:Class>
              <sqlmessage:LineNumber>0</sqlmessage:LineNumber>
              <sqlmessage:Message>Changed language setting to Italiano.</sqlmessage:Message>
              <sqlmessage:Number>5703</sqlmessage:Number>
              <sqlmessage:Source>Microsoft-SQL/9.0</sqlmessage:Source>
              <sqlmessage:State>1</sqlmessage:State>
            </sqlresultstream:SqlMessage>
            <sqlresultstream:SqlRowSet xsi:type="sqlsoaptypes:SqlRowSet">
              <diffgr:diffgram xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
                <SqlRowSet1 xmlns="urn:schemas-microsoft-com:sql:SqlRowSet1">
                  <row>
                    <lang>Italiano</lang>
                  </row>
                </SqlRowSet1>
              </diffgr:diffgram>
            </sqlresultstream:SqlRowSet>
            <sqlresultstream:SqlRowCount xsi:type="sqlrowcount:SqlRowCount">
              <sqlrowcount:Count>1</sqlrowcount:Count>
            </sqlresultstream:SqlRowCount>
            <sqlresultstream:SqlMessage xsi:type="sqlmessage:SqlMessage">
              <sqlmessage:Class>0</sqlmessage:Class>
              <sqlmessage:LineNumber>0</sqlmessage:LineNumber>
              <sqlmessage:Message>Changed database context to 'Northwind'.</sqlmessage:Message>
              <sqlmessage:Number>5701</sqlmessage:Number>
              <sqlmessage:Source>Microsoft-SQL/9.0</sqlmessage:Source>
              <sqlmessage:State>1</sqlmessage:State>
            </sqlresultstream:SqlMessage>
            <sqlresultstream:SqlTransaction xsi:type="sqltransaction:SqlTransaction">
              <sqltransaction:Descriptor>asdf</sqltransaction:Descriptor>
              <sqltransaction:Type>Begin</sqltransaction:Type>
            </sqlresultstream:SqlTransaction>
            <sqlresultstream:SqlRowSet xsi:type="sqlsoaptypes:SqlRowSet">
              <diffgr:diffgram xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
                <SqlRowSet2 xmlns="urn:schemas-microsoft-com:sql:SqlRowSet2">
                  <row>
                    <language>Italiano</language>
                  </row>
                </SqlRowSet2>
              </diffgr:diffgram>
            </sqlresultstream:SqlRowSet>
            <sqlresultstream:SqlRowCount xsi:type="sqlrowcount:SqlRowCount">
              <sqlrowcount:Count>1</sqlrowcount:Count>
            </sqlresultstream:SqlRowCount>
            <sqlresultstream:SqlTransaction xsi:type="sqltransaction:SqlTransaction">
              <sqltransaction:Descriptor>asdf</sqltransaction:Descriptor>
              <sqltransaction:Type>Commit</sqltransaction:Type>
            </sqlresultstream:SqlTransaction>
          </sql:sqlbatchResult>
        </sql:sqlbatchResponse>
      </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>
  </Body>
</Response>

Voir aussi

Référence

En-têtes d'extension SOAP

Aide et Informations

Assistance sur SQL Server 2005

Last updated on 2008-12-15

Partager via