Package org.hibernate.dialect.aggregate

Class SybaseASEAggregateSupport

java.lang.Object

org.hibernate.dialect.aggregate.AggregateSupportImpl

org.hibernate.dialect.aggregate.SybaseASEAggregateSupport

All Implemented Interfaces:

AggregateSupport

public class SybaseASEAggregateSupport
extends AggregateSupportImpl

Sybase ASE supports the xmlextract() function which is used to implement aggregate support. One notable quirk of Sybase ASE that causes a lot of ugly code is that a SQL NULL in string concatenation is treated as empty string and hence does not produce NULL. So in order to get correct results, it is necessary to wrap concatenation expressions with case expressions, that ensure NULL is produced if any of the concatenation expressions is NULL.

Nested Class Summary

Nested classes/interfaces inherited from interface org.hibernate.dialect.aggregate.AggregateSupport

AggregateSupport.AggregateColumnWriteExpression, AggregateSupport.WriteExpressionRenderer

Method Summary

Modifier and Type	Method	Description
String	aggregateComponentAssignmentExpression(String aggregateParentAssignmentExpression, String columnExpression, int aggregateColumnTypeCode, Column column)	Returns the assignment expression to use for column, which is part of the aggregate type of aggregatePath.
String	aggregateComponentCustomReadExpression(String template, String placeholder, String aggregateParentReadExpression, String columnExpression, int aggregateColumnTypeCode, SqlTypedMapping column, TypeConfiguration typeConfiguration)	Returns the custom read expression to use for column.
String	aggregateCustomWriteExpression(AggregateColumn aggregateColumn, List<Column> aggregatedColumns)	Returns the custom write expression to use for an aggregate column of the given column type, containing the given aggregated columns.
AggregateSupport.WriteExpressionRenderer	aggregateCustomWriteExpressionRenderer(SelectableMapping aggregateColumn, SelectableMapping[] columnsToUpdate, TypeConfiguration typeConfiguration)
boolean	requiresAggregateCustomWriteExpressionRenderer(int aggregateSqlTypeCode)	Whether AggregateSupport.aggregateCustomWriteExpressionRenderer(SelectableMapping, SelectableMapping[], TypeConfiguration) is needed when assigning an expression to individual aggregated columns in an update statement.
boolean	supportsComponentCheckConstraints()	Returns whether the database supports the use of a check constraint on tables, to implement not-null and other constraints of an aggregate type.
static AggregateSupport	valueOf(Dialect dialect)

Methods inherited from class org.hibernate.dialect.aggregate.AggregateSupportImpl

aggregateAuxiliaryDatabaseObjects, aggregateComponentSqlTypeCode, preferBindAggregateMapping, preferSelectAggregateMapping

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.hibernate.dialect.aggregate.AggregateSupport

aggregateComponentAssignmentExpression, aggregateComponentCustomReadExpression

Method Details

valueOf

public static AggregateSupport valueOf(Dialect dialect)

supportsComponentCheckConstraints

public boolean supportsComponentCheckConstraints()

Description copied from interface: AggregateSupport

Returns whether the database supports the use of a check constraint on tables, to implement not-null and other constraints of an aggregate type.

Specified by:

supportsComponentCheckConstraints in interface AggregateSupport

Overrides:

supportsComponentCheckConstraints in class AggregateSupportImpl

aggregateComponentCustomReadExpression

public String aggregateComponentCustomReadExpression(String template,
 String placeholder,
 String aggregateParentReadExpression,
 String columnExpression,
 int aggregateColumnTypeCode,
 SqlTypedMapping column,
 TypeConfiguration typeConfiguration)

Description copied from interface: AggregateSupport

Returns the custom read expression to use for column. Replaces the given placeholder in the given template by the custom read expression to use for column.

Specified by:

aggregateComponentCustomReadExpression in interface AggregateSupport

Overrides:

aggregateComponentCustomReadExpression in class AggregateSupportImpl

Parameters:

template - The custom read expression template of the column

placeholder - The placeholder to replace with the actual read expression

aggregateParentReadExpression - The expression to the aggregate column, which contains the column

columnExpression - The column within the aggregate type, for which to return the read expression

aggregateColumnTypeCode - The SQL type code of the aggregate column

column - The column within the aggregate type, for which to return the read expression

typeConfiguration - The type configuration

aggregateComponentAssignmentExpression

public String aggregateComponentAssignmentExpression(String aggregateParentAssignmentExpression,
 String columnExpression,
 int aggregateColumnTypeCode,
 Column column)

Description copied from interface: AggregateSupport

Returns the assignment expression to use for column, which is part of the aggregate type of aggregatePath.

Specified by:

aggregateComponentAssignmentExpression in interface AggregateSupport

Overrides:

aggregateComponentAssignmentExpression in class AggregateSupportImpl

Parameters:

aggregateParentAssignmentExpression - The expression to the aggregate column, which contains the column

columnExpression - The column within the aggregate type, for which to return the assignment expression

aggregateColumnTypeCode - The SQL type code of the aggregate column

column - The column within the aggregate type, for which to return the assignment expression

aggregateCustomWriteExpression

public String aggregateCustomWriteExpression(AggregateColumn aggregateColumn,
 List<Column> aggregatedColumns)

Description copied from interface: AggregateSupport

Returns the custom write expression to use for an aggregate column of the given column type, containing the given aggregated columns.

Specified by:

aggregateCustomWriteExpression in interface AggregateSupport

Overrides:

aggregateCustomWriteExpression in class AggregateSupportImpl

Parameters:

aggregateColumn - The type information for the aggregate column

aggregatedColumns - The columns of the aggregate type

requiresAggregateCustomWriteExpressionRenderer

public boolean requiresAggregateCustomWriteExpressionRenderer(int aggregateSqlTypeCode)

Description copied from interface: AggregateSupport

Whether AggregateSupport.aggregateCustomWriteExpressionRenderer(SelectableMapping, SelectableMapping[], TypeConfiguration) is needed when assigning an expression to individual aggregated columns in an update statement.

Specified by:

requiresAggregateCustomWriteExpressionRenderer in interface AggregateSupport

Overrides:

requiresAggregateCustomWriteExpressionRenderer in class AggregateSupportImpl

aggregateCustomWriteExpressionRenderer

public AggregateSupport.WriteExpressionRenderer aggregateCustomWriteExpressionRenderer(SelectableMapping aggregateColumn,
 SelectableMapping[] columnsToUpdate,
 TypeConfiguration typeConfiguration)

Specified by:

aggregateCustomWriteExpressionRenderer in interface AggregateSupport

Overrides:

aggregateCustomWriteExpressionRenderer in class AggregateSupportImpl

Parameters:

aggregateColumn - The mapping of the aggregate column

columnsToUpdate - The mappings of the columns that should be updated

typeConfiguration - The type configuration