com.wm.app.tn.db
Class SecurityOps

java.lang.Object
  extended by com.wm.app.tn.db.SecurityOps

public class SecurityOps
extends java.lang.Object

Provides database operations for storing and retrieving certificates and private key information in CertificateData table.


Constructor Summary
SecurityOps()
           
 
Method Summary
static int deleteCertificateData(java.sql.Connection conn, java.lang.String certId)
          Delete a row of CertData.
static com.wm.app.tn.security.CertData getCertificateData(java.sql.Connection conn, java.lang.String ownerId, java.lang.String partnerId, java.lang.String usage)
          Select a row of CertData for given OwnerID, PartnerID and Usage.
static com.wm.app.tn.security.CertData getCertificateDataByCertID(java.sql.Connection conn, java.lang.String certId)
          Select a row of CertData for given CertID.
static com.wm.app.tn.security.CertData getCertificateDataByCertID(java.lang.String certId)
           
static java.util.Vector getCertificateDataForOwner(java.sql.Connection conn, java.lang.String ownerId)
          Select all CertData belongs to one owner.
static java.util.Vector getCertificateDataForPartnerAndUsage(java.sql.Connection conn, java.lang.String partnerId, java.lang.String usage)
          Select all CertData with supplied PartnerID and usage.
static java.util.Vector getCertificateDataForUpdate(java.sql.Connection conn, java.lang.String ownerId, java.sql.Timestamp expDate)
          Select all CertData belongs to one owner and has the specified exp date.
static java.lang.String getOwnerByCertID(java.sql.Connection conn, java.lang.String certId)
          Gets the Owner ID for the respective CertID.
static java.lang.String getOwnerByCertID(java.lang.String certId)
          Gets the Owner ID for the respective CertID.
static java.lang.String insertCertificateData(java.sql.Connection conn, com.wm.app.tn.security.CertData data, boolean skipChainValidation)
          Insert a new row of CertData into db.
static boolean updateCertificateData(java.sql.Connection conn, com.wm.app.tn.security.CertData data)
          Update a row of CertData.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

SecurityOps

public SecurityOps()
Method Detail

insertCertificateData

public static java.lang.String insertCertificateData(java.sql.Connection conn,
                                                     com.wm.app.tn.security.CertData data,
                                                     boolean skipChainValidation)
                                              throws EXMLException
Insert a new row of CertData into db. If new CertData (CertID==null), generate new unique CertID. Check if chain is valid. Check if chain is trusted if sign/verify and receiver is hub Check if private key is valid.

Returns:
CertID. Return null if CertificateData null,
Throws:
EXMLException

updateCertificateData

public static boolean updateCertificateData(java.sql.Connection conn,
                                            com.wm.app.tn.security.CertData data)
                                     throws EXMLException
Update a row of CertData. Check if chain is valid. Check if chain is trusted if sign/verify and receiver is hub Check if private key is valid.

Returns:
CertID.
Throws:
EXMLException

deleteCertificateData

public static int deleteCertificateData(java.sql.Connection conn,
                                        java.lang.String certId)
                                 throws EXMLException
Delete a row of CertData.

Throws:
EXMLException

getCertificateData

public static com.wm.app.tn.security.CertData getCertificateData(java.sql.Connection conn,
                                                                 java.lang.String ownerId,
                                                                 java.lang.String partnerId,
                                                                 java.lang.String usage)
                                                          throws EXMLException
Select a row of CertData for given OwnerID, PartnerID and Usage.

Throws:
EXMLException

getCertificateDataByCertID

public static com.wm.app.tn.security.CertData getCertificateDataByCertID(java.lang.String certId)
                                                                  throws EXMLException
Throws:
EXMLException

getCertificateDataByCertID

public static com.wm.app.tn.security.CertData getCertificateDataByCertID(java.sql.Connection conn,
                                                                         java.lang.String certId)
                                                                  throws EXMLException
Select a row of CertData for given CertID.

Throws:
EXMLException

getOwnerByCertID

public static java.lang.String getOwnerByCertID(java.lang.String certId)
                                         throws EXMLException
Gets the Owner ID for the respective CertID.

Throws:
EXMLException

getOwnerByCertID

public static java.lang.String getOwnerByCertID(java.sql.Connection conn,
                                                java.lang.String certId)
                                         throws EXMLException
Gets the Owner ID for the respective CertID.

Throws:
EXMLException

getCertificateDataForOwner

public static java.util.Vector getCertificateDataForOwner(java.sql.Connection conn,
                                                          java.lang.String ownerId)
                                                   throws EXMLException
Select all CertData belongs to one owner.

Returns:
a Vector contains all CertData. Returns null if no data found.
Throws:
EXMLException

getCertificateDataForUpdate

public static java.util.Vector getCertificateDataForUpdate(java.sql.Connection conn,
                                                           java.lang.String ownerId,
                                                           java.sql.Timestamp expDate)
                                                    throws EXMLException
Select all CertData belongs to one owner and has the specified exp date.

Returns:
a Vector contains all CertData. Returns null if no data found.
Throws:
EXMLException

getCertificateDataForPartnerAndUsage

public static java.util.Vector getCertificateDataForPartnerAndUsage(java.sql.Connection conn,
                                                                    java.lang.String partnerId,
                                                                    java.lang.String usage)
                                                             throws EXMLException
Select all CertData with supplied PartnerID and usage.

Returns:
a Vector contains all CertData. Returns null if no data found.
Throws:
EXMLException