Re: java replication app



> Does Java have some kind of event-driven api for this sort of thing?

No it doesn't. Neither does any other programming language/database
access library. Databases aren't supposed to do that.

You could conceivably write a trigger that notifies an external
app/library that a row has been updated/inserted, but you don't want
that either. It will mean a lot of overhead and it will most probably
noticeably affect the performance of insert/update operations. Do you
think it's worth it?

Instead you could just poll the table you're interested in and see if
anything has been added/modified; a trigger to update a timestamp would
be quite enough then.

Alin,
The jTDS Project.

.



Relevant Pages

  • Re: oldest American skull found!
    ... > Trigger was a horse, you dummy, not his great aunt. ... It's sort of like the bone reliquiae of various saints on ... > display in churches and museums all over Italy. ... > important enough to have his/hers bones displayed in a museum. ...
    (sci.archaeology)
  • Re: oldest American skull found!
    ... > Trigger was a horse, you dummy, not his great aunt. ... It's sort of like the bone reliquiae of various saints on ... > display in churches and museums all over Italy. ... > important enough to have his/hers bones displayed in a museum. ...
    (sci.anthropology)
  • Re: oldest American skull found!
    ... > Trigger was a horse, you dummy, not his great aunt. ... It's sort of like the bone reliquiae of various saints on ... > display in churches and museums all over Italy. ... > important enough to have his/hers bones displayed in a museum. ...
    (sci.anthropology.paleo)
  • Re: Sony KV27S15 died
    ... I did resolder the transformers so if that caused the original ... It's hard to say with this sort of thing, there can be a lot of different ... events which can trigger a catastrophic chain reaction failure. ...
    (sci.electronics.repair)
  • Re: trigger on alter user
    ... In one of our databases we need 1 user to reset passwords from other ... (some kind of admin function). ... a trigger which checks whether the user to be ...
    (comp.databases.oracle.misc)

Loading