ps.setString(1, issuerdn);
ps.setString(1, dn);
    public Collection listAllCertificates(Admin admin, String issuerdn) {        debug(">listAllCertificates()");        Connection con = null;        PreparedStatement ps = null;;        ResultSet result = null;        try {            con = getConnection();            ps = con.prepareStatement("select fingerprint from CertificateData where issuerDN=? ORDER BY expireDate DESC");            ps.setString(1, issuerdn);            result = ps.executeQuery();            ArrayList vect = new ArrayList();            while (result.next()) {                vect.add(result.getString(1));            }            debug("<listAllCertificates()");            return vect;        } catch (Exception e) {            throw new EJBException(e);        } finally {            try {                if (result != null) result.close();                if (ps != null) ps.close();                if (con!= null) con.close();            } catch(SQLException se) {                error("Error cleaning up: ", se);            }        }    } // listAllCertificates