I tested connecting to Aurora within DBVisualizer using the MariaDB Java connectors (both 1.6.2 as bundled with Dremio, and 2.2.1 (latest)), and neither worked.
So the problem appears to be the MariaDB JDBC connector.
The MariaDB JDBC driver cannot detect that you’re connecting to an Aurora instance. It parses the hostname looking for “amazonaws.com” to determine that you’re connecting to Aurora.
Thanks. I realize my situation is not a common case, but this was very frustrating. May I suggest taking a small step or two to prevent this from being a problem for others in a similar scenario?
Perhaps:
set a shorter timeout for initial connection (say, 1-5 minutes) rather than 8 hours
provide the option of using the MySQL JDBC driver rather than MariaDB one
@evan_b thanks for the suggestions. We’re already tracking #3 as a high-priority improvement and will look into incorporating your feedback on the first two items.