Hi, I have a few sql executor transformers in a sequence. They are using sql server jdbc driver connections. When I run I get the following notices usually from either the second or the third executor in the chain.
com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
I have in the past got round this by putting in feature holders which seem to close the existing connection session but it doesnt appear to be working and is affecting workbenches in desktop and cloud. I dont get these issues with using the native sql client but because I need them to run in cloud they need to be on jdbc.
Does anyone have any suggestions as to work arounds for this. thank you