Without going into too much detail (unless it would be useful). I am facing
an issue where long standing connections are eventually failing when
SQLServer attempts to bulk insert a file from NAS (we are using
integratedSecurity and the SQLServer is configured with kerberos
authentication and delegation). The process does work but at some point the
bulk insert is denied access to the file and it appears to be an issue with
the kerberos ticket becoming stale.
The solution seems to be to time out connections that have been idle for
some time and allow the pool to reduce to zero connections. This forces a
new connection and authorization when needed. The connection seems to work
for as long as needed and after it is idle for some time it is removed from
These additional configurations are available in the underlying
DBCPConnectionPool but are not exposed through the service configuration. Is
there a specific reason they have not been exposed? I have downloaded the
source and made the changes myself but before I go any further I would like
to make sure I am not being too clever for my own good.
Also, if there is not a specific reason they have not been exposed, would
this be something that would be considered for a future release?
Sent from: http://apache-nifi-users-list.2361937.n4.nabble.com/