Package eu.europa.esig.dss.spi.client.jdbc

Class JdbcCacheConnector

java.lang.Object

eu.europa.esig.dss.spi.client.jdbc.JdbcCacheConnector

public class JdbcCacheConnector
extends Object

This class executes calls to a data source

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	JdbcCacheConnector.JdbcResultRecord	This class represents a row result object of an SQL SELECT query
static class	JdbcCacheConnector.JdbcResultRequest	This class represents a relationship a column's name to be requested and their corresponding target classes to convert the extracted values to

Constructor Summary

Constructors

Constructor	Description
JdbcCacheConnector(DataSource dataSource)	Default constructor

Method Summary

Modifier and Type	Method	Description
protected void	closeQuietly(Connection c, Statement s, ResultSet rs)	Close the statement and connection and resultset without throwing the exception
int	execute(String query, Object... arguments)	This method allows to execute a query with a custom set of arguments, such as SELECT, UPDATE or DELETE, by handling an exception.
int	executeThrowable(String query)	This method allows executing of INSERT, UPDATE or DELETE queries, by throwing an exception in case of an error
protected void	rollback(Connection c)	Rollback transaction for the given Connection
Collection<JdbcCacheConnector.JdbcResultRecord>	select(String selectQuery, Collection<JdbcCacheConnector.JdbcResultRequest> requests, Object... arguments)	This method executes the query and returns a collection of selected objects
boolean	tableQuery(String query)	This method allows table creation, removal and existence check

Methods inherited from class java.lang.Object

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

Constructor Details

JdbcCacheConnector

public JdbcCacheConnector(DataSource dataSource)

Default constructor

Parameters:

dataSource - DataSource to connect with

Method Details

execute

public int execute(String query,
 Object... arguments)

This method allows to execute a query with a custom set of arguments, such as SELECT, UPDATE or DELETE, by handling an exception.

Parameters:

query - String the query string

arguments - an array of Objects, representing the query arguments

Returns:

number of rows concerned by the query

select

public Collection<JdbcCacheConnector.JdbcResultRecord> select(String selectQuery,
 Collection<JdbcCacheConnector.JdbcResultRequest> requests,
 Object... arguments)

This method executes the query and returns a collection of selected objects

Parameters:

selectQuery - String the query string to SELECT objects

requests - a collection of JdbcCacheConnector.JdbcResultRequests representing a relationship between the column names to be extracted and their respectful classes to cast the extracted objects to

arguments - an array of Objects, representing the query arguments

Returns:

a collection of JdbcCacheConnector.JdbcResultRecords

tableQuery

public boolean tableQuery(String query)

This method allows table creation, removal and existence check

Parameters:

query - String the query

Returns:

TRUE if the query has been executed successfully, FALSE otherwise

executeThrowable

public int executeThrowable(String query)
                     throws SQLException

This method allows executing of INSERT, UPDATE or DELETE queries, by throwing an exception in case of an error

Parameters:

query - String the query string

Returns:

number of concerned rows

Throws:

SQLException - if an exception occurs

rollback

protected void rollback(Connection c)

Rollback 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