com.wm.app.tn.db
Class SecurityOps

java.lang.Object
  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