JDBC connection pools

Posted by Marco Villalobos-2 on
URL: http://deprecated-apache-flink-user-mailing-list-archive.369.s1.nabble.com/JDBC-connection-pools-tp40887.html

Currently, my jobs that require JDBC initialize a connection in the open method directly via JDBC driver.

1. What are the established best practices for this?

2. Is it better to use a connection pool that can validate the connection and reconnect?

3. Would each operator require its own connection pool?  

I'd like the communities thought on this topic.