Queuing

[kaleeswaran]

hi
i working in banking domain.i need to do some control in transaction.like for example In Saving Account:i can withdraw and Deposit the Amount.
so when two user doing transaction at same time for the same account number.i have to control it.so for that i need to do some queuing operation i think,
i don't have much knowledge in this.
what shall i do..
Thank you,
Kaleeswaran

[debasisdas]

what about using LOCKING to avoid concurrent transactions.

[kaleeswaran]

what about using LOCKING to avoid concurrent transactions.

Thank you for Reply,

i am using java struts,so you meant to say i have to do locking function in the action class or any locking function is there in MySql.

Please clarify me regarding Locking...

if i want to use Locking in Action Class,How do i Implement it.because for example in Saving Account Module i have separate table for Withdrawing and Depositing the Money.both the things are in doing different action class..

Thank you,

[Atli]

Check out the LOCK TABLES and UNLOCK TABLES Syntax in the MySQL manual.

[kaleeswaran]

Hi

Thank you for reply,but i want to lock the particular field only right?..not the whole table correct.if suppose some different users uses different account number.it should allow for further process.i want to restrict only for the particular account number..
Thank you,
kaleeswaran