• Post Reply Bookmark Topic Watch Topic
  • New Topic

DB2 Triggering java app.  RSS feed

 
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
 
author & internet detective
Marshal
Posts: 37708
578
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.
 
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
Marshal
Posts: 37708
578
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?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!