You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Jeremy Boynes <jb...@gluecode.com> on 2004/08/27 19:39:38 UTC
Geronimo integration
Have you considered integration with Geronimo yet?
We are currently using Axion but I would be interested in offering Derby
as an alternative. Areas for integration could include:
* RAR packaging for a Derby-specific datasource
* Integration into Geronimo management framework
* Use as backing for persistent services (e.g. EJB Timers, config, ...)
I am sure there are other points as well.
Would you see these type of things as belonging in Derby or Geronimo?
--
Jeremy
jboynes@apache.org
Re: Trigger Bug Fix
Posted by Daniel John Debrunner <dj...@debrunners.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
| Jack Klebanoff wrote:
|
| | I would like to submit a fix for a bug in triggers.
| |
| | The bug is that a trigger of the form:
| | create trigger ... values myFunction();
| | has no effect. MyFunction is not called even if the trigger is fired.
| | Side effects of myFunction do not happen. Derby does not allow a "CALL"
| | statement inside a trigger action so a values statement is the only way
| | to call a function/procedure in a trigger action.
| |
| | The cause of the bug is that since the values are not actually used by
| | the trigger, the trigger code does not fetch the row(s) returned by the
| | trigger action. The fix is simple: change class
| | org.apache.derby.impl.sql.execute.GenericTriggerExecutor to fetch (and
| | discard) the rows returned by a trigger action.
| |
| | Please review the change. The diff file is attached.
I tried out the second diff with a simple example and it did fix the bug.
+1
Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFBM5Q1Iv0S4qsbfuQRAioLAKDd+QPUHF/Tsy7ntMwznQ3x/wTqbACeIjHq
CTciSb8RcFMsJE6bJQ9xh+0=
=/070
-----END PGP SIGNATURE-----