com.communote.server.core.database.config

Class StandardDatabaseConfiguration

java.lang.Object

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

All Implemented Interfaces:

DatabaseConfiguration

Direct Known Subclasses:

FulltextSupportingDatabaseConfiguration

public class StandardDatabaseConfiguration
extends Object
implements DatabaseConfiguration

DatabaseConfiguration without fulltext support. The HQL fulltext function will be translated to a standard LIKE query.

Author:

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

Field Summary

Fields

Modifier and Type	Field and Description
static String	COMMUNOTE_CONNECTION_PROVIDER_CLASS Name of a System property which can hold the full qualified class name of a org.hibernate.connection.ConnectionProvider

Constructor Summary

Constructors

Constructor and Description
StandardDatabaseConfiguration()

Method Summary

Modifier and Type	Method and Description
String	getConnectionProviderClassName() Get the class name of the org.hibernate.connection.ConnectionProvider to use.
org.hibernate.dialect.function.SQLFunction	getDatepartSQLFunction() Get the SQLFunction that will translate the HQL 'datepart' function to SQL.
String	getFulltextParameterValue(String pattern, org.hibernate.criterion.MatchMode matchMode) Get the (database specific) parameter value for the given pattern
String	getFulltextParameterValue(String pattern, org.hibernate.criterion.MatchMode matchMode, boolean doNotUseFulltext) Get the (database specific) parameter value for the given pattern
org.hibernate.dialect.function.SQLFunction	getFulltextSQLFunction() Return the SQL function that translates the HQL 'fulltext' function to SQL.
boolean	isExtendSubselectsWithOuterConditions() Determine if subselects should be extended by using conditions of the outer clause.
boolean	isUseFulltextFeature()

Methods inherited from class java.lang.Object

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

Field Detail

COMMUNOTE_CONNECTION_PROVIDER_CLASS

public static final String COMMUNOTE_CONNECTION_PROVIDER_CLASS

Name of a System property which can hold the full qualified class name of a org.hibernate.connection.ConnectionProvider

See Also:

Constant Field Values

Constructor Detail

StandardDatabaseConfiguration

public StandardDatabaseConfiguration()

Method Detail

getConnectionProviderClassName

public String getConnectionProviderClassName()

Get the class name of the org.hibernate.connection.ConnectionProvider to use. This implementation will return the value of the system property "communote.connectionProviderClass" or C3P0DataSourceConnectionProvider if the property is not set.

Specified by:

getConnectionProviderClassName in interface DatabaseConfiguration

Returns:

the full qualified class name of the connection provider

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

Returns:

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

getFulltextParameterValue

public String getFulltextParameterValue(String pattern,
                                        org.hibernate.criterion.MatchMode matchMode,
                                        boolean doNotUseFulltext)

Get the (database specific) parameter value for the given pattern Evaluates to the % syntax

Specified by:

getFulltextParameterValue in interface DatabaseConfiguration

Parameters:

pattern - the pattern

matchMode - the hibernate match mode

doNotUseFulltext - true if the parameter should use the like wildcards matching even if fulltext is enabled

Returns:

the parameter value to be used in the final query

getFulltextParameterValue

public final String getFulltextParameterValue(String pattern,
                                              org.hibernate.criterion.MatchMode matchMode)

Get the (database specific) parameter value for the given pattern Evaluates to the % syntax

Specified by:

getFulltextParameterValue in interface DatabaseConfiguration

Parameters:

pattern - the pattern

matchMode - the hibernate match mode

Returns:

the parameter value to be used in the final query

getFulltextSQLFunction

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

Return the SQL function that translates the HQL 'fulltext' function to SQL.

The HQL 'fulltext' function takes two arguments: The field to be search and the string to search for. In HQL the fulltext function has always to be matched against 1, e.g. fulltext(content.content, 'mysearch') = 1. BUT if you want the negation use: not (fulltext(content.content,'mysearch'))

When building queries with the HQL fulltext function always use the DatabaseConfiguration.getFulltextParameterValue(String, MatchMode) to set the parameter values because the syntax differs per database

The like function will be returned

Specified by:

getFulltextSQLFunction in interface DatabaseConfiguration

Returns:

The SQLFunction that will render the HQL 'fulltext' function

isExtendSubselectsWithOuterConditions

public boolean isExtendSubselectsWithOuterConditions()

Description copied from interface: DatabaseConfiguration

Determine if subselects should be extended by using conditions of the outer clause.

See the MSSQL Implementation for an example.

Specified by:

isExtendSubselectsWithOuterConditions in interface DatabaseConfiguration

Returns:

true if the subselect should be extended

isUseFulltextFeature

public boolean isUseFulltextFeature()

Specified by:

isUseFulltextFeature in interface DatabaseConfiguration

Returns:

always returns false