July 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16885) Hibernate 6.1.6 - 6.2.7 changes outer to inner join when EntityGraph and @Id

by Konrad Wajs (JIRA)

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16885) Hibernate 6.1.6 - 6.2.7 changes outer to inner join when @EntityGraph and @Id

by Konrad Wajs (JIRA)

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16933) JSON issue on Oracle 23c

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWM3ODIwYzJm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16933?atlOrigin=eyJpIjoiMWM3OD... ) HHH-16933 ( https://hibernate.atlassian.net/browse/HHH-16933?atlOrigin=eyJpIjoiMWM3OD... ) JSON issue on Oracle 23c ( https://hibernate.atlassian.net/browse/HHH-16933?atlOrigin=eyJpIjoiMWM3OD... ) Issue Type: Bug Affects Versions: 6.2.6 Assignee: Unassigned Components: hibernate-core Created: 13/Jul/2023 03:52 AM Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Not sure if the problem is in Hibernate or Oracle 23c. Copying from a conversation with Loic: A minimal reproducer is: create table JsonHolder ( id number(19,0) not null, aggregate json, primary key (id), check (aggregate.theInt.number() is not null) ); producing ORA-00904: "AGGREGATE"."THEINT"."NUMBER": invalid identifier The fact is that you're using Oracle SQL dot notation that requires an alias (ideal usage being DML). So to make your code work, you'd need to use the JSON_VALUE() function instead such as: create table JsonHolder ( id number(19,0) not null, aggregate json, primary key (id), check (json_value(aggregate, '$.theInt.number()') is not null) ); ( https://hibernate.atlassian.net/browse/HHH-16933#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16933#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#100231- sha1:2991753 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16860) OneToMany with inherited classes on both sides

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16860 ( https://hibernate.atlassian.net/browse/HHH-16860?atlOrigin=eyJpIjoiMTIxYz... ) Re: OneToMany with inherited classes on both sides ( https://hibernate.atlassian.net/browse/HHH-16860?atlOrigin=eyJpIjoiMTIxYz... ) Even though this behavior (creation of extra fk columns on child tables) is consistent with previous version the intention is rectifying it to avoid useless columns and for general schema consistency. Will let you know as soon as we have a possible fix for this. ( https://hibernate.atlassian.net/browse/HHH-16860#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16860#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#100231- sha1:2991753 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-4902) Flatten all public POMs

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4902 ( https://hibernate.atlassian.net/browse/HSEARCH-4902?atlOrigin=eyJpIjoiMDY... ) Re: Flatten all public POMs ( https://hibernate.atlassian.net/browse/HSEARCH-4902?atlOrigin=eyJpIjoiMDY... ) > > > > I’d suspect that we really need just the dependencies, no need for > plugins, properties and so on… right > > Agreed. Maybe keep the metadata about SCM, authors, license etc. though. > > > > Then I’d expect that the poms of published artefacts would not contain any > references or properties (which is ok, since you cannot use those when > importing a pom) so yeah those poms you’ve mentioned should “go away”. > > \o/ ( https://hibernate.atlassian.net/browse/HSEARCH-4902#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4902#add-comment?atlOrigin... ) 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#100231- sha1:2991753 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-4902) Flatten all public POMs

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4902 ( https://hibernate.atlassian.net/browse/HSEARCH-4902?atlOrigin=eyJpIjoiMjg... ) Re: Flatten all public POMs ( https://hibernate.atlassian.net/browse/HSEARCH-4902?atlOrigin=eyJpIjoiMjg... ) +1 it’s definitely worth giving it a try 🙂. We can use pomElements to do some fine-tuning of what shows up in the poms. I’d suspect that we really need just the dependencies, no need for plugins, properties and so on… right? Then I’d expect that the poms of published artefacts would not contain any references or properties (which is ok, since you cannot use those when importing a pom) so yeah those poms you’ve mentioned should “go away”. ( https://hibernate.atlassian.net/browse/HSEARCH-4902#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4902#add-comment?atlOrigin... ) 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#100231- sha1:2991753 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HSEARCH-4902) Flatten all public POMs

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiYjU4YzJk... ) / Improvement ( https://hibernate.atlassian.net/browse/HSEARCH-4902?atlOrigin=eyJpIjoiYjU... ) HSEARCH-4902 ( https://hibernate.atlassian.net/browse/HSEARCH-4902?atlOrigin=eyJpIjoiYjU... ) Flatten all public POMs ( https://hibernate.atlassian.net/browse/HSEARCH-4902?atlOrigin=eyJpIjoiYjU... ) Issue Type: Improvement Assignee: Unassigned Components: build Created: 13/Jul/2023 00:51 AM Fix Versions: 7.0-backlog Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) The flatten-maven-plugin looks interesting. We used it in https://github.com/hibernate/hibernate-search/pull/3588 and it effectively removes any references to BOMs/POMs from the flattened POM. Maybe we could apply it to all public POMs? It would remove the need to publish: * The root POM (maybe?) * The public parent POM * The build BOM WDYT Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) ? ( https://hibernate.atlassian.net/browse/HSEARCH-4902#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4902#add-comment?atlOrigin... ) 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#100231- sha1:2991753 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16932) envers audit-trail not written for jsonb column

by Christian Thiel (JIRA)

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16932) envers audit-trail not written for jsonb column

by Christian Thiel (JIRA)

Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZGRjZDJhODk4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16932?atlOrigin=eyJpIjoiZGRjZD... ) HHH-16932 ( https://hibernate.atlassian.net/browse/HHH-16932?atlOrigin=eyJpIjoiZGRjZD... ) envers audit-trail not written for jsonb column ( https://hibernate.atlassian.net/browse/HHH-16932?atlOrigin=eyJpIjoiZGRjZD... ) Change By: Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) I’m using a Embeddable Object to store i18n in a JSONB-Column like this: {noformat}@Table(schema = "mdata", name = "PART") @Audited(withModifiedFlag = true) public class Part { @JdbcTypeCode(SqlTypes.JSON) Translation description; ... {noformat} with {noformat}@Embeddable public class Translation { String de; String en; } {noformat} All changes to the Part entity trigger an entry in the envers-table PART_AUD, but * changes to the JSONB description-column are not marked as modified and the * jsonb-values in the PART_AUD are always NULL. I have added a Quarkus Sample-Project with a test-case. My findings so far: I use Flyway to create the tables → the _AUD table has a jsonb-column, like the original table. Without flyway, if i configure the project to let hibernate create the tables, the _AUD table has separate STRING columns for each field in the embeddable! This seems odd… In the insert-statement that envers generates the jsonb-column is missing at all (see console-log of my test): {code:sql} insert into base.PART_AUD (REVTYPE,description_MOD,name,name_MOD,stamp,stamp_MOD,REV,id) values (?,?,?,?,?,?,?,?){code} may this is releated to [https://hibernate.atlassian.net/browse/HHH-16910|https://hibernate.atlass...] ( https://hibernate.atlassian.net/browse/HHH-16932#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16932#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#100231- sha1:2991753 )

2 years, 9 months

1
0
0 / 0

[JIRA] (HHH-16932) envers audit-trail not written for jsonb column

by Christian Thiel (JIRA)

Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDY0YjdhNzFh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16932?atlOrigin=eyJpIjoiZDY0Yj... ) HHH-16932 ( https://hibernate.atlassian.net/browse/HHH-16932?atlOrigin=eyJpIjoiZDY0Yj... ) envers audit-trail not written for jsonb column ( https://hibernate.atlassian.net/browse/HHH-16932?atlOrigin=eyJpIjoiZDY0Yj... ) Issue Type: Bug Affects Versions: 6.2.5 Assignee: Chris Cranford ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Attachments: code-with-quarkus.zip Components: hibernate-envers Created: 12/Jul/2023 23:57 PM Environment: Quarkus 3.2.0 hibernate-core 6.2.5.final hiberanate-envers-6.2.5.final Priority: Major Reporter: Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) I’m using a Embeddable Object to store i18n in a JSONB-Column like this: @Table(schema = "mdata", name = "PART") @Audited(withModifiedFlag = true) public class Part { @JdbcTypeCode(SqlTypes.JSON) Translation description; ... with @Embeddable public class Translation { String de; String en; } All changes to the Part entity trigger an entry in the envers-table PART_AUD, but * changes to the JSONB description-column are not marked as modified and the * jsonb-values in the PART_AUD are always NULL. I have added a Quarkus Sample-Project with a test-case. My findings so far: I use Flyway to create the tables → the _AUD table has a jsonb-column, like the original table. Without flyway, if i configure the project to let hibernate create the tables, the _AUD table has separate STRING columns for each field in the embeddable! This seems odd… In the insert-statement that envers generates the jsonb-column is missing at all (see console-log of my test): insert into base.PART_AUD (REVTYPE,description_MOD, name ,name_MOD,stamp,stamp_MOD,REV,id) values (?,?,?,?,?,?,?,?) ( https://hibernate.atlassian.net/browse/HHH-16932#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16932#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#100231- sha1:2991753 )

2 years, 9 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues July 2023