JDBC generated keys: Attempt 1

GeneratedKeys1.java

public long create(String sql) throws SQLException {
  try (
        Connection connection = dataSource.getConnection();
        Statement statement = connection.prepareStatement(sql, 
                                        Statement.RETURN_GENERATED_KEYS)) {
        
        if (statement.executeUpdate() == 0) {
            throw new SQLException("Insert failed, no rows affected.");
        }

        try (ResultSet generatedKeys = statement.getGeneratedKeys()) {
            if (generatedKeys.next()) {
                return generatedKeys.getLong(1);
            } else {
                throw new SQLException("Creating user failed, no ID obtained.");
            }
        }
    }
}