com.holonplatform.datastore.jdbc.dialect

Class PostgreSQLDialect

java.lang.Object

com.holonplatform.datastore.jdbc.dialect.PostgreSQLDialect

All Implemented Interfaces:

JdbcDialect, Serializable

public class PostgreSQLDialect
extends Object
implements JdbcDialect

PostgreSQL JdbcDialect.

Since:

5.0.0

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from interface com.holonplatform.datastore.jdbc.JdbcDialect

JdbcDialect.DialectResolutionContext, JdbcDialect.LimitHandler, JdbcDialect.SQLFunction, JdbcDialect.SQLParameterProcessor, JdbcDialect.SQLPathProcessor, JdbcDialect.SQLValueDeserializer, JdbcDialect.StatementConfigurationException, JdbcDialect.StatementConfigurator, JdbcDialect.StatementParameterHandler

Constructor Summary

Constructors

Constructor and Description
PostgreSQLDialect()

Method Summary

Modifier and Type	Method and Description
boolean	generatedKeyAlwaysReturned() Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds.
String	getColumnName(String columnName) Get the actual column name for given column name (for example, applying case transformations)
Optional<JdbcDialect.LimitHandler>	getLimitHandler() Get the JdbcDialect.LimitHandler
JdbcDialect.StatementConfigurator	getStatementConfigurator() Get the JdbcDialect.StatementConfigurator to use to configure JDBC statements.
Optional<JdbcDialect.StatementParameterHandler>	getStatementParameterHandler() Get the dialect JdbcDialect.StatementParameterHandler.
String	getTableName(String tableName) Get the actual table name for given table name (for example, applying case transformations)
void	init(JdbcDatastore datastore) Dialect initialization hook at parent datastore initialization.
boolean	supportsGetGeneratedKeys() Retrieves whether auto-generated keys can be retrieved after a statement has been executed.
boolean	supportsLikeEscapeClause() Retrieves whether this database supports specifying a LIKE escape clause.

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.holonplatform.datastore.jdbc.JdbcDialect

deleteStatementAliasSupported, deleteStatementTargetRequired, getFunction, getParameterProcessor, getPathProcessor, getPrimaryKey, getValueDeserializer, supportGetGeneratedKeyByName, useOuterInJoins

Constructor Detail

PostgreSQLDialect

public PostgreSQLDialect()

Method Detail

init

public void init(JdbcDatastore datastore)
          throws SQLException

Description copied from interface: JdbcDialect

Dialect initialization hook at parent datastore initialization.

Specified by:

init in interface JdbcDialect

Parameters:

datastore - Parent datastore

Throws:

SQLException - An error occurred during dialect initialization

getStatementConfigurator

public JdbcDialect.StatementConfigurator getStatementConfigurator()

Description copied from interface: JdbcDialect

Get the JdbcDialect.StatementConfigurator to use to configure JDBC statements.

Specified by:

getStatementConfigurator in interface JdbcDialect

Returns:

The StatementConfigurator (not null)

getStatementParameterHandler

public Optional<JdbcDialect.StatementParameterHandler> getStatementParameterHandler()

Description copied from interface: JdbcDialect

Get the dialect JdbcDialect.StatementParameterHandler.

Specified by:

getStatementParameterHandler in interface JdbcDialect

Returns:

Optional StatementParameterHandler

supportsLikeEscapeClause

public boolean supportsLikeEscapeClause()

Description copied from interface: JdbcDialect

Retrieves whether this database supports specifying a LIKE escape clause.

Specified by:

supportsLikeEscapeClause in interface JdbcDialect

Returns:

true if so; false otherwise

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()

Description copied from interface: JdbcDialect

Retrieves whether auto-generated keys can be retrieved after a statement has been executed.

Specified by:

supportsGetGeneratedKeys in interface JdbcDialect

Returns:

true if auto-generated keys can be retrieved after a statement has executed; false otherwise

generatedKeyAlwaysReturned

public boolean generatedKeyAlwaysReturned()

Description copied from interface: JdbcDialect

Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds. The key that is returned may or may not be based on the column(s) for the auto generated key.

Specified by:

generatedKeyAlwaysReturned in interface JdbcDialect

Returns:

true if so; false otherwise

getLimitHandler

public Optional<JdbcDialect.LimitHandler> getLimitHandler()

Description copied from interface: JdbcDialect

Get the JdbcDialect.LimitHandler

Specified by:

getLimitHandler in interface JdbcDialect

Returns:

Optional limit handler

getTableName

public String getTableName(String tableName)

Description copied from interface: JdbcDialect

Get the actual table name for given table name (for example, applying case transformations)

Specified by:

getTableName in interface JdbcDialect

Parameters:

tableName - Table name

Returns:

The actual table name

getColumnName

public String getColumnName(String columnName)

Description copied from interface: JdbcDialect

Get the actual column name for given column name (for example, applying case transformations)

Specified by:

getColumnName in interface JdbcDialect

Parameters:

columnName - Column name

Returns:

The actual column name