October 2022 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-15525) Allow Global- and PersistentTemporaryTableStrategy to participate in hbm2ddl

by Kai Zander (JIRA)

Kai Zander ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15525 ( https://hibernate.atlassian.net/browse/HHH-15525?atlOrigin=eyJpIjoiNDMxMD... ) Re: Allow Global- and PersistentTemporaryTableStrategy to participate in hbm2ddl ( https://hibernate.atlassian.net/browse/HHH-15525?atlOrigin=eyJpIjoiNDMxMD... ) Ah sorry, I just tried with 6.1.4.Final and no more temporary tables are being created 👍 My bad, thanks for the quick responses and fixes 🙂 ( https://hibernate.atlassian.net/browse/HHH-15525#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15525#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:b857cee )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15546) generate wrong ddl schema when use multi columns ManyToMany

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15546 ( https://hibernate.atlassian.net/browse/HHH-15546?atlOrigin=eyJpIjoiMWQ3YT... ) Re: generate wrong ddl schema when use multi columns ManyToMany ( https://hibernate.atlassian.net/browse/HHH-15546?atlOrigin=eyJpIjoiMWQ3YT... ) Hi ningpp ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , the ddl generated is correct, you are using the same table name of MiddleTable4 Entity as the @JoinTable of a @ManyToMany @Entity @Table(name = "main_multi_pks") public class MainMultiPks { .... @ManyToMany(targetEntity = DestTable4.class, cascade = { CascadeType.PERSIST }, fetch = FetchType.EAGER) @JoinTable(name = "middle_table4", joinColumns = { @JoinColumn(name = "main_id1", referencedColumnName = "id1"), @JoinColumn(name = "main_id2", referencedColumnName = "id2") }, inverseJoinColumns = { @JoinColumn(name = "dest4_id1", referencedColumnName = "id1"), @JoinColumn(name = "dest4_id2", referencedColumnName = "id2"), @JoinColumn(name = "dest4_id3", referencedColumnName = "id3") } ) private Set<DestTable4> destTable4s = new HashSet<>(); so these columns should be not null , the issue is the MiddleTable4 id column middle4_id}}does not correspond to any column of the join table, so when a{{MainMultiPks is saved the generated SQL insert statement for the Join table insert into middle_table4 (main_id2, main_id1, dest4_id1, dest4_id2, dest4_id3) values (?, ?, ?, ?, ?) contains all the columns specified by the @JoinTable but obviously not the MiddleTable4 id column and this causes the error ERROR: NULL not allowed for column "MIDDLE4_ID"; ( https://hibernate.atlassian.net/browse/HHH-15546#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15546#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:b857cee )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15525) Allow Global- and PersistentTemporaryTableStrategy to participate in hbm2ddl

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15525 ( https://hibernate.atlassian.net/browse/HHH-15525?atlOrigin=eyJpIjoiNTNjNG... ) Re: Allow Global- and PersistentTemporaryTableStrategy to participate in hbm2ddl ( https://hibernate.atlassian.net/browse/HHH-15525?atlOrigin=eyJpIjoiNTNjNG... ) Did you try with Hibernate 6.1.4.Final yet? With the fix of https://hibernate.atlassian.net/browse/HHH-15517 ( https://hibernate.atlassian.net/browse/HHH-15517 ) it shouldn’t require temporary tables anymore. This issue really is just about making the use of global and persistent temporary tables nicer. ( https://hibernate.atlassian.net/browse/HHH-15525#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15525#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:b857cee )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15525) Allow Global- and PersistentTemporaryTableStrategy to participate in hbm2ddl

by Kai Zander (JIRA)

Kai Zander ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15525 ( https://hibernate.atlassian.net/browse/HHH-15525?atlOrigin=eyJpIjoiNzljOT... ) Re: Allow Global- and PersistentTemporaryTableStrategy to participate in hbm2ddl ( https://hibernate.atlassian.net/browse/HHH-15525?atlOrigin=eyJpIjoiNzljOT... ) While adding such a configuration option would certainly be a start, allowing us to create the temporary tables out-of-band, I’m still not sure why the temporary tables are necessary in the first place. As described in https://hibernate.atlassian.net/browse/HHH-15517 ( https://hibernate.atlassian.net/browse/HHH-15517 ) , Hibernate 5 performed our insert into ... select without resorting to temporary tables… Are you looking into restoring the previous behavior as well, or should I open a separate issue for that? ( https://hibernate.atlassian.net/browse/HHH-15525#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15525#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:b857cee )

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15546) generate wrong ddl schema when use multi columns ManyToMany

by Andrea Boriero (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15546) generate wrong ddl schema when use multi columns ManyToMany

by Andrea Boriero (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15546) generate wrong ddl schema when use multi columns ManyToMany

by Andrea Boriero (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HBX-2410) Update version identifier to 5.6.13.Final

by BARRY LAFOND (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HBX-2405) Update version identifier to 5.6.13-SNAPSHOT

by BARRY LAFOND (JIRA)

2 years, 2 months

1
0
0 / 0

[JIRA] (HBX-2407) Update Hibernate ORM Dependency to Version 6.1.4.Final

by Koen Aers (JIRA)

2 years, 2 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues October 2022