Bookmark Topic Watch Topic
  • New Topic

to listen database table by java

 
Jyoti Sharma
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi,

I need to watch a table i.e., whenever there is insert in a table my java code will do some actions. For this I am planning to use while(true) loop. In this infinite loop I will select data from table. If there is some new insert in table, I will perform my functions and will continue to do this whenever there is a new insert in table.

My code will run forever and there will be scheduled shutdown in a week and will be restarted in 5 - 10 minutes.

Is it a right approach to use while(true) ?
Any other way to listen database table ?

Note: database is Teradata (RDBMS) and not Oracle
Thanks,
Jyoti
 
Prabhakar Reddy Bokka
Ranch Hand
Posts: 197
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Report post to moderator
That is definitely not a right approach.

Check out with the hibernate.
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Report post to moderator
Duplicate of http://www.coderanch.com/t/499406/Performance/java/while-true. Closing this topic.
 
    Bookmark Topic Watch Topic
  • New Topic