[ http://issues.apache.org/jira/browse/DERBY-1718?page=comments#action_12436061 ] Suresh Thalamati commented on DERBY-1718: -----------------------------------------
I did a quick review of this patch. One change that caught my attention is the new format id added in this patch , I am wondering if this will cause any upgrade issues, if some one does soft-upgrade to 10.2, creates the trigger and then reverts back to 10.1 I think it should not cause any problems during recovery, because it is written as part of another higher level object (Storable Prepared Statement). Any one know if the new format id will cause any errors when building the stored prepared statement descriptors list or when the trigger gets executed on 10.1 ? Thanks -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
