Hi friends Its Vibhas and working on JSF although i am new to jfs but my problem some what related to java and database at the same time i dont know where exactly i post this question but still help me if any one knows it. I am currently working on Weblogic 9.2 server. My problem is i have a database table in which i have only read permission .
Now in my application i am connecting that database through jdbc connection (i.e in jsf itself). Now the problem is my application should run a continuous checking of that datatable to know that if any new entry is made in that table or not. That is i guess i have to write a script or something of that kind please help me . With some idea and if possible with some demo code to understand..
Thanks
This being a web app, you could use a servlet context listener to start a Timer with an associated TimerTask that runs every N minutes, performs the DB query, and then does whatever should be done if changes have happened.