title: Cannot get a connection, pool error Timeout waiting for idle object in PutSQL?
body: <p>I have increased the concurrent tasks to be '10' for PutSQL processor.</p>
  
  <p>At that time it shows below error but there is no data loss.</p>
  
  <pre><code>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: 
  </code></pre>
  
  <p>if i have remove concurrent tasks then it worked without those exception</p>
  
  <p>while google this exception i have found answer in below link</p>
  
  <p><a href="https://stackoverflow.com/questions/11734808/i-am-getting-cannot-get-a-connection-pool-error-timeout-waiting-for-idle-object">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</a></p>
  
  <p>But i don't know how to avoid this issue in NiFi putSQL.</p>
  
  <p>Can anyone help me to resolve this?</p>