June 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16738) BadJpqlGrammarException when using column names coinciding with functions in projection

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16738 ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiNjQzY2... ) Re: BadJpqlGrammarException when using column names coinciding with functions in projection ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiNjQzY2... ) This issue can be closed. ( https://hibernate.atlassian.net/browse/HHH-16738#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16738#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#100225- sha1:e03cc87 )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16673) Fail to get access lazy fetched field ( @ManyToOne ) which is part of a composite Id (using an @IdClass) when stored in L2 cache

by Erwan Moutymbo (JIRA)

Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmU4NTczYTVl... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16673?atlOrigin=eyJpIjoiYmU4NT... ) HHH-16673 ( https://hibernate.atlassian.net/browse/HHH-16673?atlOrigin=eyJpIjoiYmU4NT... ) Fail to get access lazy fetched field ( @ManyToOne ) which is part of a composite Id (using an @IdClass) when stored in L2 cache ( https://hibernate.atlassian.net/browse/HHH-16673?atlOrigin=eyJpIjoiYmU4NT... ) Change By: Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) Environment: Hibernate: tried 6.1.7.Final to 6.2. 3 4.Final initially found with Postgresql: 14.5 reproduced with h2 2.1.214 Spring Data JPA: 3.0.6 Spring Boot: 3.0.7 ehcache 3.10.8 JDK: OpenJDK 64-Bit Server VM Temurin-17.0.6 OS: Fedora 38 ( https://hibernate.atlassian.net/browse/HHH-16673#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16673#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#100225- sha1:e03cc87 )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16673) Fail to get access lazy fetched field ( @ManyToOne ) which is part of a composite Id (using an @IdClass) when stored in L2 cache

by Erwan Moutymbo (JIRA)

Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiODc4YjQ5YmI1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16673?atlOrigin=eyJpIjoiODc4Yj... ) HHH-16673 ( https://hibernate.atlassian.net/browse/HHH-16673?atlOrigin=eyJpIjoiODc4Yj... ) Fail to get access lazy fetched field ( @ManyToOne ) which is part of a composite Id (using an @IdClass) when stored in L2 cache ( https://hibernate.atlassian.net/browse/HHH-16673?atlOrigin=eyJpIjoiODc4Yj... ) Change By: Erwan Moutymbo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=640210c... ) I'm migrating from hibernate 5.6.15 to hibernate 6.2.3 and I have noticed some issues with the L2 cache when an entity has a composite Id with one of its field mapped from a many to one association. h3. Entities {code:java}@Getter @IdClass(ProductPK.class) @EqualsAndHashCode(onlyExplicitlyIncluded = true) @ToString(onlyExplicitlyIncluded = true) @NoArgsConstructor(access = PROTECTED) @Entity @OptimisticLocking(type = OptimisticLockType.ALL) @DynamicUpdate @Cacheable @Cache(usage = READ_WRITE) @Table(name = "PRODUCTS") public class Product { public Product(String productId, Operator operator) { this.productId = productId; this.operator = operator; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "PRODUCT_ID", nullable = false) private String productId; @Id @EqualsAndHashCode.Include @ToString.Include @Getter @Setter @ManyToOne(fetch = LAZY) @JoinColumn private Operator operator; @Column(name = "DESCRIPTION") @Setter private String description; @AllArgsConstructor @EqualsAndHashCode @Getter @Setter @NoArgsConstructor(access = PRIVATE) public static class ProductPK implements Serializable { private String productId; private String operator; } }{code} {code:java}@Getter @Entity @ToString(onlyExplicitlyIncluded = true) @EqualsAndHashCode(onlyExplicitlyIncluded = true) @NoArgsConstructor(access = PROTECTED) @Table(name = "OPERATORS") @OptimisticLocking(type = OptimisticLockType.DIRTY) @DynamicUpdate @Cacheable @Cache(usage = READ_WRITE) public class Operator { public Operator(String operatorId) { this.operatorId = operatorId; } @EqualsAndHashCode.Include @ToString.Include @Id @Column(name = "OPERATOR_ID", nullable = false) private String operatorId; @OneToMany(mappedBy = "operator", cascade = {CascadeType.ALL}, orphanRemoval = true) private List<Product> products = new ArrayList<>(); public void setProducts(List<Product> products) { this.products = products; } }{code} h3. First Test {code:java} @Test void addProductAndReadFromCacheTest() { String string = "ID"; String operatorID = "operatorID"; ProductPK id = new ProductPK(string, operatorID); String test = "test"; Operator operator = new Operator(operatorID); operatorDao.save(operator); Product product = new Product(string, operator); product.setDescription(test); productService.addProduct(product); // getProduct has @Transactional(propagation = REQUIRES_NEW) // First read is made from DB Optional<Product> byId = productService.getProduct(id); assertThat(byId.orElseThrow().getOperator().getOperatorId()).isEqualTo(operatorID); // Second read is from cache Optional<Product> byId2 = productService.getProduct(id); assertThat(byId2.orElseThrow().getOperator().getOperatorId()).isEqualTo(operatorID); }{code} This test throw the following exception during {{Optional<Product> byId2 = productService.getProduct(id);}} execution: {noformat}Caused by: org.hibernate.HibernateException: identifier of an instance of com.example.demo.local.Product was altered from com.example.demo.local.Product$ProductPK@226fd to com.example.demo.local.Product$ProductPK@44bf91 at org.hibernate.event.internal.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:93) at org.hibernate.event.internal.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:175) at org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:134) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127) at org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:221) at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:90) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:38) at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1412) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:485) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2296) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1961) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:439) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:169) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:267) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:561) ... 80{noformat} h3. Second Test {code:java} @Test void addProductAndReadFromCacheReadOnlyTest() { String string = "ID"; String operatorID = "operatorID"; ProductPK id = new ProductPK(string, operatorID); String test = "test"; Operator operator = new Operator(operatorID); operatorDao.save(operator); Product product = new Product(string, operator); product.setDescription(test); productService.addProduct(product); // getProduct has @Transactional(propagation = REQUIRES_NEW) annotation // First read is made from DB Optional<Product> byId = productService.getProduct(id); assertThat(byId.orElseThrow().getOperator().getOperatorId()).isEqualTo(operatorID); // readProduct has @Transactional(readOnly = true) annotation // Second read is from cache Optional<Product> byId2 = productService.readProduct(id); assertThat(byId2.orElseThrow().getOperator().getOperatorId()).isEqualTo(operatorID); }{code} This test raise the following exception. It seems that hibernate ignore that {{operator}} is a lazy fetched field. {noformat}java.lang.NullPointerException: Cannot invoke "com.example.demo.local.Operator.getOperatorId()" because the return value of "com.example.demo.local.Product.getOperator()" is null{noformat} Github repo with sources : [https://github.com/emouty/hibernate-L2-cache-issue|https://github.com/emo...] ( https://hibernate.atlassian.net/browse/HHH-16673#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16673#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#100225- sha1:e03cc87 )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16738) BadJpqlGrammarException when using column names coinciding with functions in projection

by Niklas Fischer (JIRA)

Niklas Fischer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16738 ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiYWNlZG... ) Re: BadJpqlGrammarException when using column names coinciding with functions in projection ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiYWNlZG... ) I have now also raised an issue with sprong data jpa: https://github.com/spring-projects/spring-data-jpa/issues/2994 ( https://hibernate.atlassian.net/browse/HHH-16738#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16738#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#100225- sha1:e03cc87 )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16738) BadJpqlGrammarException when using column names coinciding with functions in projection

