We have telephony system developed for dialing numbers and do activities on lines like play message, transfer calls calls. This is C++ application talks to MySQL database for configuration & call details records etc.. Currently, I have web interface for configuration purpose which is built using PHP/HTML/CSS/Ajax stuff.
What I'm looking for is this - I need to have a web interface where I can display call status of telephony lines without having any manual refresh on web page. Let's say Telephony system(C++ application) is running with 20 lines then we need to see status of all lines in one page like Dialing, Transfering etc...
There are several ways to implement this and I'm looking best possible one !. I can have telephony system to write all activities in a table on DB server and web interface can then just poll that table and display status but this is not the very good way. If we use Java technology on web server side then I can have telephony system talk to it on socket directly without adding unnecessary load on database and then we can use comet to push data back to browser. Or Use comet but poll to DB with less frequent intervals.
In reality, there might be number of telephony systems (C++ application) and all can talk to same web server so using socket mechanism also may not be efficient. But I can easily write status into MySQL table. Status change will not be too much. it's like 2 times change per call ..that's it.
I will have multiple DB servers and current web server is running with PHP stuff so we can do redirect to another server where Glassfish stuff will run for status display purpose.
If you think you can convert exiting PHP stuff into Java as well that would be even better.
I recently came across comet technology and looking someone expert who can help me completing this work. Current web configuration related stuff is in PHP but I don't want to use PHP anymore. It will be better to land in Java space as I may add few other things in future. If you have experience and understand my requirement please respond me back with another better approach if you have any.
This is small project and may continue more work in future but please respond only if you have Java/J2EE experience atleast 5 years and know things inside out.