I am trying to perform cascading deletion in the database but because the records are many and the deletion is happening in many tables, this takes a long and the database gets disconnected after a while. How to solve this?
Question
How to perform cascading deletion in the database and avoid database disconnection issue?
+1
+20- Supporter
If the problem is that too many uuids can cause it to timeout, you could try send it as multiple delete statements, with a limited number of uuids (ie one) per delete.
Or you can increase the wait time in the SQLExecutor to like 300 seconds instead of the default 30.
A where clause like you have can also be used to delete using a writer, maybe that will have different behaviour.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.