Top Description Constructors Methods
org.hibernate.dialect

public Class PostgresPlusDialect

extends PostgreSQLDialect
Class Inheritance
Imports
java.sql.Types, .SQLException, .CallableStatement, .ResultSet, org.hibernate.dialect.function.NoArgSQLFunction, .NvlFunction, .StandardSQLFunction, org.hibernate.type.StandardBasicTypes
An SQL dialect for Postgres Plus
Author
Jim Mlodgenski

Constructor Summary

AccessConstructor and Description
public
PostgresPlusDialect()

Method Summary

Modifier and TypeMethod and Description
public String
getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.PostgreSQLDialect.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.PostgreSQLDialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the java.sql.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 OUT param.
col)

Overrides org.hibernate.dialect.PostgreSQLDialect.registerResultSetOutParameter.

Registers an OUT parameter which will be returning a java.sql.ResultSet.
Inherited from org.hibernate.dialect.PostgreSQLDialect:
bindLimitParametersInReverseOrderdropConstraintsgetAddColumnStringgetCascadeConstraintsStringgetCreateSequenceStringgetCreateSequenceStringgetCreateTemporaryTablePostfixgetCreateTemporaryTableStringgetDropSequenceStringgetForUpdateStringgetForUpdateStringgetIdentityColumnStringgetIdentitySelectStringgetLimitStringgetNativeIdentifierGeneratorClassgetNoColumnsInsertStringgetQuerySequencesStringgetReadLockStringgetSelectClauseNullStringgetSelectSequenceNextValStringgetSequenceNextValStringgetViolatedConstraintNameExtractergetWriteLockStringhasDataTypeInIdentityColumnisCurrentTimestampSelectStringCallablesupportsCommentOnsupportsCurrentTimestampSelectionsupportsEmptyInListsupportsExpectedLobUsagePatternsupportsIdentityColumnssupportsLimitsupportsLobValueChangePropogationsupportsOuterJoinForUpdatesupportsPooledSequencessupportsSequencessupportsTemporaryTablessupportsTupleDistinctCountssupportsUnboundedLobLocatorMaterializationsupportsUnionAlltoBooleanValueStringuseInputStreamToInsertBlob

Constructor Detail

PostgresPlusDialectback to summary
public PostgresPlusDialect()

Method Detail

getCurrentTimestampSelectStringback to summary
public String getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.PostgreSQLDialect.getCurrentTimestampSelectString.

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

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

Returns:String

The command.

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.

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

Overrides org.hibernate.dialect.PostgreSQLDialect.getResultSet.

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

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

Parameters
ps:CallableStatement

The callable statement.

Returns:ResultSet

The extracted result set.

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.

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

Overrides org.hibernate.dialect.PostgreSQLDialect.registerResultSetOutParameter.

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

Registers an OUT parameter which will be returning a java.sql.ResultSet. How this is accomplished varies greatly from DB to DB, hence its inclusion (along with getResultSet) here.

Parameters
statement:CallableStatement

The callable statement.

col:int

The bind position at which to register the OUT param.

Returns:int

The number of (contiguous) bind positions used.

Exceptions
SQLException:
Indicates problems registering the OUT param.