RolleBolle
Programmer
Hi. Anyone knows a smart way to notify a program (in this case a Java-program) that a row in SQL has been changed? I am using InnoDB table and a JDBC bridge.
Thanks in advance!
Thanks in advance!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
update notification in SQL?
- Thread starter RolleBolle
- Start date
- Status
MichealC4
Programmer
- Jun 26, 2003
- 457
I'm lacking on my JDBC, but the theory should be simple enough.
1. You have a little daemon sitting out there, either part of your main program, or seperate from it that checks say once a minute for the table/field that you want to check, and then sets a bit flag.
2. The main program sees that bit flag, and in turn alerts you.
One way at least.
----------------------------
"Security is like an onion" - Unknown
1. You have a little daemon sitting out there, either part of your main program, or seperate from it that checks say once a minute for the table/field that you want to check, and then sets a bit flag.
2. The main program sees that bit flag, and in turn alerts you.
One way at least.
----------------------------
"Security is like an onion" - Unknown
- Status
Similar threads
- Locked
- Question