April 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16442) trunc() function with offset datetimes on Oracle

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16442 ( https://hibernate.atlassian.net/browse/HHH-16442?atlOrigin=eyJpIjoiM2I5MD... ) Re: trunc() function with offset datetimes on Oracle ( https://hibernate.atlassian.net/browse/HHH-16442?atlOrigin=eyJpIjoiM2I5MD... ) This looks like a limitation of Oracle’s native TRUNC(date) function, the relative docs ( https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/TRUNC... ) state: > > > > The value returned is always of data type DATE , even if you specify a > different datetime data type for date > > causing loss of the timezone information. I’m not sure but how we might be able to get around this, maybe always emulating and using to_timestamp_tz instead of to_date (which has the same problem)? ( https://hibernate.atlassian.net/browse/HHH-16442#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16442#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:916089c )

3 years

1
0
0 / 0

[JIRA] (HSEARCH-4149) Support more missing() sort options

by Automation for Jira (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16425) Can not perform some aggregates over subquery

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16425 ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiODU0NT... ) Re: Can not perform some aggregates over subquery ( https://hibernate.atlassian.net/browse/HHH-16425?atlOrigin=eyJpIjoiODU0NT... ) Test case is in PR 6375 ( https://github.com/hibernate/hibernate-orm/pull/6375 ) ( https://hibernate.atlassian.net/browse/HHH-16425#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16425#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:916089c )

3 years

1
0
0 / 0

[JIRA] (HHH-16429) WF SessionFactoryTestCase test fails

by Andrea Boriero (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16438) Left outer joins do not work with polymorphic entities due to use of discriminator in the main query condition

by Jan Schatteman (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16447) Lazy load of collection fails after EntityManager.refresh

by Rob Scala (JIRA)

Rob Scala ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzViNzliNzBm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16447?atlOrigin=eyJpIjoiMzViNz... ) HHH-16447 ( https://hibernate.atlassian.net/browse/HHH-16447?atlOrigin=eyJpIjoiMzViNz... ) Lazy load of collection fails after EntityManager.refresh ( https://hibernate.atlassian.net/browse/HHH-16447?atlOrigin=eyJpIjoiMzViNz... ) Change By: Rob Scala ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I have a schema that includes two polymorphic entity classes using the join strategy. When I call EntityManager.refresh on one of the subclasses a lazy collection in its superclass fails to work. Specifically, when I try to get a record from that collection, I get this exception: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hibernate.bugs.Company.people: could not initialize proxy - no Session The failure happens whether or not I include CascadeType.REFRESH on the collection. Here is a picture of the schema: !Hibernate_refresh_lazy.png|width=721,height=331! Here is the essential source code: {noformat}@Entity @Inheritance(strategy= InheritanceType.JOINED) @DiscriminatorColumn(name="CompanyType", discriminatorType= DiscriminatorType.INTEGER) public abstract class ComputerSystem { @Id @GeneratedValue(strategy= GenerationType.IDENTITY) private long id; @ManyToOne @JoinColumn(name = "OWNER_ID", foreignKey = @ForeignKey()) protected Company owner = null; public void setOwner(Company owner) { this.owner = owner; } } @Entity @DiscriminatorValue("2") public class ManufacturerComputerSystem extends ComputerSystem { } @Entity @Inheritance(strategy= InheritanceType.JOINED) @DiscriminatorColumn(name="CompanyType", discriminatorType= DiscriminatorType.INTEGER) public abstract class Company { @Id @GeneratedValue(strategy=GenerationType.IDENTITY) protected long id; @OneToMany(mappedBy="company", orphanRemoval=true, cascade=CascadeType.ALL, fetch=FetchType.LAZY) private List<Person> people = new ArrayList<>(); public List<Person> getPeople() { return people; } public void addPerson(Person person) { people.add(person); person.setCompany(this); } } @Entity @DiscriminatorValue("1") public class ManufacturerCompany extends Company { @OneToOne(orphanRemoval=true, cascade=CascadeType.ALL, fetch=FetchType.LAZY) @JoinColumn(name = "COMPUTERSYSTEM_ID", foreignKey = @ForeignKey()) private ManufacturerComputerSystem computerSystem; public void setComputerSystem(ManufacturerComputerSystem computerSystem) { this.computerSystem = computerSystem; computerSystem.setOwner(this); } } @Entity public class Person { @Id @GeneratedValue(strategy= GenerationType.IDENTITY) private long id; private String firstName; @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name = "COMPANY_ID", foreignKey = @ForeignKey()) private Company company; public void setFirstName(String firstName) { this.firstName = firstName; } public String getFirstName() { return firstName; } public void setCompany(Company company) { this.company = company; } } public class JPAUnitTestCase { @Before public void init() { // Details omitted for brevity } @Test public void refresh_test() { EntityManager entityManager = entityManagerFactory.createEntityManager(); ManufacturerCompany manufacturerCompany = entityManager.find(ManufacturerCompany.class, 1L); entityManager.refresh(manufacturerCompany); List<Person> people = manufacturerCompany.getPeople(); Person person1 = people.get(0); // <-- This is where it fails. String newFirstName = "name1".equals(person1.getFirstName()) ? "name2" : "name1"; entityManager.getTransaction().begin(); person1.setFirstName(newFirstName); entityManager.getTransaction().commit(); assertEquals("Get latest name", newFirstName, person1.getFirstName()); } }{noformat} Here is a project that reproduces the problem (it is also attached) : [https://github.com/robscala/Hibernate_lazy_load_collection_fails|https://...] ( https://hibernate.atlassian.net/browse/HHH-16447#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16447#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:8f8083a )

3 years

1
0
0 / 0

[JIRA] (HHH-16447) Lazy load of collection fails after EntityManager.refresh

by Rob Scala (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16447) Lazy load of collection fails after EntityManager.refresh

by Rob Scala (JIRA)

Rob Scala ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTM0YzBmN2Qw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16447?atlOrigin=eyJpIjoiZTM0Yz... ) HHH-16447 ( https://hibernate.atlassian.net/browse/HHH-16447?atlOrigin=eyJpIjoiZTM0Yz... ) Lazy load of collection fails after EntityManager.refresh ( https://hibernate.atlassian.net/browse/HHH-16447?atlOrigin=eyJpIjoiZTM0Yz... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Attachments: Hibernate_refresh_lazy.png Components: hibernate-core Created: 06/Apr/2023 13:09 PM Environment: H2 database 2.1.214 Hibernate 6.2.0.CR4 Priority: Major Reporter: Rob Scala ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I have a schema that includes two polymorphic entity classes using the join strategy. When I call EntityManager.refresh on one of the subclasses a lazy collection in its superclass fails to work. Specifically, when I try to get a record from that collection, I get this exception: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hibernate.bugs.Company.people: could not initialize proxy - no Session The failure happens whether or not I include CascadeType.REFRESH on the collection. Here is a picture of the schema: Here is the essential source code: @Entity @Inheritance(strategy= InheritanceType.JOINED) @DiscriminatorColumn(name="CompanyType", discriminatorType= DiscriminatorType.INTEGER) public abstract class ComputerSystem { @Id @GeneratedValue(strategy= GenerationType.IDENTITY) private long id; @ManyToOne @JoinColumn(name = "OWNER_ID", foreignKey = @ForeignKey()) protected Company owner = null; public void setOwner(Company owner) { this.owner = owner; } } @Entity @DiscriminatorValue("2") public class ManufacturerComputerSystem extends ComputerSystem { } @Entity @Inheritance(strategy= InheritanceType.JOINED) @DiscriminatorColumn(name="CompanyType", discriminatorType= DiscriminatorType.INTEGER) public abstract class Company { @Id @GeneratedValue(strategy=GenerationType.IDENTITY) protected long id; @OneToMany(mappedBy="company", orphanRemoval=true, cascade=CascadeType.ALL, fetch=FetchType.LAZY) private List<Person> people = new ArrayList<>(); public List<Person> getPeople() { return people; } public void addPerson(Person person) { people.add(person); person.setCompany(this); } } @Entity @DiscriminatorValue("1") public class ManufacturerCompany extends Company { @OneToOne(orphanRemoval=true, cascade=CascadeType.ALL, fetch=FetchType.LAZY) @JoinColumn(name = "COMPUTERSYSTEM_ID", foreignKey = @ForeignKey()) private ManufacturerComputerSystem computerSystem; public void setComputerSystem(ManufacturerComputerSystem computerSystem) { this.computerSystem = computerSystem; computerSystem.setOwner(this); } } @Entity public class Person { @Id @GeneratedValue(strategy= GenerationType.IDENTITY) private long id; private String firstName; @ManyToOne(fetch=FetchType.LAZY) @JoinColumn(name = "COMPANY_ID", foreignKey = @ForeignKey()) private Company company; public void setFirstName(String firstName) { this.firstName = firstName; } public String getFirstName() { return firstName; } public void setCompany(Company company) { this.company = company; } } public class JPAUnitTestCase { @Before public void init() { // Details omitted for brevity } @Test public void refresh_test() { EntityManager entityManager = entityManagerFactory.createEntityManager(); ManufacturerCompany manufacturerCompany = entityManager.find(ManufacturerCompany.class, 1L); entityManager.refresh(manufacturerCompany); List<Person> people = manufacturerCompany.getPeople(); Person person1 = people.get(0); // <-- This is where it fails. String newFirstName = "name1".equals(person1.getFirstName()) ? "name2" : "name1"; entityManager.getTransaction().begin(); person1.setFirstName(newFirstName); entityManager.getTransaction().commit(); assertEquals("Get latest name", newFirstName, person1.getFirstName()); } } Here is a project that reproduces the problem: https://github.com/robscala/Hibernate_lazy_load_collection_fails ( https://hibernate.atlassian.net/browse/HHH-16447#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16447#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:8f8083a )

3 years

1
0
0 / 0

[JIRA] (HSEARCH-4811) Automated code formatting

by Automation for Jira (JIRA)

3 years

1
0
0 / 0

[JIRA] (HHH-16444) When logging the selected dialect, print the version too

by Davide D'Alto (JIRA)

3 years

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