1

Does anyone have a code sample of a multithreading case that has about 25 threads that monitor a specific table in the database for a change then execute a process based on that change?

ed0
  • 49
  • 2

3 Answers3

1

If you just want to be notified in the client application that something has changed in the database and you need to react on that in the application itself (so that triggers are not an option) you can use Oracle's change notification.

In order to do that, you register a listener with the JDBC driver specifying the "result set" that should be monitored. That listener will be called whenever something changes in the database.

For details on how this works, see the manual:

http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/dbmgmnt.htm#CHDEJECF

  • how to do with non-oracle dbs? – Suraj Chandran Sep 06 '11 at 10:52
  • The only other DBMS I know that has something similar is PostgreSQL with the LISTEN/NOTIFY concept: http://www.postgresql.org/docs/current/static/sql-listen.html (which is available through JDBC as well) –  Sep 06 '11 at 11:46
0

Try directly using a Database Trigger instead.

Check this question about getting events in java from Database

Community
  • 1
  • 1
Suraj Chandran
  • 24,433
  • 12
  • 63
  • 94
  • @ed0 U can create a change trigger on a table. When the change occurs your trigger will be notified and u can execute any storedproc or sql on it – Suraj Chandran Sep 06 '11 at 08:29
  • The thing is I want the threads to recieve their jobs from the db for example if a certain field in the table reads available a certain a certain process on the Java side is to run and when it finishes it updates the db as completed. The process I want to run cannot be executed by a stored procedure. It can only happen on the Java side – ed0 Sep 06 '11 at 08:48
  • @ed0 i have update my answer to add another link that explains how to get db events in java – Suraj Chandran Sep 06 '11 at 08:51
0

If you want to monitor the table (in the database) and make changes also in the database, then you should really consider Triggers.

Simply, Triggers are kind of procedures that run automatically BEFORE or AFTER changes on a table. You can monitor UPDATE, INSERT or DELETE transactions and then make your action.

Here is Simple tutorial on Oracle Triggers

mohdajami
  • 9,604
  • 3
  • 32
  • 53
  • The thing is I want the threads to recieve their jobs from the db for example if a certain field in the table reads available a certain a certain process on the Java side is to run and when it finishes it updates the db as completed – ed0 Sep 06 '11 at 08:37