Resolve JDBC driver class name for AWS drivers

[maciejwalkowiak]

Spring Boot could resolve JDBC driver class names for AWS variants of MySQL and PostgreSQL drivers:

• https://github.com/awslabs/aws-mysql-jdbc (production ready) - for jdbc:mysql:aws: prefix
• https://github.com/awslabs/aws-postgresql-jdbc (in developer preview) - for jdbc:postgresql:aws: prefix

If you believe this change makes sense, I would be happy to contribute a PR.

[wilkinsona]

Thanks for the suggestion, @maciejwalkowiak. This could be a nice addition, particularly for aws-mysql-jdbc. I think it may be better to wait for jdbc:postgresql:aws to stabilise before we add support for it. A PR that adds support for MySQL would be most welcome. Thanks.

[maciejwalkowiak]

I noticed few days ago there is a new JDBC driver related project from AWS in progress (https://github.com/awslabs/aws-advanced-jdbc-wrapper - 404 for now) - not sure if it only replaces Postgres driver or as the name suggests will cover more database types. Perhaps @susanmdouglas-aws or @marksailes can shine some light? So that we don't integrate driver that gets deprecated in upcoming months.

[wilkinsona]

I'd noticed that yesterday and got the same 404 but hadn't taken the time to investigate. Thanks for doing that, @maciejwalkowiak. I agree that we should hold off until the role of the new JDBC driver becomes clear.

[susanmdouglas-aws]

Hi - Can I recommend you reach out to @adalevinAWS for more information?

[adalevinAWS]

I'll update here once we have more information to share. I see you added the on-hold label for now, though. Thank you.

[vpavic]

Release 1.0.0 of software.amazon.jdbc:aws-advanced-jdbc-wrapper (hosted on https://github.com/awslabs/aws-advanced-jdbc-wrapper) has apparently been published in early October.

With that in mind, maybe this could be revisited?

[wilkinsona]

@adalevinAWS any updates on your side?

[vpavic]

Since the last update here, AWS Advanced JDBC Driver project published a few releases (including the recent v2.0.0) and has generally been adding features valuable for users of Aurora-flavored DBs from AWS.

So it seems there aren't any reasons to keep this on-hold.

[wilkinsona]

Given that the project seems to be quite well established, I guess we could assume that it's safe to proceed. I'd still welcome confirmation from @adalevinAWS though.

[hsuamz]

Thanks @wilkinsona.

I'm from the team with the AWS drivers. We are focusing our efforts right now on the aws-advanced-jdbc-wrapper, in particular on certifying it for Aurora MySQL. We would welcome the PR for the aws-advanced-jdbc-wrapper.

Thank you.