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 Thu, 27 Apr 2006 00:08:58 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

------------------------------------------------------------------------------
   * [http://issues.apache.org/jira/browse/DERBY-1258 DERBY-1258] Since accessing columns
is through JDBC for row triggers, columns with identical upper-cased names are not handled
correctly.
  
  === Possible Changes ===
-  * Re-write triggers to not add the indirection through JDBC !ResultSet. Have old/new references
in action statements compile to specific !QueryTree nodes that access the data directly from
a Derby language !ResultSet.
+  * Re-write triggers to not add the indirection through JDBC !ResultSet. Have old/new references
in action statements compile to specific !QueryTree nodes that access the data directly from
a Derby language !ResultSet. Would need to investigate how to handle existing triggers at
upgrade time.
   * Continue with JDBC approach and add code as required to fix issues, e.g. a internal specific
!findColumn implementation that doesn't match JDBC but instead matches column on absolute
name. Might still require a wrapper JDBC object.
  

Mime
View raw message