DIH using a connection pool

[Esteban Donato]

Hi community,

I am using Solr with DIH to index content from a DB.  The point is
that I have to configure DIH to check changes in the DB very
frequently (aprox 1 sec) to maintain the index almost up-to-date.  I
noted that JDBCDataSource closes the DB connection after every
execution which is not acceptable with this update rate.  Ideally I
would need DIH using a connection pool.  Looking at DIH code and faq I
noticed that I can configure a connection pool and expose it via jndi
for the JDBCDataSource to use it.  My question is: is this they way to
go for integrating a connection pool with DIH?

Thanks
Esteban