Catch Errors does not catch incoming DB queries in DB Table Selector
Hello KNIME Support Team.
I have a question about a WF I created.
First of all, the picture is reading data from the DB using the Try & Catch Errors node, which reads the query from the DB into the Flow variable.
It disconnects from the DB if the query works or if an invalid query comes in.
The problem with implementing this WF is that the
when there is no DB SQL Executor node, when incorrect query information comes in, an error occurs in the DB Table Selector and Catch Errors should end successfully, but only a warning appears, and Catch Errors is not executed, so the DB cannot be closed.
Therefore, if I use the DB SQL Executor node, Catch Errors works normally even if an incorrect query comes in, so can I use DB SQL Executor?
If a large amount of data is loaded as a query, will the above DB to Spark be implemented if Catch Errors is completed and the DB is closed first?
I would like to test it, but I don’t have big data in DB and it’s a customer environment, so I can’t run it locally. I would like to ask the supporters’ opinions because it is impossible to implement it on the server because the data does not exist.
I would be grateful if you could answer.