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.
