db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Suresh Thalamati (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1718) creating an after insert trigger with trigger action involving xml datatype throws java.io.NottSerializableException
Date Tue, 19 Sep 2006 23:44:23 GMT
    [ 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

        

Mime
View raw message