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 DataSource	dataSource

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

proxiedSource

Constructor Summary

Constructors

Constructor	Description
JdbcRevocationSource()

Method Summary

Modifier and Type	Method	Description
protected abstract RevocationToken<R>	buildRevocationTokenFromResult(ResultSet rs, CertificateToken certificateToken, CertificateToken issuerCertificateToken)	Build RevocationToken from the obtained ResultSet
protected void	closeQuietly(Connection c, Statement s, ResultSet rs)	Close the statement and connection and resultset without throwing the exception
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 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()
protected void	removeRevocation(RevocationToken<R> token)	Removes the RevocationToken from cache
protected void	rollback(Connection c)	Rollaback transaction for the given Connection
void	setDataSource(DataSource dataSource)

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

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

dataSource

protected transient DataSource dataSource

Constructor Details

JdbcRevocationSource

public JdbcRevocationSource()

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(ResultSet rs, CertificateToken certificateToken, CertificateToken issuerCertificateToken) throws RevocationException

Build RevocationToken from the obtained ResultSet

Parameters:

rs - ResultSet answer from DB

certificateToken - CertificateToken of certificate to get revocation data for

issuerCertificateToken - CertificateToken if issuer of the certificateToken

Returns:

RevocationToken

Throws:

RevocationException

setDataSource

public void setDataSource(DataSource dataSource)

Parameters:

dataSource - the dataSource to set

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

removeRevocation

protected void removeRevocation(RevocationToken<R> token)

Description copied from class: RepositoryRevocationSource

Removes the RevocationToken from cache

Specified by:

removeRevocation in class RepositoryRevocationSource<R extends Revocation>

Parameters:

token - RevocationToken

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()

destroyTable

public void destroyTable() throws SQLException

Removes table from DB

Throws:

SQLException - in case of error

rollback

protected void rollback(Connection c)

Rollaback transaction for the given Connection

Parameters:

c - Connection

closeQuietly

protected void closeQuietly(Connection c, Statement s, ResultSet rs)

Close the statement and connection and resultset without throwing the exception

Parameters:

c - the connection

s - the statement

rs - the ResultSet