db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "TriggerImplementation" by DanDebrunner
Date Fri, 28 Apr 2006 19:13:57 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by DanDebrunner:
http://wiki.apache.org/db-derby/TriggerImplementation

------------------------------------------------------------------------------
  new.x  -->> cast (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getNewRow().getObject('X')
AS <type> )
  }}}
  
+ For 10.2 onwards (svn revision 397959, DERBY-1258), value fetched by column position.
+ {{{
+ old.x  -->> CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getOldRow().getObject(<n>)
AS <type> )
+ new.x  -->> CAST (org.apache.derby.iapi.db.Factory::getTriggerExecutionContext().getNewRow().getObject(<n>)
AS <type> )
+ }}}
  
  For statement triggers the reference to the new or old table is re-written to use Derby's
internal support for Virtual Tables.
  !TriggerOldTransitionRows and !TriggerNewTransitionRows classes implement java.sql.!ResultSet
and thus can be used

Mime
View raw message