- updateMail.setString(1, crt.getPath());
- updateMail.setInt(2, id);
- updateMail.execute();
- System.out.println("sign: " + id);
+ try (InputStream is = new FileInputStream(crt)) {
+ CertificateFactory cf = CertificateFactory.getInstance("X.509");
+ X509Certificate crtp = (X509Certificate) cf.generateCertificate(is);
+ BigInteger serial = crtp.getSerialNumber();
+ updateMail.setString(1, crt.getPath());
+ updateMail.setString(2, serial.toString());
+ updateMail.setInt(3, id);
+ updateMail.execute();
+ System.out.println("sign: " + id);
+ continue;
+ } catch (GeneralSecurityException e) {
+ e.printStackTrace();
+ }
+ System.out.println("ERROR: " + id);
+ warnMail.setInt(1, id);
+ warnMail.execute();