Is there a way to listen for changes in an MySQL database table using Java and JDBC?
- by adrian7
I have a number of users which are logged in at a time in my desktop application.
They are working on the same table (create, read, update, delete data) so I have to update their views, to reflect changes, every few seconds - currently I am thinking to use a different thread to do that.
I am using the MySQL database engine.
Is there a way, using JDBC, to listen for changes on a specific table in the database and triggering a Java method only when changes are made?