更新競合の要素

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

例9.2に、例8.4の値を使用して、更新競合のXML要素の書式を示します。

例9.2

<repconflict>

    <header>

       <time>

          <hour>15</hour>

          <min>03</min>

          <sec>18</sec>

          <year>2002</year>

          <month>03</month>

          <day>25</day>

       </time>

       <datastore>/tmp/subscriberds</datastore>

       <transmitter>MASTERDS</transmitter>

       <table>

          <tableowner>REPL</tableowner>

          <tablename>TAB</tablename>

       </table>

    </header>

    <conflict type="update">

       <conflictingtimestamp>

          3C9FACB6000612B0

       </conflictingtimestamp>

       <existingtimestamp>3C9FACB600085CA0</existingtimestamp>

       <existingtuple>

          <column pos="1">

             <columnname>COL1</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>6</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>99</columnvalue>

          </column>

          <column pos="3">

             <columnname>TSTAMP</columnname>

             <columntype>BINARY(8)</columntype>

             <columnvalue>3C9FACB600085CA0></columnvalue>

          </column>

       </existingtuple>

       <conflictingtuple>

          <column pos="3">

             <columnname>TSTAMP</columnname>

             <columntype>BINARY(8)</columntype>

             <columnvalue>3C9FACB6000612B0</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>50</columnvalue>

          </column>

       </conflictingtuple>

       <oldtuple>

          <column pos="3">

             <columnname>TSTAMP</columnname>

             <columntype>BINARY(8)</columntype>

             <columnvalue>3C9FAC85000E01F0</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>2</columnvalue>

          </column>

       </oldtuple>

       <keyinfo>

          <column pos="1">

             <columnname>COL1</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>6</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>6</columnvalue>

             </column>

          </keyinfo>

          <column pos="3">

             <columnname>TSTAMP</columnname>

             <columntype>BINARY(8)</columntype>

             <columnvalue>3C9FACB6000612B0</columnvalue>

          </column>

          <column pos="2">

             <columnname>COL2</columnname>

             <columntype>NUMBER(38)</columntype>

             <columnvalue>50</columnvalue>

          </column>

       </update>

    </failedtransaction>

</repconflict>

---

前へ 次へ

Copyright © 2007, Oracle. All rights reserved.

目次 索引