by Niklas Fischer (JIRA)

Niklas Fischer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmVjYjdhN2U3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiNmVjYj... ) HHH-16738 ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiNmVjYj... ) BadJpqlGrammarException when using column names coinciding with functions in projection ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiNmVjYj... ) Change By: Niklas Fischer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) Environment: [INFO] | +- org.hibernate.orm:hibernate-core:jar:6.2.2.Final:compile [INFO] | | +- jakarta.persistence:jakarta.persistence-api:jar:3.1.0:compile [INFO] | | +- jakarta.transaction:jakarta.transaction-api:jar:2.0.1:compile [INFO] | | +- org.hibernate.common:hibernate-commons-annotations:jar:6.0.6.Final:runtime [INFO] | | +- io.smallrye:jandex:jar:3.0.5:runtime [INFO] | | +- net.bytebuddy:byte-buddy:jar:1.14.4:runtime [INFO] | | +- org.glassfish.jaxb:jaxb-runtime:jar:4.0.2:runtime [INFO] | | | \- org.glassfish.jaxb:jaxb-core:jar:4.0.2:runtime [INFO] | | | +- org.glassfish.jaxb:txw2:jar:4.0.2:runtime [INFO] | | | \- com.sun.istack:istack-commons-runtime:jar:4.1.1:runtime [INFO] | | +- jakarta.inject:jakarta.inject-api:jar:2.0.1:runtime [INFO] | | \- org.antlr:antlr4-runtime:jar:4.10.1:compile java --version openjdk 20.0.1 2023-04-18 OpenJDK Runtime Environment (Red_Hat-20.0.1.0.9-2.rolling.fc38) (build 20.0.1+9) OpenJDK 64-Bit Server VM (Red_Hat-20.0.1.0.9-2.rolling.fc38) (build 20.0.1+9, mixed mode, sharing) storage_db=# select version(); version ----------------------------------------------------------------------------------------------------------------------------- PostgreSQL 14.7 (Debian 14.7-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit ( https://hibernate.atlassian.net/browse/HHH-16738#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16738#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#100225- sha1:e03cc87 )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16739) Several failures when comparing enum parameters with constant values

