Do MES system, always will always have problems with concurrent cases inventory discrepancy,
Was born to the eldest brother is a bank, the proposed method is through to the stored procedure lock to reduce the occurrence of the situation,

But after I had finished my storage process, find it very difficult to maintain, really is to write at that time, maintain the crematorium,

Development of MES system again, and now I think it's inventory discrepancy in the storage process consumes the person heart,
Up everything BBS to inquire about:

Through the lock when the stored procedure to prevent concurrent dirty data, really is a good way to solve this?

CodePudding user response:

How is stored procedure lock?

CodePudding user response:

Stick the actual code, specific issues specific analysis,

CodePudding user response:

The

Hello World, 1/f, reference response:

stored procedures lock is how?

Just write a stored procedure, the place should have for it if written in the impl implementation layer things are written into the storage process, the lock when the dao layer invokes the stored procedures.

CodePudding user response:

Lock will affect concurrent,