September 2022 - hibernate-issues

[JIRA] (HHH-15159) Orphan removal of an entity with an @ElementCollection causes a ConstraintViolationException

by Andrea Boriero (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-15478) EntityListeners on transitive superclasses

by Jin Kwon (JIRA)

Jin Kwon ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15478 ( https://hibernate.atlassian.net/browse/HHH-15478?atlOrigin=eyJpIjoiYzE1MG... ) Re: EntityListeners on transitive superclasses ( https://hibernate.atlassian.net/browse/HHH-15478?atlOrigin=eyJpIjoiYzE1MG... ) Forgive me if this is a Spring issue. ( https://hibernate.atlassian.net/browse/HHH-15478#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15478#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#100206- sha1:3ac329d )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-15478) EntityListeners on transitive superclasses

by Jin Kwon (JIRA)

Jin Kwon ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOGNmODk4ODY5... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-15478?atlOrigin=eyJpIjoiOGNmOD... ) HHH-15478 ( https://hibernate.atlassian.net/browse/HHH-15478?atlOrigin=eyJpIjoiOGNmOD... ) EntityListeners on transitive superclasses ( https://hibernate.atlassian.net/browse/HHH-15478?atlOrigin=eyJpIjoiOGNmOD... ) Issue Type: Improvement Affects Versions: 5.6.10 Assignee: Unassigned Components: hibernate-entitymanager Created: 03/Sep/2022 02:20 AM Environment: Apache Maven 3.8.5 (3599d3414f046de2324203b78ddcf9b5e4388aa0) Maven home: /Users/onacit/.m2/wrapper/dists/apache-maven-3.8.5-bin/5i5jha092a3i37g0paqnfr15e0/apache-maven-3.8.5 Java version: 18.0.2.1, vendor: Eclipse Adoptium, runtime: /Library/Java/JavaVirtualMachines/temurin-18.jdk/Contents/Home Default locale: en_KR, platform encoding: UTF-8 OS name: "mac os x", version: "12.5", arch: "aarch64", family: "mac" Priority: Major Reporter: Jin Kwon ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I have three layers. @EntityListeners({AuditingEntityListener.class}) @MappedSuperclass abstract class L1 { } //(a)EntityListeners({AuditingEntityListener.class}) // required??? @MappedSuperclass abstract class L2 extends L1 { @CreatedDate private LocalDateTime some; } @Entity class L3 extends L2 { } The AuditingEntityListener doesn’t work without @EntityListeners on the second level class or 3rd level class. Is this normal? ( https://hibernate.atlassian.net/browse/HHH-15478#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15478#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#100206- sha1:3ac329d )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-15476) Batch save for Postgresql sequence does't work very well.

by yo (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-15153) @OneToOne does not support @EmbeddedId

by David Moten (JIRA)

David Moten ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15153 ( https://hibernate.atlassian.net/browse/HHH-15153?atlOrigin=eyJpIjoiMzgxNz... ) Re: @OneToOne does not support @EmbeddedId ( https://hibernate.atlassian.net/browse/HHH-15153?atlOrigin=eyJpIjoiMzgxNz... ) Can this be backported to 5.6.x please? The fix for 6.x is useless for the many environments still on Java 8. ( https://hibernate.atlassian.net/browse/HHH-15153#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15153#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#100206- sha1:3ac329d )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-15477) [Hibernate 6] Criteria EXISTS Subquery Causes "Error interpreting query [SqmRoot not yet resolved to TableGroup]"

by Kai Zander (JIRA)

Kai Zander ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWMzYmRlMzEx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15477?atlOrigin=eyJpIjoiMWMzYm... ) HHH-15477 ( https://hibernate.atlassian.net/browse/HHH-15477?atlOrigin=eyJpIjoiMWMzYm... ) [Hibernate 6] Criteria EXISTS Subquery Causes "Error interpreting query [SqmRoot not yet resolved to TableGroup]" ( https://hibernate.atlassian.net/browse/HHH-15477?atlOrigin=eyJpIjoiMWMzYm... ) Issue Type: Bug Affects Versions: 6.1.2 Assignee: Unassigned Attachments: example.zip Components: query-criteria Created: 02/Sep/2022 14:04 PM Environment: Hibernate 6.1.2 Java 17 Windows 11 H2 Priority: Major Reporter: Kai Zander ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Simple criteriaBuilder.exists(subQuery) conditions don’t work anymore under 6.1.2, while they worked under 5.6.10, the following exception is thrown: org.hibernate.query.sqm.InterpretationException: Error interpreting query [SqmRoot not yet resolved to TableGroup] ; this may indicate a semantic (user query) problem or a bug in the parser [SqmRoot not yet resolved to TableGroup]. I attached a simple example project, extract it and run mvnw test. It is a minimal Spring Boot project that recreates the data model from Vlad’s blog post https://vladmihalcea.com/exists-subqueries-jpa-hibernate/ ( https://vladmihalcea.com/exists-subqueries-jpa-hibernate/ ) and issues his example queries in both JPQL and Criteria variants. The JPQL variant succeeds, the Criteria variant throws the aforementioned exception. I encountered this issue while trying to migrate our applications to Hibernate 6, where we make tons of criteria subqueries. ( https://hibernate.atlassian.net/browse/HHH-15477#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15477#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#100206- sha1:3ac329d )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-15476) Batch save for Postgresql sequence does't work very well.

by yo (JIRA)

yo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63123de... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzUxYjM5MzU2... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-15476?atlOrigin=eyJpIjoiMzUxYj... ) HHH-15476 ( https://hibernate.atlassian.net/browse/HHH-15476?atlOrigin=eyJpIjoiMzUxYj... ) Batch save for Postgresql sequence does't work very well. ( https://hibernate.atlassian.net/browse/HHH-15476?atlOrigin=eyJpIjoiMzUxYj... ) Change By: yo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63123de... ) *I want to Batch save data to Postgresql* see demo in [*github* |https://github.com/coding2world/sb-jpa-batch-insert-demo] first, I write java code like this. below is pojo’s definition. {code:java}@Data @Entity @Table(name = "city") @AllArgsConstructor public class City { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "city_id_gen") @SequenceGenerator(name = "city_id_gen", sequenceName = "public.city_id_seq", allocationSize = 5) private Long id; private String name; private int population; public City(String name, int population) { this.name = name; this.population = population; } public City() { } }{code} Repository class. {code:java}public interface CityRepo extends JpaRepository<City, Long> {}{code} invoke the Repository class. {code:java}cityRepo.saveAll(range(1, 10) .mapToObj(i -> new City("beautiful", (int)System.currentTimeMillis()/1000)) .collect(toList()));{code} second is my sql. {code:sql}CREATE TABLE city(id serial PRIMARY KEY, name VARCHAR(255), population integer);{code} *My question below:* When I call {{SELECT nextval('city_id_seq')}} return 100. *It means 99 and 98 have been used.* Suppose the value of the parameter named {{allocationSize}} of the annotation named {{SequenceGenerator}} is 3 , So hibernate should generate 3 id sequences once call {{SELECT nextval('city_id_seq')}}. According to the below code {code:java}org.hibernate.id.enhanced.PooledOptimizer#generate{code} {{SELECT nextval('city_id_seq')}} return 100 , the 3 sequence is sequences are 98, 99, 100. But *99 and 98 have been used.* I think *Hibernate should call* {{SELECT setval ('city_id_seq', nextval ('city_id_seq')+3)}} is returns 102. the 3 sequence is 100, 101, 102. *I’m not sure if Hibernate has some function to satisfy my demand.* ( https://hibernate.atlassian.net/browse/HHH-15476#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15476#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#100206- sha1:3ac329d )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-15476) Batch save for Postgresql sequence does't work very well.

by yo (JIRA)

yo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63123de... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTJhZTc5MWM2... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-15476?atlOrigin=eyJpIjoiMTJhZT... ) HHH-15476 ( https://hibernate.atlassian.net/browse/HHH-15476?atlOrigin=eyJpIjoiMTJhZT... ) Batch save for Postgresql sequence does't work very well. ( https://hibernate.atlassian.net/browse/HHH-15476?atlOrigin=eyJpIjoiMTJhZT... ) Change By: yo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63123de... ) *I want to Batch save data to Postgresql* see demo in [*github* |https://github.com/coding2world/sb-jpa-batch-insert-demo] first, I write java code like this. below is pojo’s definition. {code:java}@Data @Entity @Table(name = "city") @AllArgsConstructor public class City { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "city_id_gen") @SequenceGenerator(name = "city_id_gen", sequenceName = "public.city_id_seq", allocationSize = 5) private Long id; private String name; private int population; public City(String name, int population) { this.name = name; this.population = population; } public City() { } }{code} Repository class. {code:java}public interface CityRepo extends JpaRepository<City, Long> {}{code} invoke the Repository class. {code:java}cityRepo.saveAll(range(1, 10) .mapToObj(i -> new City("beautiful", (int)System.currentTimeMillis()/1000)) .collect(toList()));{code} second is my sql. {code:sql}CREATE TABLE city(id serial PRIMARY KEY, name VARCHAR(255), population integer);{code} *My question below:* When I call {{SELECT nextval('city_id_seq')}} return 100. *It means 99 and 98 have been used.* Suppose the value of the parameter named {{allocationSize}} of the annotation named {{SequenceGenerator}} is 3 , So hibernate should generate 3 id once call {{SELECT nextval('city_id_seq')}}. According to the below code {code:java}org.hibernate.id.enhanced.PooledOptimizer#generate{code} {{SELECT nextval('city_id_seq')}} return 100 , the 3 sequence is 98, 99, 100. But *99 and 98 have been used.* I think *Hibernate should call* {{SELECT setval ('city_id_seq', nextval ('city_id_seq')+3)}} is returns 102. the 3 sequence is 100, 101, 102. ( https://hibernate.atlassian.net/browse/HHH-15476#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15476#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#100206- sha1:3ac329d )

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-15476) Batch save for Postgresql sequence does't work very well.

by yo (JIRA)

1 year, 9 months

1
0
0 / 0

[JIRA] (HHH-15476) Batch save for Postgresql sequence.

by yo (JIRA)

1 year, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues September 2022