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:

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

Modifier and Type	Field	Description
protected JdbcCacheConnector	jdbcCacheConnector	Connects to SQL database and performs queries

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(JdbcCacheConnector.JdbcResultRecord resultRecord, CertificateToken certificateToken, CertificateToken issuerCertificateToken)	Builds RevocationToken from the obtained ResultSet
void	destroyTable()	Removes table from DB
protected RevocationToken<R>	findRevocation(String key, CertificateToken certificateToken, CertificateToken issuerCertificateToken)	Finds a RevocationToken in the cache
protected abstract String	getCreateTableQuery()	Returns CREATE_TABLE sql query
protected abstract String	getDeleteTableQuery()	Returns an sql query to remove a table from DB
protected abstract String	getFindRevocationQuery()	Returns an sql query to get revocation data from DB
protected abstract String	getRemoveRevocationTokenEntryQuery()	Returns an sql query to remove a record from DB
protected abstract Collection<JdbcCacheConnector.JdbcResultRequest>	getRevocationDataExtractRequests()	Returns a request to find a revocation data
protected abstract String	getTableExistenceQuery()	Returns an sql query to check table existence
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

getRevocationToken, getRevocationToken, getRevocationTokenKey, 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

Field Details

jdbcCacheConnector

protected transient JdbcCacheConnector jdbcCacheConnector

Connects to SQL database and performs queries

Constructor Details

JdbcRevocationSource

protected JdbcRevocationSource()

Default constructor instantiating object with null values

Method Details

getCreateTableQuery

protected abstract String getCreateTableQuery()

Returns CREATE_TABLE sql query

Returns:

String sql query

getTableExistenceQuery

protected abstract String getTableExistenceQuery()

Returns an sql query to check table existence

Returns:

String sql query

getFindRevocationQuery

protected abstract String getFindRevocationQuery()

Returns an sql query to get revocation data from DB

Returns:

String sql query

getDeleteTableQuery

protected abstract String getDeleteTableQuery()

Returns an sql query to remove a table from DB

Returns:

String sql query

getRemoveRevocationTokenEntryQuery

protected abstract String getRemoveRevocationTokenEntryQuery()

Returns an sql query to remove a record from DB

Returns:

String sql query

buildRevocationTokenFromResult

protected abstract RevocationToken<R> buildRevocationTokenFromResult(JdbcCacheConnector.JdbcResultRecord resultRecord,
 CertificateToken certificateToken,
 CertificateToken issuerCertificateToken)
                                                              throws DSSExternalResourceException

Builds RevocationToken from the obtained ResultSet

Parameters:

resultRecord - represent the extract 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

setJdbcCacheConnector

public void setJdbcCacheConnector(JdbcCacheConnector jdbcCacheConnector)

Sets the SQL connection DataSource

Parameters:

jdbcCacheConnector - JdbcCacheConnector

findRevocation

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

Description copied from class: RepositoryRevocationSource

Finds a RevocationToken in the cache

Specified by:

findRevocation in class RepositoryRevocationSource<R extends Revocation>

Parameters:

key - the key String

certificateToken - CertificateToken

issuerCertificateToken - CertificateToken

Returns:

RevocationToken object

getRevocationDataExtractRequests

protected abstract Collection<JdbcCacheConnector.JdbcResultRequest> getRevocationDataExtractRequests()

Returns a request to find a revocation data

Returns:

a collection of JdbcCacheConnector.JdbcResultRequest

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