java.lang.Object
eu.europa.esig.dss.spi.x509.aia.RepositoryAIASource
eu.europa.esig.dss.service.x509.aia.JdbcCacheAIASource
- All Implemented Interfaces:
eu.europa.esig.dss.spi.x509.aia.AIASource,Serializable
public class JdbcCacheAIASource
extends eu.europa.esig.dss.spi.x509.aia.RepositoryAIASource
The class represents a JDBC cached AIA Source
- See Also:
-
Nested Class Summary
Nested ClassesModifier and TypeClassDescriptionprotected static classRepresents an AIA record extracted from the SQL database table -
Field Summary
FieldsModifier and TypeFieldDescriptionprotected eu.europa.esig.dss.spi.client.jdbc.JdbcCacheConnectorConnection to databaseFields inherited from class eu.europa.esig.dss.spi.x509.aia.RepositoryAIASource
proxiedSource -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoidRemoves table from DBprotected Set<eu.europa.esig.dss.model.x509.CertificateToken> findCertificates(String key) protected eu.europa.esig.dss.spi.client.jdbc.query.SqlSelectQueryReturns an SQL query to extract AIA certificates from a tableprotected eu.europa.esig.dss.spi.client.jdbc.query.SqlSelectQueryReturns an SQL query to extract stored AIA keys in a tableprotected eu.europa.esig.dss.spi.client.jdbc.query.SqlQueryReturns CREATE_TABLE sql queryprotected eu.europa.esig.dss.spi.client.jdbc.query.SqlQueryReturns an sql query to remove a table from DBprotected eu.europa.esig.dss.spi.client.jdbc.query.SqlQueryReturns an SQL query to insert a new CRL to a tableprotected eu.europa.esig.dss.spi.client.jdbc.query.SqlQueryReturns an sql query to remove a record from DBprotected eu.europa.esig.dss.spi.client.jdbc.query.SqlQueryReturns an sql query to check table existencevoidInitialize the table.protected voidinsertCertificate(String aiaKey, eu.europa.esig.dss.model.x509.CertificateToken certificateTokens) booleanChecks of the table is createdprotected voidremoveCertificates(String aiaKey) voidsetJdbcCacheConnector(eu.europa.esig.dss.spi.client.jdbc.JdbcCacheConnector jdbcCacheConnector) Sets the SQL connection DataSourceMethods inherited from class eu.europa.esig.dss.spi.x509.aia.RepositoryAIASource
getAIAKey, getCertificatesByAIA, getCertificatesByAIA, getCertificateTokenAIAUrl, getUniqueCertificateAiaId, initCertificateAIAKeys, setProxySource
-
Field Details
-
jdbcCacheConnector
protected transient eu.europa.esig.dss.spi.client.jdbc.JdbcCacheConnector jdbcCacheConnectorConnection to database
-
-
Constructor Details
-
JdbcCacheAIASource
public JdbcCacheAIASource()Default constructor with null JdbcCacheConnector
-
-
Method Details
-
setJdbcCacheConnector
public void setJdbcCacheConnector(eu.europa.esig.dss.spi.client.jdbc.JdbcCacheConnector jdbcCacheConnector) Sets the SQL connection DataSource- Parameters:
jdbcCacheConnector-JdbcCacheConnector
-
getCreateTableQuery
protected eu.europa.esig.dss.spi.client.jdbc.query.SqlQuery getCreateTableQuery()Returns CREATE_TABLE sql query- Returns:
SqlQuery
-
getTableExistenceQuery
protected eu.europa.esig.dss.spi.client.jdbc.query.SqlQuery getTableExistenceQuery()Returns an sql query to check table existence- Returns:
SqlQuery
-
getDeleteTableQuery
protected eu.europa.esig.dss.spi.client.jdbc.query.SqlQuery getDeleteTableQuery()Returns an sql query to remove a table from DB- Returns:
SqlQuery
-
getInsertCertificateTokenEntryQuery
protected eu.europa.esig.dss.spi.client.jdbc.query.SqlQuery getInsertCertificateTokenEntryQuery()Returns an SQL query to insert a new CRL to a table- Returns:
SqlQuery
-
getRemoveCertificateTokenEntryQuery
protected eu.europa.esig.dss.spi.client.jdbc.query.SqlQuery getRemoveCertificateTokenEntryQuery()Returns an sql query to remove a record from DB- Returns:
SqlQuery
-
getAIACertificatesExtractQuery
protected eu.europa.esig.dss.spi.client.jdbc.query.SqlSelectQuery getAIACertificatesExtractQuery()Returns an SQL query to extract AIA certificates from a table- Returns:
SqlSelectQuery
-
getAIAKeysExtractQuery
protected eu.europa.esig.dss.spi.client.jdbc.query.SqlSelectQuery getAIAKeysExtractQuery()Returns an SQL query to extract stored AIA keys in a table- Returns:
SqlSelectQuery
-
findCertificates
- Specified by:
findCertificatesin classeu.europa.esig.dss.spi.x509.aia.RepositoryAIASource
-
insertCertificate
protected void insertCertificate(String aiaKey, eu.europa.esig.dss.model.x509.CertificateToken certificateTokens) - Specified by:
insertCertificatein classeu.europa.esig.dss.spi.x509.aia.RepositoryAIASource
-
removeCertificates
- Specified by:
removeCertificatesin classeu.europa.esig.dss.spi.x509.aia.RepositoryAIASource
-
getExistingAIAKeys
- Specified by:
getExistingAIAKeysin classeu.europa.esig.dss.spi.x509.aia.RepositoryAIASource
-
initTable
Initialize the table.- Throws:
SQLException- in case of SQL connection error
-
isTableExists
public boolean isTableExists()Checks of the table is created- Returns:
- TRUE if the table is created, FALSE otherwise
-
destroyTable
Removes table from DB- Throws:
SQLException- in case of error
-