Re: DBCP connection pool problem - connection already closed

2018-01-11 Thread 尹文才
Thanks Brett, I will switch to use jTDS and see how it goes. Regards, Ben 2018-01-11 16:22 GMT+08:00 Brett Ryan : > Hi Ben. It’s often recommended to use the jTDS driver [1] as the MS > provided driver is considered buggy. > > I don’t make this claim, however; I’ve always used this driver for ms

Re: DBCP connection pool problem - connection already closed

2018-01-11 Thread Brett Ryan
Hi Ben. It’s often recommended to use the jTDS driver [1] as the MS provided driver is considered buggy. I don’t make this claim, however; I’ve always used this driver for ms sql server and never encountered issues. [1]: http://jtds.sourceforge.net/faq.html > On 11 Jan 2018, at 18:56, 尹文才 w

DBCP connection pool problem - connection already closed

2018-01-10 Thread 尹文才
Hi guys, I'm using the PutDatabaseRecord processor to write some data into sql server and the processor is using the DBCP controller service as its connection pool. Sometimes I could see the following exception inside my log file: org.apache.nifi.processor.exception.ProcessException: Failed to comm