java - Excuting an operation automatically in database -


I have a form with resources, when one click is done, the blocked button at the end of the form, Along with DB updates the "blocked" in the form of a blocked timing and the present time then it waits for approval .... I need that the blocked position has not been changed to "Approved" within 10 days of blocked tiling Is it okay for it to be "approved" At the same time, when 10

now I have 2 options:

1) Is it possible to write DB trigger for this, if so how? How the trigger will be called

2) I am using struts2 so how can we write an action that is called on login / server startup and checks status and takes appropriate action .

Please suggest.

Write the code to trigger the debrez.

  Corn tab -> Unix, window scheduler - & gt; Windows.    

Comments

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

Matlab transpose a table vector -

c# - Textbox not clickable but editable -