Re: Getting exception with multiple DBCPConnectionPools: sqljdbc_auth.dll already loaded in another classloader

2019-02-26 Thread Joe Witt
Brad What you’re running into is that the same native lib, by name, cannot be loaded more than once in the entire jvm. Since the component you’re using is loading the missal driver in two diff processors we are hitting this. We can work around this limitation of jvm classloader isolation by

Getting exception with multiple DBCPConnectionPools: sqljdbc_auth.dll already loaded in another classloader

2019-02-26 Thread Brad Powell
I have had NiFi running successfully, connected to a single SQL Server database using integrated authentication, for a long while (years). Recently I added a second DBCPConnectionPool controller, along with a referencing component (QueryDatabaseTable), that is pointed to a different SQL Server