Top Description Constructors Methods
org.hibernate.dialect

public Class PostgresPlusDialect

extends PostgreSQLDialect
Class Inheritance
Annotations
@SuppressWarnings:deprecation
Imports
java.sql.CallableStatement, .ResultSet, .SQLException, .Types, org.hibernate.dialect.function.NoArgSQLFunction, .NvlFunction, .StandardSQLFunction, org.hibernate.type.StandardBasicTypes

Deprecated

as a consequence of PostgreSQLDialect being deprecated. See corresponding docs for further information.

An SQL dialect for Postgres Plus
Author
Jim Mlodgenski

Constructor Summary

AccessConstructor and Description
public
PostgresPlusDialect()

Constructs a PostgresPlusDialect

Method Summary

Modifier and TypeMethod and Description
public String
getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.PostgreSQL81Dialect.getCurrentTimestampSelectString.

Retrieve the command used to retrieve the current timestamp from the database.
public String
getCurrentTimestampSQLFunctionName()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

The name of the database-specific SQL function for retrieving the current timestamp.
public ResultSet
getResultSet(CallableStatement
The callable statement.
ps)

Overrides org.hibernate.dialect.PostgreSQL81Dialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the ResultSet from the OUT parameter.
public String
getSelectGUIDString()

Overrides org.hibernate.dialect.Dialect.getSelectGUIDString.

Get the command used to select a GUID from the underlying database.
public int
registerResultSetOutParameter(CallableStatement
The callable statement.
statement, int
The bind position at which to register the output param.
col)

Overrides org.hibernate.dialect.PostgreSQL81Dialect.registerResultSetOutParameter.

Registers a parameter (either OUT, or the new REF_CURSOR param type available in Java 8) capable of returning ResultSet *by position*.

Constructor Detail

PostgresPlusDialectback to summary
public PostgresPlusDialect()

Constructs a PostgresPlusDialect

Method Detail

getCurrentTimestampSelectStringback to summary
public String getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.PostgreSQL81Dialect.getCurrentTimestampSelectString.

Doc from org.hibernate.dialect.Dialect.getCurrentTimestampSelectString.

Retrieve the command used to retrieve the current timestamp from the database.

Returns:String

The command.

Annotations
@Override
getCurrentTimestampSQLFunctionNameback to summary
public String getCurrentTimestampSQLFunctionName()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

Doc from org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

The name of the database-specific SQL function for retrieving the current timestamp.

Returns:String

The function name.

Annotations
@Override
getResultSetback to summary
public ResultSet getResultSet(CallableStatement ps) throws SQLException

Overrides org.hibernate.dialect.PostgreSQL81Dialect.getResultSet.

Doc from org.hibernate.dialect.Dialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the ResultSet from the OUT parameter.

Parameters
ps:CallableStatement

The callable statement.

Returns:ResultSet

The extracted result set.

Annotations
@Override
Exceptions
SQLException:
Indicates problems extracting the result set.
getSelectGUIDStringback to summary
public String getSelectGUIDString()

Overrides org.hibernate.dialect.Dialect.getSelectGUIDString.

Doc from org.hibernate.dialect.Dialect.getSelectGUIDString.

Get the command used to select a GUID from the underlying database.

Optional operation.

Returns:String

The appropriate command.

Annotations
@Override
registerResultSetOutParameterback to summary
public int registerResultSetOutParameter(CallableStatement statement, int col) throws SQLException

Overrides org.hibernate.dialect.PostgreSQL81Dialect.registerResultSetOutParameter.

Doc from org.hibernate.dialect.Dialect.registerResultSetOutParameter.

Registers a parameter (either OUT, or the new REF_CURSOR param type available in Java 8) capable of returning ResultSet *by position*. Pre-Java 8, registering such ResultSet-returning parameters varied greatly across database and drivers; hence its inclusion as part of the Dialect contract.

Parameters
statement:CallableStatement

The callable statement.

col:int

The bind position at which to register the output param.

Returns:int

The number of (contiguous) bind positions used.

Annotations
@Override
Exceptions
SQLException:
Indicates problems registering the param.