db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: [jira] Created: (DERBY-438) Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement references the blob column(s).
Date Sat, 02 Jul 2005 00:14:42 GMT
A B (JIRA) wrote:

> Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement
references the blob column(s).

I'm suprised this is not documented, BLOB and CLOB columns do not work
with triggers. This is because within the database engine, there is no
mechanism to create a java.sql.Blob object (or Clob) from a SQL BLOB
(CLOB) datatype. The java.sql.Blob returned from a ResultSet is handled
at the JDBC layer, not within the engine. This is the same reason as to
why BLOB and CLOB types cannot be passed into a method or function.

Dan.


Mime
View raw message