Aurora MySQL 3.14 がリリースされたので、変更点を確認して PQ 鍵交換を試してみた

import java.sql.*;

public class Probe {
    static void q(Statement st, String sql) throws SQLException {
        System.out.println("=== QUERY: " + sql);
        try (ResultSet rs = st.executeQuery(sql)) {
            int n = rs.getMetaData().getColumnCount();
            while (rs.next()) {
                StringBuilder sb = new StringBuilder();
                for (int i = 1; i <= n; i++) {
                    if (i > 1) sb.append(" | ");
                    sb.append(rs.getString(i));
                }
                System.out.println(sb);
            }
        }
    }

    public static void main(String[] a) throws Exception {
        String host = a[0];
        String url = "jdbc:mysql://" + host + ":3306/?sslMode=REQUIRED";
        System.out.println("=== JAVA: " + System.getProperty("java.vendor.version")
            + " / java.version=" + System.getProperty("java.version"));
        try (Connection c = DriverManager.getConnection(url, System.getenv("DB_USER"), System.getenv("DB_PASS"));
             Statement st = c.createStatement()) {
            System.out.println("=== DRIVER: " + c.getMetaData().getDriverName() + " " + c.getMetaData().getDriverVersion());
            q(st, "SELECT VERSION()");
            q(st, "SELECT aurora_version()");
            q(st, "SHOW VARIABLES LIKE 'tls%'");
            q(st, "SHOW VARIABLES LIKE 'ssl%'");
            q(st, "SHOW STATUS LIKE 'Ssl_version'");
            q(st, "SHOW STATUS LIKE 'Ssl_cipher'");
            q(st, "SHOW STATUS LIKE 'Aurora_ssl_named_group'");
        }
    }
}