Hi All.
In our application we are using Java as backend layer.
We have a requirement to allow several operations in a database and changes should be commited only after the user's click on "Save" button.
We obey above requirement by the use of transactionality in DB.
However, we are facing an issues with locks.
When user1 is editing "card1 object" and user2 wants to edit "card2 object" sometimes user2 is even not able to read data from table containing "card objects".
We are not using any "lock table" command.
Is there any limit of number of rows changed in a table that when exceeded results in exclusive table lock?
If yes, is it configurable and may it me increased to some high value to prevent exclusive locks?
If no, what solution do you suggest to prevent locks? I am thinking about involving temporary tables.
Any help is highly welcomed.
Regards,
Jacek