Hi,
I wonder how I should approach this abmiguousity problem. Let's say
that I have a trigger created into a database "A" like this:
CREATE TRIGGER IF NOT EXISTS UsersModifiedTrigger AFTER INSERT,
UPDATE, DELETE ON users FOR EACH ROW CALL "MyTrigger"
Now, MyTrigger's fire() method gets called whenever INSERT, UPDATE or
DELETE is performed on table "users". So far so good; I can fire some
kind of event that the GUI view of that table must be updated. But
let's then create another database, "B", which also contains a table
called "users", and a similar trigger. How can I distinguish whether
the event happened on the database A and B?
I think the key must be the Connection object - which I do get to the
Trigger. Then I could store some kind of UUID in all my databases to
distinguish between them, and retrieve it via the Connection, and
voilà, they have been separated. Is this a reasonable way to approach
the problem, or is there a more standard / direct route?
Best Regards,
Joonas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
