public synchronized TrustedAuthority getTrustedAuthority(String name) throws GTSInternalFault, InvalidTrustedAuthorityFault { Connection c = null; try { c = db.getConnection(); PreparedStatement s = c.prepareStatement( "select * from " + TrustedAuthorityTable.TABLE_NAME + " where " + TrustedAuthorityTable.NAME + "= ?"); s.setString(1, name); ResultSet rs = s.executeQuery(); if (rs.next()) { TrustedAuthority ta = new TrustedAuthority(); ta.setName(rs.getString(TrustedAuthorityTable.NAME)); ta.setTrustLevels(getTrustLevels(name)); ta.setStatus(Status.fromValue(rs.getString(TrustedAuthorityTable.STATUS))); ta.setIsAuthority(Boolean.valueOf(rs.getBoolean(TrustedAuthorityTable.IS_AUTHORITY))); ta.setAuthorityGTS(rs.getString(TrustedAuthorityTable.AUTHORITY_GTS)); ta.setSourceGTS(rs.getString(TrustedAuthorityTable.SOURCE_GTS)); ta.setExpires(rs.getLong(TrustedAuthorityTable.EXPIRES)); ta.setLastUpdated(rs.getLong(TrustedAuthorityTable.LAST_UPDATED)); ta.setCertificate( new gov.nih.nci.cagrid.gts.bean.X509Certificate( rs.getString(TrustedAuthorityTable.CERTIFICATE))); String crl = rs.getString(TrustedAuthorityTable.CRL); if ((crl != null) && (crl.trim().length() > 0)) { ta.setCRL(new gov.nih.nci.cagrid.gts.bean.X509CRL(crl)); } return ta; } rs.close(); s.close(); } catch (Exception e) { this.log.error( "Unexpected database error incurred in obtaining the Trusted Authority, " + name + ":\n", e); GTSInternalFault fault = new GTSInternalFault(); fault.setFaultString("Unexpected error obtaining the TrustedAuthority " + name); throw fault; } finally { db.releaseConnection(c); } InvalidTrustedAuthorityFault fault = new InvalidTrustedAuthorityFault(); fault.setFaultString("The TrustedAuthority " + name + " does not exist."); throw fault; }
public synchronized TrustedAuthority[] findTrustAuthorities(TrustedAuthorityFilter filter) throws GTSInternalFault { this.buildDatabase(); Connection c = null; List authorities = new ArrayList(); TrustedAuthoritySelectStatement select = new TrustedAuthoritySelectStatement(); select.addSelectField("*"); try { if (filter != null) { if (filter.getName() != null) { select.addWhereField(TrustedAuthorityTable.NAME, "=", filter.getName()); } if (filter.getCertificateDN() != null) { select.addWhereField( TrustedAuthorityTable.CERTIFICATE_DN, "=", filter.getCertificateDN()); } if (filter.getStatus() != null) { select.addWhereField(TrustedAuthorityTable.STATUS, "=", filter.getStatus().getValue()); } if (filter.getIsAuthority() != null) { select.addWhereField( TrustedAuthorityTable.IS_AUTHORITY, "=", String.valueOf(filter.getIsAuthority())); } if (filter.getAuthorityGTS() != null) { select.addWhereField(TrustedAuthorityTable.AUTHORITY_GTS, "=", filter.getAuthorityGTS()); } if (filter.getSourceGTS() != null) { select.addWhereField(TrustedAuthorityTable.SOURCE_GTS, "=", filter.getSourceGTS()); } if (filter.getLifetime() != null) { if (filter.getLifetime().equals(Lifetime.Valid)) { Calendar cal = new GregorianCalendar(); long time = cal.getTimeInMillis(); select.addClause( "(" + TrustedAuthorityTable.EXPIRES + "=0 OR " + TrustedAuthorityTable.EXPIRES + ">" + time + ")"); } else if (filter.getLifetime().equals(Lifetime.Expired)) { Calendar cal = new GregorianCalendar(); long time = cal.getTimeInMillis(); select.addClause( "(" + TrustedAuthorityTable.EXPIRES + "<>0 AND " + TrustedAuthorityTable.EXPIRES + "<" + time + ")"); } } } c = db.getConnection(); PreparedStatement s = select.prepareStatement(c); ResultSet rs = s.executeQuery(); while (rs.next()) { String name = rs.getString(TrustedAuthorityTable.NAME); TrustLevels levels = filter.getTrustLevels(); boolean okToAdd = true; if (levels != null) { String[] tl = levels.getTrustLevel(); if (tl != null) { for (int i = 0; i < tl.length; i++) { if (!this.hasTrustLevels(name, tl[i])) { okToAdd = false; break; } } } } if (okToAdd) { TrustedAuthority ta = new TrustedAuthority(); ta.setName(name); ta.setTrustLevels(getTrustLevels(name)); ta.setStatus(Status.fromValue(rs.getString(TrustedAuthorityTable.STATUS))); ta.setIsAuthority(Boolean.valueOf(rs.getBoolean(TrustedAuthorityTable.IS_AUTHORITY))); ta.setAuthorityGTS(rs.getString(TrustedAuthorityTable.AUTHORITY_GTS)); ta.setSourceGTS(rs.getString(TrustedAuthorityTable.SOURCE_GTS)); ta.setExpires(rs.getLong(TrustedAuthorityTable.EXPIRES)); ta.setLastUpdated(rs.getLong(TrustedAuthorityTable.LAST_UPDATED)); ta.setCertificate( new gov.nih.nci.cagrid.gts.bean.X509Certificate( rs.getString(TrustedAuthorityTable.CERTIFICATE))); String crl = rs.getString(TrustedAuthorityTable.CRL); if ((crl != null) && (crl.trim().length() > 0)) { ta.setCRL(new gov.nih.nci.cagrid.gts.bean.X509CRL(crl)); } authorities.add(ta); } } rs.close(); s.close(); TrustedAuthority[] list = new TrustedAuthority[authorities.size()]; for (int i = 0; i < authorities.size(); i++) { list[i] = (TrustedAuthority) authorities.get(i); } return list; } catch (Exception e) { this.log.error( "Unexpected database error incurred in finding trusted authorities: " + e.getMessage(), e); GTSInternalFault fault = new GTSInternalFault(); fault.setFaultString("Unexpected error occurred in finding Trusted Authorities"); throw fault; } finally { db.releaseConnection(c); } }