| Author |
DB2 Triggering java app.
|
Viswa Laksh
Greenhorn
Joined: Apr 30, 2003
Posts: 9
|
|
Is there any way to trigger a java application from DB2 while inserting one record?
Thanks,
Viswa
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26496
|
|
Viswa,
No. The database cannot trigger something on the app server.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
Dana Hanna
Ranch Hand
Joined: Feb 28, 2003
Posts: 227
|
|
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
internet detective
Marshal
Joined: May 26, 2003
Posts: 26496
|
|
Dana,
That's interesting. So you compile the java program on the db2 server and the trigger calls it?
|
|
 |
|
|
subject: DB2 Triggering java app.
|
|
|
0
