Trigger updating same table sql server interest rate make consolidating eda
First of all, executing a java program from a trigger is a bad idea, because transactions must be short.Second, I'd guess the java program connects to database and performs some checks and updates, which is also a bad idea as it creates another transaction with its own locks.
That may release you from having put any locks on the table in the Java app...
If you think its expensive to hire a professional to do the job, wait until you hire an amateur.
-- Red Adair Not sure what you gain from the explicit transaction.
Third, java programs have its own problems, if not coded carefully.
It would be better if trigger performed all necessary checks.