Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling Java Application from Database trigger

 
Kamal Bahadur
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am trying to execute my java application once a reco5rd is inserted into a database table. For that sake i am planning to write a Trigger which will be called while inserting. My question is that, will i be able to call a java application from this trigger???

--
Kamal
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That depends on the database you use. Some databases support triggers written in Java (e.g., Oracle and PostgreSQL do, or have extensions that enable it). Check the manual for your database what kind of languages it supports for triggers. Maybe there is a way to call a Java program via a shell script or JNI, although I would be very hesitant to do this from a design point of view.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic