• Post Reply Bookmark Topic Watch Topic
  • New Topic

DB2 Triggering java app.

 
Viswa Laksh
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there any way to trigger a java application from DB2 while inserting one record?

Thanks,
Viswa
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36027
430
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Viswa,
No. The database cannot trigger something on the app server.
 
Dana Hanna
Ranch Hand
Posts: 227
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
DB2 has supported java triggers since version 5.2. You can create a trigger that does what you'd like - but you're best off keeping it simple (if you want heavy stuff done, use the trigger to put a message in a queue - or a "queue" table that the other process polls and processes.

Get it>?
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36027
430
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dana,
That's interesting. So you compile the java program on the db2 server and the trigger calls it?
 
Maybe he went home and went to bed. And took this tiny ad with him:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!