Trigger updating same table sql server interest rate make consolidating eda

posted by | Leave a comment

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.

trigger updating same table sql server-86trigger updating same table sql server-37trigger updating same table sql server-23

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.

Leave a Reply

Virtual sex on video chat