com.communote.server.core.database.config

Class PostgreSQLDatabaseConfiguration

java.lang.Object

com.communote.server.core.database.config.StandardDatabaseConfiguration

com.communote.server.core.database.config.FulltextSupportingDatabaseConfiguration

com.communote.server.core.database.config.PostgreSQLDatabaseConfiguration

All Implemented Interfaces:

DatabaseConfiguration

public class PostgreSQLDatabaseConfiguration
extends FulltextSupportingDatabaseConfiguration

Database configuration for PostgreSQL with fulltext capabilities

Author:

Communote GmbH - http://www.communote.com/

Field Summary

Fields inherited from class com.communote.server.core.database.config.StandardDatabaseConfiguration

COMMUNOTE_CONNECTION_PROVIDER_CLASS

Constructor Summary

Constructors

Constructor and Description
PostgreSQLDatabaseConfiguration()

Method Summary

Modifier and Type	Method and Description
org.hibernate.dialect.function.SQLFunction	getDatepartSQLFunction() Get the SQLFunction that will translate the HQL 'datepart' function to SQL.
protected String	getSpecificFulltextParameterValue(String pattern, org.hibernate.criterion.MatchMode matchMode) Take the pattern and match mode an return the parameter value to be used in the fulltext query.
protected org.hibernate.dialect.function.SQLFunction	getSpecificFulltextSQLFunction()

Methods inherited from class com.communote.server.core.database.config.FulltextSupportingDatabaseConfiguration

getFulltextParameterValue, getFulltextSQLFunction, getWildcardPattern, getWildcardPattern, isUseFulltextFeature, setUseFulltextFeature

Methods inherited from class com.communote.server.core.database.config.StandardDatabaseConfiguration

getConnectionProviderClassName, getFulltextParameterValue, isExtendSubselectsWithOuterConditions

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSQLDatabaseConfiguration

public PostgreSQLDatabaseConfiguration()

Method Detail

getDatepartSQLFunction

public org.hibernate.dialect.function.SQLFunction getDatepartSQLFunction()

Description copied from interface: DatabaseConfiguration

Get the SQLFunction that will translate the HQL 'datepart' function to SQL.

Usage: day_of_date(dateField, alias) where dateField must be one of the DateField constants Example in HQL to return the year of the publication date of a note: "date_part(" + DateField.YEAR + ", note.publication_date)"

Specified by:

getDatepartSQLFunction in interface DatabaseConfiguration

Overrides:

getDatepartSQLFunction in class StandardDatabaseConfiguration

Returns:

the SQLFunction that will render the HQL 'datepart' function or null if not supported

getSpecificFulltextParameterValue

protected String getSpecificFulltextParameterValue(String pattern,
                                                   org.hibernate.criterion.MatchMode matchMode)

Take the pattern and match mode an return the parameter value to be used in the fulltext query.

Specified by:

getSpecificFulltextParameterValue in class FulltextSupportingDatabaseConfiguration

Parameters:

pattern - the search string

matchMode - the match mode to use

Returns:

the parameter value

getSpecificFulltextSQLFunction

protected org.hibernate.dialect.function.SQLFunction getSpecificFulltextSQLFunction()

Specified by:

getSpecificFulltextSQLFunction in class FulltextSupportingDatabaseConfiguration

Returns:

the database specific fulltext SQL function (subclass will implement)