[FLINK-16833] Make JDBCDialect pluggable for JDBC SQL connector

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Resolved
• Component/s: Connectors / JDBC, Table SQL / Ecosystem
• Labels: auto-deprioritized-major
• Assignee: Unassigned
• Reporter: Jark Wu
• Created: 27/Mar/20 15:36
• Updated: 04/Nov/21 08:12
• Resolved: 03/Nov/21 15:07

Description

Currently, we only natively support very limited JDBC dialects in flink-jdbc. However, there are a lot of jdbc drivers in the world . We should expose the ability to users to make it pluggable.

Some initial ideas:

• expose a connector configuration to accept a JDBCDialect class name.
• find supported JDBCDialect via SPI.

A more detaited design should be proposed for disucssion.

Issue Links

• is related to: FLINK-24253 Load JdbcDialects via Service Loaders