We have a REST POST service that is being called via batch. We are observing mismatch in DB records creation versus the total number of the request came over. For example:
The total number of requests that came in are: 157
Total number of insert statements issued by Hibernate (Enabled the ‘show_sql’ as ‘true’): 158
Total number of records created in DB(Oracle 12c): 216
It seems like a typical pattern when we do the load testing from SOAP UI. Mismatch everywhere. Could anyone have any insight into this? Any help would be much appreciated.
Also, the service creates records(one per request) in multiple tables, and most of the time, the total number in those tables are not matching. Ideally, it should match the number of requests issued.