削除/更新競合の要素

削除/更新競合は、更新対象の行が更新を受信するデータ・ストアですでに削除されているため、更新のレプリケートが正常に実行されなかった場合、または行が最近更新されたため、削除のレプリケートが正常に実行されなかった場合に発生します。削除/更新競合の競合レポートに書き込まれる情報については、「削除/更新競合のレポート」を参照してください。

例9.3に、例8.5の値を使用して、行が最近削除されたため、更新が正常に実行されなかった削除/更新競合のXML要素の書式を示します。

例9.3

<repconflict>

   <header>

       <time>

          <hour>15</hour>

          <min>27</min>

          <sec>05</sec>

          <year>2002</year>

          <month>03</month>

          <day>25</day>

       </time>

       <datastore>/tmp/masterds</datastore>

       <transmitter>SUBSCRIBERDS</transmitter>

       <table>

          <tableowner>REPL</tableowner>

          <tablename>TAB</tablename>

       </table>

   </header>

   <conflict type="update">

       <conflictingtimestamp>

          3C9FB2460000AFC8

       </conflictingtimestamp>

       <conflictingtuple>

          <column pos="3">

             <columnname>TSTAMP</columnname>

             <columntype>BINARY(8)</columntype>

             <columnvalue>3C9FB2460000AFC8</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>99/columnvalue>

          </column>

       </conflictingtuple>

       <keyinfo>

          <column pos="1">

             <columnname>COL1</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>2</columnvalue>

          </column>

       </keyinfo>

    </conflict>

    <scope>TRANSACTION</scope>

    <failedtransaction>

       <update>

          <sql>Update table REPL.TAB</sql>

          <keyinfo>

             <column pos="1">

                <columnname>COL1</columnname>

                <columntype>NUMBER(38)</columntype>

                <columnvalue>2</columnvalue>

             </column>

          </keyinfo>

          <column pos="3">

             <columnname>TSTAMP</columnname>

             <columntype>BINARY(8)</columntype>

             <columnvalue>3C9FB2460000AFC8</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>99</columnvalue>

          </column>

         </update>

   </failedtransaction>

</repconflict>

例9.4に、例8.6の値を使用して、行が最近更新されたため、削除が正常に実行されなかった削除/更新競合のXML要素の書式を示します。

例9.4

<repconflict>

   <header>

       <time>

          <hour>15</hour>

          <min>27</min>

          <sec>20</sec>

          <year>2002</year>

          <month>03</month>

          <day>25</day>

       </time>

       <datastore>/tmp/masterds</datastore>

       <transmitter>MASTERDS</transmitter>

       <table>

          <tableowner>REPL</tableowner>

          <tablename>TAB</tablename>

       </table>

   </header>

   <conflict type="delete">

       <conflictingtimestamp>

          3C9FB258000708C8

       </conflictingtimestamp>

       <existingtimestamp>3C9FB25800086858</existingtimestamp>

       <existingtuple>

          <column pos="1">

             <columnname>COL1</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>147</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>99</columnvalue>

          </column>

          <column pos="3">

             <columnname>TSTAMP</columnname>

             <columntype>BINARY(8)</columntype>

             <columnvalue>3C9FB25800086858</columnvalue>

          </column>

       </existingtuple>

       <keyinfo>

          <column pos="1">

             <columnname>COL1</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>147</columnvalue>

          </column>

       </keyinfo>

    </conflict>

    <scope>TRANSACTION</scope>

    <failedtransaction>

       <delete>

          <sql>Delete from table REPL.TAB</sql>

          <keyinfo>

             <column pos="1">

                <columnname>COL1</columnname>

                <columntype>NUMBER(38)</columntype>

                <columnvalue>147</columnvalue>

             </column>

          </keyinfo>

       </delete>

    </failedtransaction>

</repconflict>

---

前へ 次へ

Copyright © 2007, Oracle. All rights reserved.

目次 索引