Help required to understand JDBC Scenario

Dear All,

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,

Manikandan