Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1718

creating an after insert trigger with trigger action involving xml datatype throws java.io.NottSerializableException

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6, 10.3.1.4
    • Fix Version/s: 10.2.1.6, 10.3.1.4
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Java Version: 1.4.2
      Java Vendor: IBM Corporation

      Description

      creating an after insert trigger with trigger action involving xml datatype throws following error :
      ij> create trigger trigxml after insert on t1 for each statement mode db2sql
      insert into t2 values (1,
      xmlparse(document '<name> ram </name>' preserve whitespace));
      ERROR XSDAJ: Exception during write of a serializable or SQLData object
      ERROR XJ001: Java exception: 'org.apache.derby.iapi.types.SqlXmlUtil: java.io.No
      ton'.SerializableExcepti
      ij>

      repro:
      connect 'jdbc:derby:wombat;create=true';
      create table t1 (i int, x xml);
      create table t2 (i int, x xml);

      insert into t2 values (1,
      xmlparse(document '<name> suresh </name>' preserve whitespace));
      — following trigger creation is failing ,.
      create trigger trigxml after insert on t1 for each statement mode db2sql
      insert into t2 values (1,
      xmlparse(document '<name> ram </name>' preserve whitespace));

        Attachments

        1. ASF.LICENSE.NOT.GRANTED--stk.txt
          7 kB
          Suresh Thalamati
        2. derby1718-trunk-diff01.txt
          11 kB
          Yip Ng
        3. derby1718-trunk-stat01.txt
          0.5 kB
          Yip Ng
        4. derby1718-trunk-diff02.txt
          16 kB
          Yip Ng
        5. derby1718-trunk-stat02.txt
          0.7 kB
          Yip Ng

          Activity

            People

            • Assignee:
              yipng Yip Ng
              Reporter:
              tsuresh Suresh Thalamati
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: