August 2020 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Nathan Xu (JIRA)

Nathan Xu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14152 ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiYzJmYm... ) Re: Query fails after upgrading to 5.4.20.Final ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiYzJmYm... ) maybe you can compare the two versions of generated query (one for 5.4.19 and one for 5.4.20) to narrow down the root cause. Another way is to inspect the db content before issuing the query. There must be some difference for if both comparisons find no difference, then in theory we should get the same query results! ( https://hibernate.atlassian.net/browse/HHH-14152#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14152#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#100144- sha1:57e1ab7 )

4 years, 1 month

1
0
0 / 0

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Scott Roehrig (JIRA)

Scott Roehrig ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14152 ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiYjgyNj... ) Re: Query fails after upgrading to 5.4.20.Final ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiYjgyNj... ) The generated query appears as follows: SQL - select distinct issuerimpl0_.ISSUER as issuer2_14_, issuerimpl0_.IDENTIFIER as identifi3_14_, issuerimpl0_.CREATED as created4_14_, issuerimpl0_.CREATOR_ISSUER as creator13_14_, issuerimpl0_.CREATOR_IDENTIFIER as creator14_14_, issuerimpl0_.ENTITY as entity1_14_, issuerimpl0_.EXPIRATION as expirati5_14_, issuerimpl0_.EXTERNAL_IDENTIFIER as external6_14_, issuerimpl0_.MIMETYPE as mimetype7_14_, issuerimpl0_.MODIFIED as modified8_14_, issuerimpl0_.MODIFIER_ISSUER as modifie15_14_, issuerimpl0_.MODIFIER_IDENTIFIER as modifie16_14_, issuerimpl0_.NAME as name9_14_, issuerimpl0_.URI as uri10_14_, issuerimpl0_.VERSION as version11_14_, issuerimpl0_1_.NAME as name1_10_, issuerimpl0_1_.PARENT_ISSUER as parent_i2_10_, issuerimpl0_1_.PARENT_IDENTIFIER as parent_i3_10_ from RESOURCES issuerimpl0_ inner join ISSUERS issuerimpl0_1_ on issuerimpl0_.ISSUER=issuerimpl0_1_.ISSUER and issuerimpl0_.IDENTIFIER=issuerimpl0_1_.IDENTIFIER where issuerimpl0_.ENTITY='IssuerImpl' and issuerimpl0_.ISSUER=? and issuerimpl0_.IDENTIFIER=? which appears correct. ( https://hibernate.atlassian.net/browse/HHH-14152#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14152#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#100144- sha1:57e1ab7 )

4 years, 1 month

1
0
0 / 0

[JIRA] (HHH-14152) Query fails after upgrading to 5.4.20.Final

by Scott Roehrig (JIRA)

4 years, 1 month

1
0
0 / 0

[JIRA] (HHH-14152) Simple Query fails after upgrading to 5.4.20.Final

by Scott Roehrig (JIRA)

4 years, 1 month

1
0
0 / 0

[JIRA] (HHH-14152) Simple Query fails after upgrading to 5.4.20.Final

by Scott Roehrig (JIRA)

Scott Roehrig ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZWVmOThlZjQ1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiZWVmOT... ) HHH-14152 ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiZWVmOT... ) Simple Query fails after upgrading to 5.4.20.Final ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiZWVmOT... ) Issue Type: Bug Affects Versions: 5.4.20 Assignee: Unassigned Components: hibernate-core Created: 12/Aug/2020 15:41 PM Environment: Windows platform Priority: Major Reporter: Scott Roehrig ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I have a simple query that is executed to retrieve a row from the database. This query worked fine when run using HSQLDB in 5.4.19. The persistence.xml uses a create/load sql scripts. After updating to 5.4.20, the query fails with No Entity Found now. The entity is created during the load.sql execution. This only appears to happen when running with an in memory HSQLDB also for some reason (which are what the automated unit tests use of course) I am uncertain what aspect of changes to 5.4.20 affected this. The entity hierachy is a JOIN TABLE with PARENT/CHILD relationship. I will attach the class files below and the sql files. I am unable to attach the entire source tree. But the query is a relatively simple query that selects an entity (the child via the JOIN relationship) based upon one field of a composiite primary key. I will update as I can investigate this a bit more. I have tried to remove ALL comments from the source sql files if perhaps the comment change has impacted this, but that appears to not resolve it. I have tried to set parameter padding back to true to see if that change affected it to no avail. The failing named query is as follows : @NamedQuery(name = IssuerImpl.SELECT_BY_ISSUER, query = "SELECT issuer FROM " + IssuerImpl.ENTITY_NAME + " issuer WHERE issuer.identifier.issuer= :issuer") Here the "issuer" entity is a subtype of the main "resource" entity @Entity(name = ResourceImpl.ENTITY_NAME) @Table(name = ResourceImpl.TABLE_NAME) @Inheritance(strategy = InheritanceType.SINGLE_TABLE) @DiscriminatorColumn(name = ResourceImpl.ENTITY_COLUMN) defines the parent and a secondary JOIN table is used on the child @Entity(name = IssuerImpl.ENTITY_NAME) @SecondaryTable(name = IssuerImpl.TABLE_NAME, pkJoinColumns = { @PrimaryKeyJoinColumn(name = IdentifierImpl.ISSUER_COLUMN, referencedColumnName = IdentifierImpl.ISSUER_COLUMN), @PrimaryKeyJoinColumn(name = IdentifierImpl.IDENTIFIER_COLUMN, referencedColumnName = IdentifierImpl.IDENTIFIER_COLUMN) } ) @org.hibernate.annotations.Table(appliesTo = IssuerImpl.TABLE_NAME, optional = false) The failure is seen via this simple lookup query final Issuer issuer = manager.find(new IdentifierImpl(1L, "1") where the executed query is "SELECT DISTINCT resource FROM " + this.clazz.getSimpleName() + " resource WHERE resource.identifier = :identifier"; where entity name is inserted as IssuerImpl. ( https://hibernate.atlassian.net/browse/HHH-14152#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14152#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#100144- sha1:57e1ab7 )

4 years, 1 month

1
0
0 / 0

[JIRA] (HHH-14151) SingularAttribute.isOptional() does not honour javax.validation.constraints.NotNull

by Filip Procházka (JIRA)

Filip Procházka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14151 ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiMDJkM2... ) Re: SingularAttribute.isOptional() does not honour javax.validation.constraints.NotNull ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiMDJkM2... ) Ok, I can try to reproduce it with 5.4.20.Final tomorrow ( https://hibernate.atlassian.net/browse/HHH-14151#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14151#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#100144- sha1:57e1ab7 )

4 years, 1 month

1
0
0 / 0

[JIRA] (HHH-14151) SingularAttribute.isOptional() does not honour javax.validation.constraints.NotNull

by Nathan Xu (JIRA)

Nathan Xu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14151 ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiMWIwNz... ) Re: SingularAttribute.isOptional() does not honour javax.validation.constraints.NotNull ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiMWIwNz... ) Is this ticket duplicated with https://hibernate.atlassian.net/browse/HHH-14129 ? If so the issue has been resolved in 5.4.20.Final. ( https://hibernate.atlassian.net/browse/HHH-14151#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14151#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#100144- sha1:57e1ab7 )

4 years, 1 month

1
0
0 / 0

[JIRA] (HHH-14151) SingularAttribute.isOptional() does not honour javax.validation.constraints.NotNull

by Filip Procházka (JIRA)

Filip Procházka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNDU0MDE3OTc2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiNDU0MD... ) HHH-14151 ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiNDU0MD... ) SingularAttribute.isOptional() does not honour javax.validation.constraints.NotNull ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiNDU0MD... ) Change By: Filip Procházka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I've just upgraded Spring Boot, which upgraded Hibernate ORM from 5.4.12.Final to 5.4.18.Final I have an association {code:java}@javax.persistence.ManyToOne(fetch = FetchType.LAZY) @javax.validation.constraints.NotNull private Product product;{code} I have logic that inspects metadata and collects nullable associations of an entity {code:java}List<Attribute<?, ?>> fields = new ArrayList<>(); fields.addAll(entityType.getSingularAttributes().stream() .filter(singularAttribute -> singularAttribute.isAssociation() && singularAttribute.getType() instanceof EntityType && singularAttribute.isOptional()) .collect(Collectors.toList())); return fields;{code} where `entityType` is `javax.persistence.metamodel.EntityType` Previously, the `isOptional` honoured the `NotNull` constraint and returned false, now it returns true which breaks my logic. I'm not yet sure if this is a miss-configuration by Spring Boot or by my application or if it's a bug in Hibernate, but with the upgrade this changed unexpectedly. So far I’ve been able to verify, that `org.hibernate.cfg.beanvalidation.TypeSafeActivator` is in fact initialized with the application. ( https://hibernate.atlassian.net/browse/HHH-14151#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14151#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#100144- sha1:57e1ab7 )

4 years, 1 month

1
0
0 / 0

[JIRA] (HHH-14151) SingularAttribute.isOptional() does not honour javax.validation.constraints.NotNull

by Filip Procházka (JIRA)

Filip Procházka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYTdhNjU2N2Yw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiYTdhNj... ) HHH-14151 ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiYTdhNj... ) SingularAttribute.isOptional() does not honour javax.validation.constraints.NotNull ( https://hibernate.atlassian.net/browse/HHH-14151?atlOrigin=eyJpIjoiYTdhNj... ) Change By: Filip Procházka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I've just upgraded Spring Boot, which upgraded Hibernate ORM from 5.4.12.Final to 5.4.18.Final I have an association {code:java} @javax.persistence.ManyToOne(fetch = FetchType.LAZY) @javax.validation.constraints.NotNull private Product product; {code} I have logic that inspects metadata and collects nullable associations of an entity {code:java} List<Attribute<?, ?>> fields = new ArrayList<>(); fields.addAll(entityType.getSingularAttributes().stream() .filter(singularAttribute -> singularAttribute.isAssociation() && singularAttribute.getType() instanceof EntityType && singularAttribute.isOptional()) .collect(Collectors.toList())); return fields; {code} where `entityType` is `javax.persistence.metamodel.EntityType` Previously, the `isOptional` honoured the `NotNull` constraint and returned false, not now it returns true which breaks my logic. I'm not yet sure if this is a miss-configuration by Spring Boot or by my application or if it's a bug in Hibernate, but with the upgrade this changed unexpectedly. ( https://hibernate.atlassian.net/browse/HHH-14151#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14151#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#100144- sha1:57e1ab7 )

4 years, 1 month

1
0
0 / 0

[JIRA] (HHH-14151) SingularAttribute.isOptional() does not honour javax.validation.constraints.NotNull

by Filip Procházka (JIRA)

4 years, 1 month

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 August 2020