Add DSL.using(Connection) and DSL.using(Connection, Settings) which auto-detect the SQLDialect from the jdbc url

[ben-manes]

A nice enhancement in flyway 2.1 is that the driver is inferred from the jdbc url. This helps keep the configuration succinct. For example if the url started with jdbc:postgresql, the default the driver is org.postgresql.Driver. I think the generator.database.name could also be auto-detected as well.

[lukaseder]

You're right. I had thought about this before, as well. Unfortunately, I must've forgotten creating an issue for this.

I guess this can lead to a default behaviour. In some cases, the JDBC URL is ambiguous. E.g.:

• mysql-connector for MySQL / MariaDB
• jtds for Sybase ASE / Sybase SQL Anywhere / SQL Server

In those cases, the default should be the most popular database...

[lukaseder]

I'll check with Axel, if I may steal some code from him :-)
The relevant checkin is here:
flyway/flyway@8187329