concurrency issue when two users inserting some values.

I must admit that I don't quite understand your code. However, it is not quite clear which column of which table exactly here has unique index / primary key declared.

 

Also not clear how exactly, are you reproducing scenario of two inserts at identical time.

 

Also, not clear how a duplicate row can possibly get inserted when unique key is defined.

Hi Nitin,

yes, we have created unique index for the below sample table:

 

 

and we have the below sample insert query: 

 

Please elaborate a bit. Share some code may be from back-end. 

 

How exactly are managing to test this scenario.

 

Which column you want to be unique? Have you already created primary key / unique index  on that column?