We have a JDBC Scenario where we are Update/insert the data to the table, it takes approximately 10mins to update/insert the data to the staging table.
As per my understanding PI will lock the table while update/Insert the data in to the table.
what will happen suppose if connection is dropped while inserting/updating the data?
* will the table remain locked or else the lock will be removed when connection is dropped?
* no data will be inserted/Updated?
your detailed explanation will be very helpful to understand better
Thanks & Regards,