Package eu.europa.esig.dss.spi.x509.revocation

Class JdbcRevocationSource<R extends Revocation>

java.lang.Object

eu.europa.esig.dss.spi.x509.revocation.RepositoryRevocationSource<R>

eu.europa.esig.dss.spi.x509.revocation.JdbcRevocationSource<R>

Type Parameters:

R - CRL or OCSP

All Implemented Interfaces:

MultipleRevocationSource<R>, RevocationSource<R>, Serializable

Direct Known Subclasses:

JdbcCacheCRLSource, JdbcCacheOCSPSource

public abstract class JdbcRevocationSource<R extends Revocation>
extends RepositoryRevocationSource<R>

Abstract class to retrieve token from a JDBC datasource

See Also:

• Serialized Form

Field Summary

Fields inherited from class eu.europa.esig.dss.spi.x509.revocation.RepositoryRevocationSource

proxiedSource

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	JdbcRevocationSource()	Default constructor instantiating object with null values

Method Summary

Modifier and Type	Method	Description
protected abstract RevocationToken<R>	buildRevocationTokenFromResult(SqlRecord response, CertificateToken certificateToken, CertificateToken issuerCertificateToken)	Builds RevocationToken from the obtained ResultSet
void	destroyTable()	Removes table from DB
protected List<RevocationToken<R>>	findRevocations(String key, CertificateToken certificateToken, CertificateToken issuerCertificateToken)	Finds a list of RevocationTokens in the cache for the given certificateToken with the corresponding key
protected abstract SqlQuery	getCreateTableQuery()	Returns CREATE_TABLE sql query
protected abstract SqlQuery	getDeleteTableQuery()	Returns an sql query to remove a table from DB
protected abstract SqlQuery	getInsertRevocationTokenEntryQuery()	Returns an SQL query to insert a new revocation token to a table
protected JdbcCacheConnector	getJdbcCacheConnector()	Gets the SQL connection DataSource
protected abstract SqlQuery	getRemoveRevocationTokenEntryQuery()	Returns an sql query to remove a revocation token from DB
protected abstract SqlSelectQuery	getRevocationDataExtractQuery()	Returns a request to find a revocation data
protected abstract SqlQuery	getTableExistenceQuery()	Returns an sql query to check table existence
protected abstract SqlQuery	getUpdateRevocationTokenEntryQuery()	Returns an SQL query to update a revocation token in a table
void	initTable()	Initialize the revocation token table by creating the table if it does not exist.
boolean	isTableExists()	Verifies if the table exists
protected void	removeRevocation(String revocationTokenKey)	Removes the RevocationToken from cache with the given key
void	setJdbcCacheConnector(JdbcCacheConnector jdbcCacheConnector)	Sets the SQL connection DataSource

Methods inherited from class eu.europa.esig.dss.spi.x509.revocation.RepositoryRevocationSource

findRevocation, getRevocationToken, getRevocationToken, getRevocationTokenKey, getRevocationTokens, getRevocationTokens, initRevocationTokenKeys, insertRevocation, setDefaultNextUpdateDelay, setMaxNextUpdateDelay, setProxySource, setRemoveExpired, updateRevocation

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

JdbcRevocationSource

protected JdbcRevocationSource()

Default constructor instantiating object with null values

Method Details

getCreateTableQuery

protected abstract SqlQuery getCreateTableQuery()

Returns CREATE_TABLE sql query

Returns:

SqlQuery

getTableExistenceQuery

protected abstract SqlQuery getTableExistenceQuery()

Returns an sql query to check table existence

Returns:

SqlQuery

getDeleteTableQuery

protected abstract SqlQuery getDeleteTableQuery()

Returns an sql query to remove a table from DB

Returns:

SqlQuery

getInsertRevocationTokenEntryQuery

protected abstract SqlQuery getInsertRevocationTokenEntryQuery()

Returns an SQL query to insert a new revocation token to a table

Returns:

SqlQuery

getUpdateRevocationTokenEntryQuery

protected abstract SqlQuery getUpdateRevocationTokenEntryQuery()

Returns an SQL query to update a revocation token in a table

Returns:

SqlQuery

getRemoveRevocationTokenEntryQuery

protected abstract SqlQuery getRemoveRevocationTokenEntryQuery()

Returns an sql query to remove a revocation token from DB

Returns:

SqlQuery

buildRevocationTokenFromResult

protected abstract RevocationToken<R> buildRevocationTokenFromResult(SqlRecord response,
 CertificateToken certificateToken,
 CertificateToken issuerCertificateToken)
                                                              throws DSSExternalResourceException

Builds RevocationToken from the obtained ResultSet

Parameters:

response - SqlRecord represent the extracted record row

certificateToken - CertificateToken of certificate to get revocation data for

issuerCertificateToken - CertificateToken if issuer of the certificateToken

Returns:

RevocationToken

Throws:

DSSExternalResourceException - if an exception occurs during the attempt to extract token

getJdbcCacheConnector

protected JdbcCacheConnector getJdbcCacheConnector()

Gets the SQL connection DataSource

Returns:

JdbcCacheConnector

setJdbcCacheConnector

public void setJdbcCacheConnector(JdbcCacheConnector jdbcCacheConnector)

Sets the SQL connection DataSource

Parameters:

jdbcCacheConnector - JdbcCacheConnector

findRevocations

protected List<RevocationToken<R>> findRevocations(String key,
 CertificateToken certificateToken,
 CertificateToken issuerCertificateToken)

Description copied from class: RepositoryRevocationSource

Finds a list of RevocationTokens in the cache for the given certificateToken with the corresponding key

Specified by:

findRevocations in class RepositoryRevocationSource<R extends Revocation>

Parameters:

key - the key String

certificateToken - CertificateToken

issuerCertificateToken - CertificateToken

Returns:

a list of RevocationToken objects

getRevocationDataExtractQuery

protected abstract SqlSelectQuery getRevocationDataExtractQuery()

Returns a request to find a revocation data

Returns:

SqlSelectQuery

removeRevocation

protected void removeRevocation(String revocationTokenKey)

Description copied from class: RepositoryRevocationSource

Removes the RevocationToken from cache with the given key

Specified by:

removeRevocation in class RepositoryRevocationSource<R extends Revocation>

Parameters:

revocationTokenKey - String

initTable

public void initTable()
               throws SQLException

Initialize the revocation token table by creating the table if it does not exist.

Throws:

SQLException - in case of SQL connection error

isTableExists

public boolean isTableExists()

Verifies if the table exists

Returns:

TRUE if the table exists, FALSE otherwise

destroyTable

public void destroyTable()
                  throws SQLException

Removes table from DB

Throws:

SQLException - in case of error