I have a requirement , in which .
I am showing a JSP page , on its onload Method i am getting the Data from Database and showing it .
The data might change continously inside Databse , Now my requirement is ,when ever there is a change inside Database data on to that particular table , i need to show that Latest data in my JSP page also .
Means , whenever there is a change in Database , i need to referesh the JSP Page to show these latest values .
(A site similar to Stock Exchnage)
what is the way to approach this ??
Waiting for your replies . Thanks .
Try out AJAX approach.
Okay you told AJAX , , tell me how AJAX suits here , how can i add a monitor on to my Database Tables with AJAX ??
I bet AJAX doesn't suit here .
Is there any reason you don't do what I imagine most stock exchange type sites do which is to reload the data at certain time intervals (every 5s, 60s or whatever) using ajax?
How do you think it can be used? People are trying to help you in this topic and you are seemingly putting no effort into helping yourself.
Thats why i asked how AJAX can be used here ( as i am not new to AJAX , so i am sure that AJAX doesn't suit here )
See Boss , for example , if i tell use java Cloning , i must also say that how to use it with a scenario .
Hope this helps.
" whenever there is a change in Database , i need to referesh the JSP Page to show these latest values . "
but i dont want it to periodically refreshing .
Thank you all for your help , really i was being some modest with the replies from all of you .
actually i wanted the below thing
Is there any way , we can call a Servlet or a JSP from a Databse trigger .
Ravi Kiran Pattu wrote:Is there any way , we can call a Servlet or a JSP from a Databse trigger .
And what would you do with this servlet or JSP if you could call it?
Think about it, I'm sitting looking at your page, my browser has html, it knows absolutely nothing about JSP or servlets, there is no connection between your sever and my browser once the page has been loaded until another request is sent to the server.
my browser has html, it knows absolutely nothing about JSP or servlets, there is no connection between your sever and my browser once the page has been loaded until another request is sent to the server.
I agree with you Sean , this was a good point .
I agree perodical refresh is the only solution . Thank you all of you .