I have increased the concurrent tasks to be '10' for PutSQL processor. At that time it shows below error but there is no data loss.
*failed to process due to org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object; rolling back session: * *if i have remove concurrent tasks then it worked without those exception* while google this exception i have found answer in below link I am getting Cannot get a connection, pool error Timeout waiting for idle object, When I try to create more than 250 threads in my web application But i don't know how to avoid this issue in NiFi putSQL. Can anyone help me to resolve this?
