question Can we reuse a DB connection in Nifi? in Archives of Support Questions (Read Only)

Can we reuse a DB connection in Nifi?

egarelnabi — Thu, 18 May 2017 03:02:15 GMT

Is there a way for Nifi to keep a DB connection open as it processes different incoming flowfiles? Or will the processor ExecuteSQL processor open/close the connection with every flowfile it processes?

Re: Can we reuse a DB connection in Nifi?

mqureshi — Thu, 18 May 2017 03:31:29 GMT

@Eyad Garelnabi

You mean other than using DBCPConnectionPool service? I think connection pooling is used to reuse the connection but connection is closed and returned to the pool.

Re: Can we reuse a DB connection in Nifi?

egarelnabi — Thu, 18 May 2017 03:46:38 GMT

Thanks @mqureshi . I didn't realize ExecuteSQL used a connection pool.