db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2350) Use of XML values in the action statement of a trigger throw exceptions.
Date Fri, 16 Feb 2007 22:55:05 GMT
Use of XML values in the action statement of a trigger throw exceptions.
------------------------------------------------------------------------

                 Key: DERBY-2350
                 URL: https://issues.apache.org/jira/browse/DERBY-2350
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.3.0.0
            Reporter: Daniel John Debrunner


A  trigger like, where V, V1 and V2 are columns of type XML will thrown an exception when
fired.

CREATE TRIGGER AIS AFTER INSERT ON T_MAIN 
                REFERENCING NEW_TABLE AS N
                FOR EACH STATEMENT  
                INSERT INTO T_ACTION_STATEMENT(A, V1, ID, V2) 
                SELECT 'I', V, ID, V FROM N

ERROR 38000: The exception 'java.sql.SQLException: An attempt was made to get a data value
of type 'java.lang.Object' from a data value of type 'XML'.' was thrown while evaluating an
expression.

Most likely because triggers are implementing using VTIs and hence JDBC ResultSets and XML
is not supported through JDBC yet.

TriggerTest shows this issue, see the comment with the bug number to reproduce.



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message