org.hibernate.hql.spi.id.cte

Class CteValuesListBulkIdStrategy

java.lang.Object

org.hibernate.hql.spi.id.cte.CteValuesListBulkIdStrategy

All Implemented Interfaces:

MultiTableBulkIdStrategy

public class CteValuesListBulkIdStrategy
extends Object
implements MultiTableBulkIdStrategy

This bulk-id strategy uses a CTE with a VALUE list to hold the identifiers, which are later used by the update or delete statement:

 with HT_Person (id ) as (
     select
         id
     from (
         values
             (?),
             (?),
             (?)
             (?)
     ) as HT (id)
 )
 delete
 from
     Person
 where
     ( id ) in (
         select
             id
         from
             HT_Person
     )
 

Author:

Evandro Pires da Silva, Vlad Mihalcea

Nested Class Summary

Nested classes/interfaces inherited from interface org.hibernate.hql.spi.id.MultiTableBulkIdStrategy

MultiTableBulkIdStrategy.DeleteHandler, MultiTableBulkIdStrategy.UpdateHandler

Field Summary

Fields

Modifier and Type	Field and Description
static CteValuesListBulkIdStrategy	INSTANCE

Constructor Summary

Constructors

Constructor and Description
CteValuesListBulkIdStrategy()

Method Summary

Modifier and Type	Method and Description
MultiTableBulkIdStrategy.DeleteHandler	buildDeleteHandler(SessionFactoryImplementor factory, HqlSqlWalker walker) Build a handler capable of handling the bulk delete indicated by the given walker.
MultiTableBulkIdStrategy.UpdateHandler	buildUpdateHandler(SessionFactoryImplementor factory, HqlSqlWalker walker) Build a handler capable of handling the bulk update indicated by the given walker.
void	prepare(JdbcServices jdbcServices, JdbcConnectionAccess jdbcConnectionAccess, MetadataImplementor metadataImplementor, SessionFactoryOptions sessionFactoryOptions) Prepare the strategy.
void	release(JdbcServices jdbcServices, JdbcConnectionAccess connectionAccess) Release the strategy.

Methods inherited from class java.lang.Object

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

Field Detail

INSTANCE

public static final CteValuesListBulkIdStrategy INSTANCE

Constructor Detail

CteValuesListBulkIdStrategy

public CteValuesListBulkIdStrategy()

Method Detail

prepare

public void prepare(JdbcServices jdbcServices,
                    JdbcConnectionAccess jdbcConnectionAccess,
                    MetadataImplementor metadataImplementor,
                    SessionFactoryOptions sessionFactoryOptions)

Description copied from interface: MultiTableBulkIdStrategy

Prepare the strategy. Called as the SessionFactory is being built. Intended patterns here include:

• Adding tables to the passed Mappings, to be picked by by "schema management tools"
• Manually creating the tables immediately through the passed JDBC Connection access

Specified by:

prepare in interface MultiTableBulkIdStrategy

Parameters:

jdbcServices - The JdbcService object

jdbcConnectionAccess - Access to the JDBC Connection

metadataImplementor - Access to the O/RM mapping information

release

public void release(JdbcServices jdbcServices,
                    JdbcConnectionAccess connectionAccess)

Description copied from interface: MultiTableBulkIdStrategy

Release the strategy. Called as the SessionFactory is being shut down.

Specified by:

release in interface MultiTableBulkIdStrategy

Parameters:

jdbcServices - The JdbcService object

connectionAccess - Access to the JDBC Connection

buildUpdateHandler

public MultiTableBulkIdStrategy.UpdateHandler buildUpdateHandler(SessionFactoryImplementor factory,
                                                                 HqlSqlWalker walker)

Description copied from interface: MultiTableBulkIdStrategy

Build a handler capable of handling the bulk update indicated by the given walker.

Specified by:

buildUpdateHandler in interface MultiTableBulkIdStrategy

Parameters:

factory - The SessionFactory

walker - The AST walker, representing the update query

Returns:

The handler

buildDeleteHandler

public MultiTableBulkIdStrategy.DeleteHandler buildDeleteHandler(SessionFactoryImplementor factory,
                                                                 HqlSqlWalker walker)

Description copied from interface: MultiTableBulkIdStrategy

Build a handler capable of handling the bulk delete indicated by the given walker.

Specified by:

buildDeleteHandler in interface MultiTableBulkIdStrategy

Parameters:

factory - The SessionFactory

walker - The AST walker, representing the delete query

Returns:

The handler