"INNER JOIN certs ON certs.id=jobs.`targetId` " + //
"INNER JOIN profiles ON profiles.id=certs.profile " + //
"WHERE jobs.state='open' "//
- + "AND task='sign'");
+ + "AND task='sign'");
getSANSs = new GigiPreparedStatement("SELECT contents, type FROM `subjectAlternativeNames` " + //
"WHERE `certId`=?");
}
}
- private static int counter = 0;
-
private static void signCertificates() throws SQLException {
GigiResultSet rs = readyCerts.executeQuery();