RdsUtil cannot correctly resolve region from EUSC partition RDS Endpoint

[BlckKn1fe]

Describe the bug

Hi Team, this is a report from an internal team... I did not find an appropriate contact... TLDR, RdsUtil cannot resolve region from THF RDS DB Endpoint because it's ending with .eu

The workaround for our team is to explicitly set IAM_REGION props so that it won't rely on RdsUtil.getRegionFromHost.

Please correct this problem and release a new version in Amazon interna code base repo ASAP.

Expected Behavior

We expect RdsUtil.getRegionFromHost should be able to automatically identifiy the region for THF.

What plugins are used? What other connection properties were set?

IAM Auth; to reproduce, set IAM Auth plugin only and connect to a THF RDS APG DB.

Current Behavior

We already had a workaround. But before the workaround, connection pool will keep timeout and SUPER hard for the team to debug ... To find this problem, we were testing without the connection pool and see the actual error message.

Reproduction Steps

Use AwsAdvancedJdbcWrapper + IAM Auth plugin to connect to an RDS APG DB in THF.

Possible Solution

No response

Additional Information/Context

No response

The AWS Advanced JDBC Driver version used

aws-advanced-jdbc-wrapper-2.4.0.jar | Please update it in internal repo!!

JDK version used

Java 21

Operating System and version

AL2