Return-Path: 
 <derby-dev-return-30094-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 46258 invoked from network); 19 Sep 2006 00:24:01 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 19 Sep 2006 00:24:01 -0000
Received: (qmail 95092 invoked by uid 500); 19 Sep 2006 00:24:00 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 95060 invoked by uid 500); 19 Sep 2006 00:24:00 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 95047 invoked by uid 99); 19 Sep 2006 00:24:00 -0000
Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org)
 (140.211.166.84)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Sep 2006 17:24:00 -0700
X-Macro: 0.0.0.0 = 140.211.166.113
X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests=
Received: from ([209.237.227.198:51573] helo=brutus.apache.org)
	by idunn.apache.osuosl.org (ecelerity 2.1 r(10620)) with ESMTP
	id 16/00-24714-E983F054 for <derby-dev@db.apache.org>;
 Mon, 18 Sep 2006 17:23:58 -0700
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 88EAC714303
	for <derby-dev@db.apache.org>; Tue, 19 Sep 2006 00:20:24 +0000 (GMT)
Message-ID: <228877.1158625224558.JavaMail.jira@brutus>
Date: Mon, 18 Sep 2006 17:20:24 -0700 (PDT)
From: "Suresh Thalamati (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-1718) creating an after insert trigger
 with trigger action involving  xml datatype throws
  java.io.NottSerializableException
In-Reply-To: <26324803.1155849214740.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

    [ http://issues.apache.org/jira/browse/DERBY-1718?page=comments#action_12435616 ] 
            
Suresh Thalamati commented on DERBY-1718:
-----------------------------------------

Thanks for working on this issue Yip. I will  run derbyall and commit the patch.  Thanks  a lot   for taking time to review the patch , Army. 

/suresh


> creating an after insert trigger with trigger action involving  xml datatype throws  java.io.NottSerializableException
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1718
>                 URL: http://issues.apache.org/jira/browse/DERBY-1718
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.0.0, 10.2.2.0
>         Environment: Java Version:    1.4.2
> Java Vendor:     IBM Corporation
>            Reporter: Suresh Thalamati
>         Assigned To: Yip Ng
>             Fix For: 10.2.1.0
>
>         Attachments: derby1718-trunk-diff01.txt, derby1718-trunk-diff02.txt, derby1718-trunk-stat01.txt, derby1718-trunk-stat02.txt, stk.txt
>
>
> 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));

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira