public class

PostgresPlusDialect

extends PostgreSQLDialect
java.lang.Object
   ↳ org.hibernate.dialect.Dialect
     ↳ org.hibernate.dialect.PostgreSQLDialect
       ↳ org.hibernate.dialect.PostgresPlusDialect

Class Overview

An SQL dialect for Postgres Plus

Summary

[Expand]
Inherited Constants
From class org.hibernate.dialect.Dialect
Public Constructors
PostgresPlusDialect()
Public Methods
String getCurrentTimestampSQLFunctionName()
The name of the database-specific SQL function for retrieving the current timestamp.
String getCurrentTimestampSelectString()
Retrieve the command used to retrieve the current timestamp from the database.
ResultSet getResultSet(CallableStatement ps)
Given a callable statement previously processed by registerResultSetOutParameter(CallableStatement, int), extract the ResultSet from the OUT parameter.
String getSelectGUIDString()
Get the command used to select a GUID from the underlying database.
int registerResultSetOutParameter(CallableStatement statement, int col)
Registers an OUT parameter which will be returning a ResultSet.
[Expand]
Inherited Methods
From class org.hibernate.dialect.PostgreSQLDialect
From class org.hibernate.dialect.Dialect
From class java.lang.Object

Public Constructors

public PostgresPlusDialect ()

Public Methods

public String getCurrentTimestampSQLFunctionName ()

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

Returns
  • The function name.

public String getCurrentTimestampSelectString ()

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

Returns
  • The command.

public ResultSet getResultSet (CallableStatement ps)

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

Parameters
ps The callable statement.
Returns
  • The extracted result set.
Throws
SQLException

public String getSelectGUIDString ()

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

Optional operation.

Returns
  • The appropriate command.

public int registerResultSetOutParameter (CallableStatement statement, int col)

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

Parameters
statement The callable statement.
col The bind position at which to register the OUT param.
Returns
  • The number of (contiguous) bind positions used.
Throws
SQLException