class JDBCSSHRecordStoreConnection implements SSHRecordStoreConnection {

    @Override
    public SSHCertRecord getSSHCertRecord(String instanceId, String service) {
        
        final String caller = "getSSHCertRecord";

        SSHCertRecord sshCertRecord = null;
        try (PreparedStatement ps = con.prepareStatement(SQL_GET_SSH_RECORD)) {
            ps.setString(1, instanceId);
            ps.setString(2, service);
            
            try (ResultSet rs = executeQuery(ps, caller)) {
                if (rs.next()) {
                    sshCertRecord = new SSHCertRecord();
                    sshCertRecord.setInstanceId(instanceId);
                    sshCertRecord.setService(service);
                    sshCertRecord.setClientIP(rs.getString(DB_COLUMN_CLIENT_IP));
                    sshCertRecord.setPrincipals(rs.getString(DB_COLUMN_PRINCIPALS));
                    sshCertRecord.setPrivateIP(rs.getString(DB_COLUMN_PRIVATE_IP));
                }
            }
        } catch (SQLException ex) {
            throw sqlError(ex, caller);
        }
        return sshCertRecord;
    }

    public  JDBCSSHRecordStoreConnection(Connection con);

}