All Forums Connectivity
B_Rock 2 posts Joined 04/12
31 Jan 2015
JDBC auto refresh

I'm building my firsh Java application using Teradata as the backend database. I would like to impliment an auto refresh feature, that would monitor a table in the database for changes and refresh the tableview I have in the application. I know TMM has an auto refresh. Does anyone know how this is accomplished?
Thanks for the help in advanced!
-Also I have had several people mention using a timer. That is like saying, do you want your email every 15 min, or do you want it pushed. I want it pushed.

tomnolan 594 posts Joined 01/08
02 Feb 2015

I don't know what TMM does, but a typical way to do what you're asking is to add a trigger to the table, and have the trigger add a row to a queue table. Your application would need a separate thread to wait on a query against the queue table.

You must sign in to leave a comment.