Class CteValuesListBulkIdStrategy

  • All Implemented Interfaces:
    MultiTableBulkIdStrategy

    public class CteValuesListBulkIdStrategy
    extends java.lang.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
         )