0 - 3 of 3 tags for table lock

Hi Dieter / All

 

I would like to know one thing.

 

There is one table T. A view V is created with LOCKING ROW FOR ACCESS.

Now, 3 different users (in 3 different sessions) are trying in parallel to INSERT using V (view).

 

In my application, hibernate transactions are managed by spring aop and uses Terdata as database.

THIS ISSUES IS SPECIFIC TO TERADATA AND THE SAME CODE WORKS FINE IN MYSQL.

There is one service class i.e. ServiceClass.

It has method called save which takes list of objects as parameters and checks whether it is modified or not by checking it with data from database.

After that it calls the DAO class which persist the data in database.

ServiceClass method's aop:

I have been looking for answers to a basic question on table partitioning in Teradata. Can someone please shed more light. Here it is -