You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
I have a problem regarding Multiple users Simultaneous using INSERT and SELECT queries on Firebird database. The detail problem scenario is as follows:-
I have a table and multiple users access the table at the same time. If one user is inserting the data , another user at the same time fires a select query to get the max no from the same table. Now at one point my http://VB.Net application hangs.
Now is it possible to use some type of locking system to lock the data until one user finishes the insert query and does not allow the select query to fire until the process is complete.
This is a very urgent requirement.
Please find the code below to understand the problem scenario:-
Code For INSERTING DATA:-
fbcmd = New FbCommand("Insert into Dummy_tab values(" & i & ",'Mauleen')", fbcon)
fbcmd.ExecuteNonQuery()
Code for getting the max no:-
fbcmd = New FbCommand("Select max(id) from dummy_tab", fbcon)
fbcmd.ExecuteScalar()
Thank you
The text was updated successfully, but these errors were encountered:
Submitted by: Meghna Patel (meghna)
Assigned to: @carlosga
Attachments:
Firebird Testing.zip
Hello,
I have a problem regarding Multiple users Simultaneous using INSERT and SELECT queries on Firebird database. The detail problem scenario is as follows:-
I have a table and multiple users access the table at the same time. If one user is inserting the data , another user at the same time fires a select query to get the max no from the same table. Now at one point my http://VB.Net application hangs.
Now is it possible to use some type of locking system to lock the data until one user finishes the insert query and does not allow the select query to fire until the process is complete.
This is a very urgent requirement.
Please find the code below to understand the problem scenario:-
Code For INSERTING DATA:-
fbcmd = New FbCommand("Insert into Dummy_tab values(" & i & ",'Mauleen')", fbcon)
fbcmd.ExecuteNonQuery()
Code for getting the max no:-
fbcmd = New FbCommand("Select max(id) from dummy_tab", fbcon)
fbcmd.ExecuteScalar()
Thank you
The text was updated successfully, but these errors were encountered: