one client app makes changes in a table in mysql and refresh the information in a tableview of anoth

e424e367-62fc-45da-975e-ccc16145d491

Crossposted:

• http://stackoverflow.com/questions/37537051/one-client-app-makes-changes-in-a-table-in-mysql-and-refresh-the-information-in

I got an JavaFX aplication that usally makes CRUD operations in to a MySQL data base, there are many users at the same time its rare but they could be working in the same type of object.

when the user makes changes to the data base table the view refresh with the changes and there is no problem, but the problem i have is when other user makes changes in the same table i dont know how to tell to the app that is time for a new conection to the data base and fetch the new data.

i could create a schedule service that make the data fetch every X time, but this is less than optimal i hope for a better solution.

so here is my question: how to tell the app a change is make in the data base and needs to get the new data? or there is better approach for share changes between clients apps ?