com.github.grimsa.hibernate:single-table-bulk-id-strategy

Single Table Bulk ID Strategy for Hibernate

License	Public domain (Unlicense)
Categories	Hibernate Data ORM
GroupId	com.github.grimsa.hibernate
ArtifactId	single-table-bulk-id-strategy
Last Version	1.3
Release Date	Apr 8, 2020
Type	jar
Description	com.github.grimsa.hibernate:single-table-bulk-id-strategy Single Table Bulk ID Strategy for Hibernate
Project URL	https://github.com/grimsa/hibernate-single-table-bulk-id-strategy
Source Code Management	https://github.com/grimsa/hibernate-single-table-bulk-id-strategy

Download single-table-bulk-id-strategy

Filename	Size
single-table-bulk-id-strategy-1.3.pom
single-table-bulk-id-strategy-1.3.jar	8 KB
single-table-bulk-id-strategy-1.3-sources.jar	4 KB
single-table-bulk-id-strategy-1.3-javadoc.jar	26 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/com.github.grimsa.hibernate/single-table-bulk-id-strategy/ -->
<dependency>
    <groupId>com.github.grimsa.hibernate</groupId>
    <artifactId>single-table-bulk-id-strategy</artifactId>
    <version>1.3</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/com.github.grimsa.hibernate/single-table-bulk-id-strategy/
implementation 'com.github.grimsa.hibernate:single-table-bulk-id-strategy:1.3'

Gradle Kotlin

// https://jarcasting.com/artifacts/com.github.grimsa.hibernate/single-table-bulk-id-strategy/
implementation ("com.github.grimsa.hibernate:single-table-bulk-id-strategy:1.3")

Apache Buildr

'com.github.grimsa.hibernate:single-table-bulk-id-strategy:jar:1.3'

Apache Ivy

<dependency org="com.github.grimsa.hibernate" name="single-table-bulk-id-strategy" rev="1.3">
  <artifact name="single-table-bulk-id-strategy" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='com.github.grimsa.hibernate', module='single-table-bulk-id-strategy', version='1.3')
)

Scala SBT

libraryDependencies += "com.github.grimsa.hibernate" % "single-table-bulk-id-strategy" % "1.3"

Leiningen

[com.github.grimsa.hibernate/single-table-bulk-id-strategy "1.3"]

Dependencies

provided (1)

Group / Artifact	Type	Version
org.hibernate : hibernate-core	jar	5.4.12.Final

test (3)

Group / Artifact	Type	Version
org.hibernate : hibernate-testing	jar	5.4.12.Final
junit : junit	jar	4.13
com.h2database : h2	jar	1.4.200

Project Modules

There are no modules declared in this project.

Single Global Temporary Table Bulk Id Strategy for Hibernate

Note: Hibernate 5.2.8 added new Bulk Id strategies, which make this project obsolete for most cases.

Hibernate's MultiTableBulkIdStrategy for Hibernate using using just a single pre-created global temporary table instead of a table per entity.

Can be useful in environments where DDL statements cannot be executed from application and managing a large number of ID tables is not practical.

How to use

1. Add a dependency to your project. For Maven, use the following:

<dependency>
  <groupId>com.github.grimsa.hibernate</groupId>
  <artifactId>single-table-bulk-id-strategy</artifactId>
  <version>1.3</version>
</dependency>

For Gradle:

dependencies {
   compile 'com.github.grimsa.hibernate:single-table-bulk-id-strategy:1.3'
}

2. Create a shared global temporary table, e.g.

create global temporary table HT_TEMP_IDS (ID CHAR(36), ENTITY_NAME VARCHAR(100));

3. Set the following Hibernate properties:

config.setProperty(AvailableSettings.HQL_BULK_ID_STRATEGY, SingleGlobalTemporaryTableBulkIdStrategy.class.getName());
config.setProperty(SingleGlobalTemporaryTableBulkIdStrategy.TABLE, "HT_TEMP_IDS");
config.setProperty(SingleGlobalTemporaryTableBulkIdStrategy.ID_COLUMN, "ID");                      // "ID" is default
config.setProperty(SingleGlobalTemporaryTableBulkIdStrategy.DISCRIMINATOR_COLUMN, "ENTITY_NAME");  // "ENTITY_NAME" is default
config.setProperty(SingleGlobalTemporaryTableBulkIdStrategy.CLEAN_ROWS, "true");

Release history

• 1.3 released 2020-04-08
  • Added support for overridden table ID columns when deleting from many-to-many join tables(#3)
  • Upgraded Hibernate to 5.4.12
• 1.2 released 2017-07-24
  • Support different ID column names in entities (#1)
• 1.1 released 2016-09-29
  • Update to support Hibernate 5.2
• 1.0 released 2016-09-29
  • Initial version built for Hibernate 5.1 and JDK 1.8

Versions

Version
1.3 Apr 8, 2020
1.2 Jul 24, 2017
1.1 Sep 29, 2016
1.0 Sep 29, 2016