JDBC Adapter - database lock
I have a scenario where we call a stored procedure on a Sybase database with a jdbc adapter. After the adapter picks up the data it should delete the records as a post processing step.
Can I be sure, that the database is securely locked until the jdbc adapter finishes with its post processing step? I am afraid, that after the stored procedure is done, data can be written to the database again before the post processing step of the jdbc adapter is executed. In a worse case scenario could this mean the loss of data.
Do you have any advice?