Package org.forgerock.openidm.repo.jdbc.impl

Class PostgreSQLTableHandler

java.lang.Object

org.forgerock.openidm.repo.jdbc.impl.GenericTableHandler

org.forgerock.openidm.repo.jdbc.impl.PostgreSQLTableHandler

All Implemented Interfaces:

TableHandler

public class PostgreSQLTableHandler
extends GenericTableHandler

Postgres-specific generic table handler.

Nested Class Summary

Nested classes/interfaces inherited from class org.forgerock.openidm.repo.jdbc.impl.GenericTableHandler

GenericTableHandler.QueryDefinition

Field Summary

Fields inherited from class org.forgerock.openidm.repo.jdbc.impl.GenericTableHandler

DEFAULT_SEARCHABLE_LENGTH

Constructor Summary

Constructors

Constructor	Description
PostgreSQLTableHandler(org.forgerock.json.JsonValue tableConfig, String dbSchemaName, org.forgerock.json.JsonValue queriesConfig, org.forgerock.json.JsonValue commandsConfig, int maxBatchSize, SQLExceptionHandler sqlExceptionHandler)	Construct a table handler for Postgres using Postgres-specific json-handling

Method Summary

Modifier and Type	Method	Description
protected Map<GenericTableHandler.QueryDefinition,String>	initializeQueryMap()
String	renderQueryFilter(org.forgerock.util.query.QueryFilter<org.forgerock.json.JsonPointer> filter, Map<String,Object> replacementTokens, Map<String,Object> params)	Render and SQL SELECT statement with placeholders for the given query filter.

Methods inherited from class org.forgerock.openidm.repo.jdbc.impl.GenericTableHandler

command, create, delete, getPreparedStatement, isErrorType, isRetryable, prepareSortKeyStatements, query, queryIdExists, read, readForUpdate, toString, update

Methods inherited from class java.lang.Object

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

Constructor Details

PostgreSQLTableHandler

public PostgreSQLTableHandler(org.forgerock.json.JsonValue tableConfig,
 String dbSchemaName,
 org.forgerock.json.JsonValue queriesConfig,
 org.forgerock.json.JsonValue commandsConfig,
 int maxBatchSize,
 SQLExceptionHandler sqlExceptionHandler)

Construct a table handler for Postgres using Postgres-specific json-handling

Method Details

initializeQueryMap

protected Map<GenericTableHandler.QueryDefinition,String> initializeQueryMap()

Overrides:

initializeQueryMap in class GenericTableHandler

renderQueryFilter

public String renderQueryFilter(org.forgerock.util.query.QueryFilter<org.forgerock.json.JsonPointer> filter,
 Map<String,Object> replacementTokens,
 Map<String,Object> params)

Description copied from class: GenericTableHandler

Render and SQL SELECT statement with placeholders for the given query filter.

Specified by:

renderQueryFilter in interface TableHandler

Overrides:

renderQueryFilter in class GenericTableHandler

Parameters:

filter - the query filter

replacementTokens - a map to store any replacement tokens

params - a map containing query parameters

Returns:

an SQL SELECT statement