by Arrigo Zanette (JIRA)

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16739) Several failures when comparing enum parameters with constant values

by Arrigo Zanette (JIRA)

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16738) BadJpqlGrammarException when using column names coinciding with functions in projection

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16738 ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiMTU2Zm... ) Re: BadJpqlGrammarException when using column names coinciding with functions in projection ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiMTU2Zm... ) I mean for real: we spend something like five years developing the greatest and most powerful ORM query language ever, and you can’t use it because Spring wants to do everything in its own way, including parsing HQL! That’s just amazing. ( https://hibernate.atlassian.net/browse/HHH-16738#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16738#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#100225- sha1:40c4da4 )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16738) BadJpqlGrammarException when using column names coinciding with functions in projection

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16738 ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiOTdiMD... ) Re: BadJpqlGrammarException when using column names coinciding with functions in projection ( https://hibernate.atlassian.net/browse/HHH-16738?atlOrigin=eyJpIjoiOTdiMD... ) I read the issue description and thought “this doesn’t make any sense”. Function names like sign and exp aren’t keywords in HQL, and so there’s no reason that the parser would choke on them. The parser has no idea they’re functions. So that was very confusing. So of course I tested it quickly against main and could not reproduce. Phew , I’m not going crazy. So I come back and look at your stack trace. And guess what: there’s no Hibernate code in that stack trace, only this: org.springframework.data.jpa.repository.query.HqlParser What the actual fuck? Are you serious? Spring is so bloated it now has its own buggy and broken parser for HQL?? Please tell me that ain’t true! ( https://hibernate.atlassian.net/browse/HHH-16738#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16738#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#100225- sha1:40c4da4 )

2 years, 10 months

1
0
0 / 0

[JIRA] (HHH-16697) CALCULATED FIELDS in createNativeQuery doExtract integer insted of BigDecimals.

by Isaac Vásquez (JIRA)

2 years, 10 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 June 2023