Can we reuse a DB connection in Nifi?

[#1]

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?

[#2 · Accepted solution]

@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.

[#3]

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