[ 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