protected final String buildAndCacheNextSeqValueSql(String sequenceName) { String sql = cacheSeqNameSqls.get(sequenceName); if (sql == null) { sql = buildNextSeqValueSql(sequenceName); cacheSeqNameSqls.put(sequenceName, sql); } return sql; }
private String getSqlDeltaCrlCacheIds(int numEntries) { String sql = cacheSqlDeltaCrlCacheIds.get(numEntries); if (sql == null) { sql = datasource.buildSelectFirstSql(numEntries, "ID ASC", "ID FROM DELTACRL_CACHE WHERE ID>? AND CA_ID=?"); cacheSqlDeltaCrlCacheIds.put(numEntries, sql); } return sql; }
private String getSqlCidFromPublishQueue(int numEntries) { String sql = cacheSqlCidFromPublishQueue.get(numEntries); if (sql == null) { sql = datasource.buildSelectFirstSql(numEntries, "CID ASC", "CID FROM PUBLISHQUEUE WHERE PID=? AND CA_ID=?"); cacheSqlCidFromPublishQueue.put(numEntries, sql); } return sql; }
private String getSqlExpiredSerials(int numEntries) { String sql = cacheSqlExpiredSerials.get(numEntries); if (sql == null) { sql = datasource.buildSelectFirstSql(numEntries, "SN FROM CERT WHERE CA_ID=? AND NAFTER<?"); cacheSqlExpiredSerials.put(numEntries, sql); } return sql; }
private String getSqlSuspendedSerials(int numEntries) { String sql = cacheSqlSuspendedSerials.get(numEntries); if (sql == null) { sql = datasource.buildSelectFirstSql(numEntries, "SN FROM CERT WHERE CA_ID=? AND LUPDATE<? AND RR=?"); cacheSqlSuspendedSerials.put(numEntries, sql); } return sql; }
private String getSqlRevokedCerts(int numEntries, boolean withEe) { LruCache<Integer, String> cache = withEe ? cacheSqlRevokedCertsWithEe : cacheSqlRevokedCerts; String sql = cache.get(numEntries); if (sql == null) { String coreSql = "ID,SN,RR,RT,RIT FROM CERT WHERE ID>? AND CA_ID=? AND REV=1 AND NAFTER>?"; if (withEe) { coreSql += " AND EE=?"; } sql = datasource.buildSelectFirstSql(numEntries, "ID ASC", coreSql); cache.put(numEntries, sql); } return sql; }
private String getSqlSerials(int numEntries, boolean onlyRevoked) { LruCache<Integer, String> cache = onlyRevoked ? cacheSqlSerialsRevoked : cacheSqlSerials; String sql = cache.get(numEntries); if (sql == null) { String coreSql = "ID,SN FROM CERT WHERE ID>? AND CA_ID=?"; if (onlyRevoked) { coreSql += "AND REV=1"; } sql = datasource.buildSelectFirstSql(numEntries, "ID ASC", coreSql); cache.put(numEntries, sql); } return sql; }
ECCurve curve = ecP.getCurve(); expectedLength = (curve.getFieldSize() + 7) / 8; ecCurveFieldSizes.put(curveOid, expectedLength);