[FLINK-17294] Using "DataSource" instead of "DriverManager" to get connection in JDBC connector

• Type: Improvement
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Connectors / JDBC
• Labels: auto-deprioritized-major auto-deprioritized-minor
• Assignee: Unassigned
• Reporter: Lijie Wang
• Created: 21/Apr/20 09:11
• Updated: 16/Nov/21 10:43

Description

I noticed that JDBC connector using DriverManager to get connection, but DataSource is encouraged now. We should using DataSource instead of DriverManager.

About the DriverManager vs DataSource, see https://stackoverflow.com/questions/15198319/why-do-we-use-a-datasource-instead-of-a-drivermanager.

Some implementations of DataSource maybe we can use : alibaba durid, apache dbcp

And we should introduce connection pool to get more performance.