db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tony Seebregts <to...@cibecs.com>
Subject Triggers and BLOB's
Date Thu, 08 Dec 2005 11:17:59 GMT
Hi,

I'm trying to copy a BLOB column to another table from the trigger row
in an AFTER INSERT trigger and am getting the following error:

SQL Exception: An attempt was made to put a data value of type
'org.apache.derby.impl.jdbc.EmbedBlob' into a data value of type 'BLOB'.

The trigger statement looks like:

CREATE TRIGGER tableTrigger
       AFTER INSERT ON testTable
       REFERENCING NEW AS TriggerRow
       FOR EACH ROW
       MODE DB2SQL
       INSERT INTO anotherTable (name,info)
                     VALUES (TriggerRow.name.TriggerRow.info)

Any idea what is wrong or if there is any way to make this work ?

regards

Tony Seebregts  

Mime
View raw message