Hello all, Just a simple question: is there a way to configure a DBCP service in Nifi to use testWhileIdle and timeBetweenEvictionRunsMillis (per http://commons.apache.org/proper/commons-dbcp/configuration.html ). I would like to use the built-in DBCP service for my custom processors, but every morning the first query fails with the message: --- The last packet successfully received from the server was 60,904,468 milliseconds ago. The last packet sent successfully to the server was 60,904,680 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application... ---
It's a common issue, and the settings should fix it, I'm just not sure if I can "put" them somewhere to use them with the built-in DBCP service tools in Nifi (1.0.0, CentOS 7). Thanks in advance! [photo]<http://homecarepulse.com/?utm_source=logoLink&utm_medium=Jason&utm_campaign=EmailSignature> Jason Hamilton Senior Software Developer Home Care Pulse, LLC www.homecarepulse.com<http://homecarepulse.com?utm_source=websiteLink&utm_medium=Jason&utm_campaign=EmailSignature> 208.228.0895 (Direct)<tel:2082280895> 877.307.8573 (Office)<tel:8773078573> [Linnked In]<http://www.linkedin.com/company/home-care-pulse>[Facebook]<http://facebook.com/homecarepulse>[Twitter]<http://twitter.com/homecarepulse>[Google+]<http://plus.google.com/+Homecarepulse/posts> Satisfaction Management<http://www.homecarepulse.com/program-details?utm_source=bottomLinks&utm_medium=Jason&utm_campaign=EmailSignature> | Benchmarking<http://benchmarking.homecarepulse.com?utm_source=bottomLinks&utm_medium=Jason&utm_campaign=EmailSignature> | BestofHomeCare.com<http://www.bestofhomecare.com?utm_source=bottomLinks&utm_medium=Jason&utm_campaign=EmailSignature> | Blog<http://www.homecarepulse.com/blog?utm_source=bottomLinks&utm_medium=Jason&utm_campaign=EmailSignature>
