JDBC auto refresh

Connectivity
Fan

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.

Tags (1)
1 REPLY
Teradata Employee

Re: JDBC auto refresh

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.