April 2023 - hibernate-issues - Jboss List Archives

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGI1MDczMGIy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16479?atlOrigin=eyJpIjoiNGI1MD... ) HHH-16479 ( https://hibernate.atlassian.net/browse/HHH-16479?atlOrigin=eyJpIjoiNGI1MD... ) Generic enum in @MappedSuperclass fails with java.lang.IllegalArgumentException: Named type [...] did not implement BasicType nor UserType ( https://hibernate.atlassian.net/browse/HHH-16479?atlOrigin=eyJpIjoiNGI1MD... ) Change By: Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) given {code:java}public interface EnumBase { String name(); } public enum TestEnum implements EnumBase { FOO, BAR } @MappedSuperclass public static abstract class GenericBaseEntity<T extends EnumBase> { @Enumerated(EnumType.STRING) protected T state; public T getState() { return state; } public void setState(T state) { this.state = state; } } @Entity public static class TestEntity extends GenericBaseEntity<TestEnum> { @Id private long id; protected TestEntity() { } public TestEntity(long id) { this.id = id; } } {code} Hibernate throws {noformat}java.lang.IllegalArgumentException: Named type [interface org.hibernate.orm.test.annotations.enumerated.EnumeratedAndGenericsTest$EnumBase] did not implement BasicType nor UserType{noformat} see also [https://github.com/quarkusio/quarkus/issues/32664|https://github.com/quar...] ( https://hibernate.atlassian.net/browse/HHH-16479#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16479#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#100221- sha1:d40a829 )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16479) Generic enum in @MappedSuperclass fails with java.lang.IllegalArgumentException: Named type [...] did not implement BasicType nor UserType

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjAyZmMzODQ4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16479?atlOrigin=eyJpIjoiZjAyZm... ) HHH-16479 ( https://hibernate.atlassian.net/browse/HHH-16479?atlOrigin=eyJpIjoiZjAyZm... ) Generic enum in @MappedSuperclass fails with java.lang.IllegalArgumentException: Named type [...] did not implement BasicType nor UserType ( https://hibernate.atlassian.net/browse/HHH-16479?atlOrigin=eyJpIjoiZjAyZm... ) Issue Type: Bug Affects Versions: 6.2.1 Assignee: Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: hibernate-core Created: 17/Apr/2023 03:39 AM Fix Versions: 6.2.2 Priority: Major Reporter: Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) given public interface EnumBase { String name(); } public enum TestEnum implements EnumBase { FOO, BAR } @MappedSuperclass public static abstract class GenericBaseEntity<T extends EnumBase> { @Enumerated(EnumType.STRING) protected T state; public T getState() { return state; } public void setState(T state) { this.state = state; } } @Entity public static class TestEntity extends GenericBaseEntity<TestEnum> { @Id private long id; protected TestEntity() { } public TestEntity( long id) { this.id = id; } } Hibernate throws java.lang.IllegalArgumentException: Named type [interface org.hibernate.orm.test.annotations.enumerated.EnumeratedAndGenericsTest$EnumBase] did not implement BasicType nor UserType ( https://hibernate.atlassian.net/browse/HHH-16479#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16479#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#100221- sha1:d40a829 )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16478) SubQuery don't use table alias in Hibernate 6.1.7

by Burner (JIRA)

Burner ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6423fd4... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTJiYjk5MDQx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16478?atlOrigin=eyJpIjoiMTJiYj... ) HHH-16478 ( https://hibernate.atlassian.net/browse/HHH-16478?atlOrigin=eyJpIjoiMTJiYj... ) SubQuery don't use table alias in Hibernate 6.1.7 ( https://hibernate.atlassian.net/browse/HHH-16478?atlOrigin=eyJpIjoiMTJiYj... ) Change By: Burner ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6423fd4... ) I want to implement a soft delete for my entities. So I create this annoations: {noformat}@SQLDelete(sql = "UPDATE ExternalReference SET deleted=true, deletedAt=now() WHERE id=?") @Where(clause = "deleted = false") public class ExternalReference { ... }{noformat} Repository: {noformat}public interface ExternalReferenceRepo extends JpaRepository<ExternalReference, Long> { @Modifying @Query("DELETE FROM #{#entityName} e WHERE e. id externalSystem = : iId iExternalSystem AND e.externalClass = :iExternalClass AND e.externalId = :iExternalId ") void delete(@Param(" iId iExternalSystem ") Long id String externalSystem, @Param("iExternalClass" ) String externalClass, @Param("iExternalId") String externalId) ; }{noformat} When I use the method delete. Hibernate create this SQL: {code:sql}DELETE FROM external_reference_our_object WHERE external_reference_our_object.external_reference_id in (SELECT e1_0.id FROM external_reference e1_0 WHERE e1_0.external_system=? AND e1_0.external_class=? AND e1_0.external_id=? AND (external_reference.deleted = 0))];{code} And I get this Error Message: {panel:bgColor=#deebff} SQL Error: 1054, SQLState: 42S22 (conn=43) Unknown column 'external_reference.deleted' in 'where clause' {panel} Because {{external_reference.deleted}} should be {{e1_0.deleted}} ( https://hibernate.atlassian.net/browse/HHH-16478#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16478#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#100221- sha1:d40a829 )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16478) SubQuery don't use table alias in Hibernate 6.1.7

by Burner (JIRA)

Burner ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6423fd4... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOWEwMjEwNTcz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16478?atlOrigin=eyJpIjoiOWEwMj... ) HHH-16478 ( https://hibernate.atlassian.net/browse/HHH-16478?atlOrigin=eyJpIjoiOWEwMj... ) SubQuery don't use table alias in Hibernate 6.1.7 ( https://hibernate.atlassian.net/browse/HHH-16478?atlOrigin=eyJpIjoiOWEwMj... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Created: 17/Apr/2023 01:50 AM Environment: Spring Boot 3.0.4 Priority: Major Reporter: Burner ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6423fd4... ) I want to implement a soft delete for my entities. So I create this annoations: @SQLDelete(sql = "UPDATE ExternalReference SET deleted=true, deletedAt=now() WHERE id=?") @Where(clause = "deleted = false") public class ExternalReference { ... } Repository: public interface ExternalReferenceRepo extends JpaRepository<ExternalReference, Long> { @Modifying @Query("DELETE FROM #{#entityName} e WHERE e.id = :iId") void delete(@Param("iId") Long id); } When I use the method delete. Hibernate create this SQL: DELETE FROM external_reference_our_object WHERE external_reference_our_object.external_reference_id in ( SELECT e1_0.id FROM external_reference e1_0 WHERE e1_0.external_system=? AND e1_0.external_class=? AND e1_0.external_id=? AND (external_reference.deleted = 0))]; And I get this Error Message: SQL Error: 1054, SQLState: 42S22 (conn=43) Unknown column 'external_reference.deleted' in 'where clause' Because external_reference.deleted should be e1_0.deleted ( https://hibernate.atlassian.net/browse/HHH-16478#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16478#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#100221- sha1:d40a829 )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16419) Regression on calling postgresql functions via CriteriaBuilder

by 周雁鸣 (JIRA)

周雁鸣 ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16419 ( https://hibernate.atlassian.net/browse/HHH-16419?atlOrigin=eyJpIjoiMGZlNG... ) Re: Regression on calling postgresql functions via CriteriaBuilder ( https://hibernate.atlassian.net/browse/HHH-16419?atlOrigin=eyJpIjoiMGZlNG... ) You can extend PostgreSQLDialect and register PostgreSQLNativeAnyFunction, see https://github.com/hibernate/hibernate-orm/pull/6346/files ( https://hibernate.atlassian.net/browse/HHH-16419#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16419#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#100221- sha1:8830b7c )

2 years, 12 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 April 2023