0

I am building a customer support web application (java based) where I need to show all "Customer Representative(CR)" status (available, busy, away in phone) in the front-end.

If CR terminates the call after talking to someone, status will get updated in my database. At the same time, it should get reflected in front-end as well.

  1. Ajax may be one option to keep on polling Database for CR status.

Is there any other approach available to make this work?

Rohit Gupta
  • 4,022
  • 20
  • 31
  • 41
Vijai P
  • 1
  • 2
  • 1
    I think you should take a look to _websocket_ protocol – RickyGo Oct 02 '15 at 07:15
  • I gone through websocket sample example(url below). Which explained about front-end to server communication without refresh page. But in my case , i need to get data from dataBase whenever gets updated. (http://www.oracle.com/webfolder/technetwork/tutorials/obe/java/HomeWebsocket/WebsocketHome.html#) – Vijai P Oct 02 '15 at 08:16

1 Answers1

1

Your solution is fine, usually. From your comment, it seems that you are using Oracle, which (depending on the edition) may have the ability to call a web service. So you can create a trigger in the DB, that trigger will fire back in your app ...

Radu Dumitriu
  • 116
  • 5
  • how about this one http://www.gianlucaguarini.com/blog/push-notification-server-streaming-on-a-mysql-database/ – Vijai P Oct 02 '15 at 09:41