background process using thread

I want to continuously check a table in the database to see whether a new row ha开发者_StackOverflow社区s been added to it. This runs as a back ground process. I think a thread should be used for this task. but I have no idea how to write the code. Can somebody help me with this please?

Well, you're not really giving us much to go on here.

You might find it easier to use a database trigger, which will fire some code whenever a specified action occurs (e.g. insertion of new data). You will need to look up details for your specific database.

I just realised that you have probably already tried to use triggers and failed: sql trigger not work as expected. Either approach will work, but I would prefer keeping everything in the DB and avoiding external processes if possible.

What should happen if an insert occurs but your process has died for some reason?

Oracle can now communicate to Java via listener. So if you register for some event, your Java listener will receive that event from the database.