February 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16166) ClassCastException, mixing mapping types for same field name on different entities

by Marco Belladelli (JIRA)

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16166) ClassCastException, mixing mapping types for same field name on different entities

by Marco Belladelli (JIRA)

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16216) @Query creates additional not null checks for SybaseASEDialect

by Marius K (JIRA)

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16216) @Query creates additional not null checks for Sybase

by Marius K (JIRA)

Marius K ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HHH-16216 ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiYzdkOD... ) Re: @Query creates additional not null checks for Sybase ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiYzdkOD... ) I switched to org.hibernate.dialect.SybaseDialect}}and it works again. So it seems to be a problem with {{org.hibernate.dialect.SybaseASEDialect ( https://hibernate.atlassian.net/browse/HHH-16216#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16216#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#100216- sha1:64a4cf6 )

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16215) Composite primary key @IdClass attribute mapping is borrowed from the first OneToMany backref and cannot be set

by Alina Ricciuti (JIRA)

Alina Ricciuti ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61fb92a... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiODkwYjVjYzRk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16215?atlOrigin=eyJpIjoiODkwYj... ) HHH-16215 ( https://hibernate.atlassian.net/browse/HHH-16215?atlOrigin=eyJpIjoiODkwYj... ) Composite primary key @IdClass attribute mapping is borrowed from the first OneToMany backref and cannot be set ( https://hibernate.atlassian.net/browse/HHH-16215?atlOrigin=eyJpIjoiODkwYj... ) Change By: Alina Ricciuti ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61fb92a... ) Please find below the issue I have encountered during the migration from hibernate 5 to hibernante 6.1.7. My sample project is using Lombok / Spring Data; its datamodel is composed of : * Buckets having Lines {noformat}@Getter @Setter @Entity @Table(name = "BUCKET") @SequenceGenerator(name = "SEQ_BUCKET_ID", allocationSize = 10, sequenceName = "SEQ_BUCKET_ID") @IdClass(PkBucket.class) public class Bucket { @Id @Column(name = "ID") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_BUCKET_ID") private Long id; @OneToMany(cascade = CascadeType.ALL) @JoinColumn(name = "BUCKET_ID", referencedColumnName = "id", nullable = false) private List<Line> lines = new ArrayList<>(); }{noformat} * Items having Lines {noformat}@Getter @Setter @Entity @Table(name = "LINE") @SequenceGenerator(name = "SEQ_LINE_ID", allocationSize = 10, sequenceName = "SEQ_LINE_ID") @IdClass(PkLine.class) public class Line { @Id @Column(name = "ID") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_LINE_ID") private Long id; @ManyToOne(targetEntity = Item.class) @JoinColumn(name = "ITEM_ID", referencedColumnName = "id", nullable = false) private Item item; }{noformat} * The Line class {noformat}@Getter @Setter @Entity @Table(name = "ITEM") @SequenceGenerator(name = "SEQ_ITEM_ID", allocationSize = 10, sequenceName = "SEQ_ITEM_ID") @IdClass(PkItem.class) public class Item { @Id @Column(name = "ID") @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_ITEM_ID") private Long id; @OneToMany(mappedBy = "item", cascade = CascadeType.ALL, orphanRemoval = true) private List<Line> lines = new ArrayList<>(); }{noformat} * The simplified Pk classes - they are all identical, as PkBucket here below {noformat}@Getter @Setter public class PkBucket implements Serializable { private Long id; public PkBucket withId(Long id) { this.id = id; return this; } }{noformat} My test is creating and updating some data : {noformat} @Test @Transactional public void buckets_items_lines() { // create some data Session session = entityManager.unwrap(Session.class); session.createNativeQuery("insert into ITEM (id) values (100)").executeUpdate(); session.createNativeQuery("insert into ITEM (id) values (101)").executeUpdate(); session.createNativeQuery("insert into BUCKET (id) values (200)").executeUpdate(); session.createNativeQuery("insert into LINE (id, ITEM_ID, BUCKET_ID) values (300, 100, 200)").executeUpdate(); // move line from item to other item Item item100 = itemRepository.findById(new PkItem().withId(100L)).get(); final Item item101 = itemRepository.findById(new PkItem().withId(101L)).get(); item100.getLines().forEach(line -> line.setItem(item101)); }{noformat} The issue below occurs when tying to hydrate Item.lines: {noformat}Could not set value of type [java.lang.Long] : `com.example.demo.domain.issue2.PkBucket.id` (setter) org.hibernate.PropertyAccessException: Could not set value of type [java.lang.Long] : `com.example.demo.domain.issue2.PkBucket.id` (setter) at app//org.hibernate.property.access.spi.SetterFieldImpl.set(SetterFieldImpl.java:81) at app//org.hibernate.metamodel.mapping.internal.AbstractEmbeddableMapping.setValues(AbstractEmbeddableMapping.java:103){noformat} Few remarks: * As you can see in the stack attached, the Line property id is accessed through PkBucket id instead of PkLine id. * If I remove {{nullable = false}} from Bucket lines JoinColums the result is OK * It I change the mapping to add and use a ManyToOne relationship in Line class to Bucket entity the result is also OK * If I use unique Pk class the issue persists : IllegalArgumentException: Can not set java.lang.Long field [com.example.demo.domain.issue2.Pk.id|http://com.example.demo.domain.issue2.Pk.id] to com.example.demo.domain.issue2.Line * If I force the Line class to extend the expected id class the result is OK but this is not nice 🙂 {noformat}... @IdClass(PkLine.class) public class Line extends PkBucket { ...{noformat} I have attached the full log; if needed, I can also share my sample project. ( https://hibernate.atlassian.net/browse/HHH-16215#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16215#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#100216- sha1:64a4cf6 )

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16216) @Query creates additional not null checks for Sybase

by Marius K (JIRA)

Marius K ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmZjZTFiZWRi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiYmZjZT... ) HHH-16216 ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiYmZjZT... ) @Query creates additional not null checks for Sybase ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiYmZjZT... ) Change By: Marius K ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) I upgraded from Spring Boot 2.7 to 3.0, hence from Hibernate 5 to Hibernate 6 Unfortunately the {{@Query}} annotations in a {{JpaRepository}} suddenly add {{not null}} checks for all columns using Sybase. It works fine with h2 {noformat}@Entity @Table(name = "MY_USER") @Getter @Setter @EqualsAndHashCode public class MyUser { @Id @Column(name = "MY_USER_ID", unique = true, nullable = false) private Integer myUserId; @Column(name = "FIRSTNAME") private String firstname; @Column(name = "LASTNAME") private boolean lastname; }{noformat} and {noformat}public interface MyUserRepository extends JpaRepository<MyUser, Integer> { @Query("select r from MyUser r where r.firstname = :firstname and r.lastname = :lastname") List<MyUser> getUser(@Param("firstname") String firstname, @Param("lastname") String lastname); }{noformat} results in the query {{select m1_0.my_user_id,m1_0.firstname,m1_0.lastname from my_user m1_0 where m1_0.firstname=? and m1_0.lastname=?}} which is obviously fine. But when I switch to Sybase {noformat}spring.datasource.url=xxx spring.datasource.username=xxx spring.datasource.password=xxx spring.datasource.driver-class-name=com.sybase.jdbc4.jdbc.SybDriver spring.jpa.database-platform=org.hibernate.dialect.SybaseASEDialect{noformat} {noformat}<dependency> <groupId>com.sybase</groupId> <artifactId>jconn4</artifactId> </dependency>{noformat} the query is {{select m1_0.my_user_id,m1_0.firstname,m1_0.lastname from my_user m1_0 where m1_0.firstname=? and m1_0.firstname is not null and m1_0.lastname=? and m1_0.lastname is not null}} with additional null checks. This breaks my code as it is no longer possible to pass null to the parameters in the {{getUser}} method. It worked properly with Hibernate 5.6.14. I attached an example project : HHH-16216 (7230c947-b841-4581-91e1-a54f8f04578e). zip ( https://hibernate.atlassian.net/browse/HHH-16216#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16216#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#100216- sha1:64a4cf6 )

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16216) @Query creates additional not null checks for Sybase

by Marius K (JIRA)

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16216) @Query creates additional not null checks for Sybase

by Marius K (JIRA)

Marius K ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmJhZDY5OGFm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiNmJhZD... ) HHH-16216 ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiNmJhZD... ) @Query creates additional not null checks for Sybase ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiNmJhZD... ) Change By: Marius K ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) I upgraded from Spring Boot 2.7 to 3.0, hence from Hibernate 5 to Hibernate 6 Unfortunately the {{@Query}} annotations in a {{JpaRepository}} suddenly add {{not null}} checks for all columns using Sybase. It works fine with h2 {noformat}@Entity @Table(name = "MY_USER") @Getter @Setter @EqualsAndHashCode public class MyUser { @Id @Column(name = "MY_USER_ID", unique = true, nullable = false) private Integer myUserId; @Column(name = "FIRSTNAME") private String firstname; @Column(name = "LASTNAME") private boolean lastname; }{noformat} and {noformat}public interface MyUserRepository extends JpaRepository<MyUser, Integer> { @Query("select r from MyUser r where r.firstname = :firstname and r.lastname = :lastname") List<MyUser> getUser(@Param("firstname") String firstname, @Param("lastname") String lastname); }{noformat} results in the query {{select m1_0.my_user_id,m1_0.firstname,m1_0.lastname from my_user m1_0 where m1_0.firstname=? and m1_0.lastname=?}} which is obviously fine. But when I switch to Sybase {noformat}spring.datasource.url=xxx spring.datasource.username=xxx spring.datasource.password=xxx spring.datasource.driver-class-name=com.sybase.jdbc4.jdbc.SybDriver spring.jpa.database-platform=org.hibernate.dialect.SybaseASEDialect{noformat} {noformat}<dependency> <groupId>com.sybase</groupId> <artifactId>jconn4</artifactId> </dependency>{noformat} the query is {{select m1_0.my_user_id,m1_0.firstname,m1_0.lastname from my_user m1_0 where m1_0.firstname=? and m1_0.firstname is not null and m1_0.lastname=? and m1_0.lastname is not null}} with additional null checks. This breaks my code as it is no longer possible to pass null to the parameters in the {{getUser}} method. It worked properly with Hibernate 5.6.14. I attached an example project. ( https://hibernate.atlassian.net/browse/HHH-16216#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16216#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#100216- sha1:64a4cf6 )

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16216) @Query creates additional not null checks for Sybase

by Marius K (JIRA)

1 year, 10 months

1
0
0 / 0

[JIRA] (HHH-16216) @Query creates additional not null checks for Sybase

by Marius K (JIRA)

Marius K ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzU2MTRmOTJm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiMzU2MT... ) HHH-16216 ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiMzU2MT... ) @Query creates additional not null checks for Sybase ( https://hibernate.atlassian.net/browse/HHH-16216?atlOrigin=eyJpIjoiMzU2MT... ) Change By: Marius K ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) I upgraded from Spring Boot 2.7 to 3.0, hence from Hibernate 5 to Hibernate 6 Unfortunately the {{@Query}} annotations in a {{JpaRepository}} suddenly add {{not null}} checks for all columns using Sybase. It works fine with h2 {noformat}@Entity @Table(name = "MY_USER") @Getter @Setter @EqualsAndHashCode public class MyUser { @Id @Column(name = "MY_USER_ID", unique = true, nullable = false) private Integer myUserId; @Column(name = "FIRSTNAME") private String firstname; @Column(name = "LASTNAME") private boolean lastname; }{noformat} and {noformat}public interface MyUserRepository extends JpaRepository<MyUser, Integer> { @Query("select r from MyUser r where r.firstname = :firstname and r.lastname = :lastname") List<MyUser> getUser(@Param("firstname") String firstname, @Param("lastname") String lastname); }{noformat} results in the query {{select m1_0.my_user_id,m1_0.firstname,m1_0.lastname from my_user m1_0 where m1_0.firstname=? and m1_0.lastname=?}} which is obviously fine. But when I switch to Sybase {noformat}spring.datasource.url=xxx spring.datasource.username=xxx spring.datasource.password=xxx spring.datasource.driver-class-name=com.sybase.jdbc4.jdbc.SybDriver spring.jpa.database-platform=org.hibernate.dialect.SybaseASEDialect{noformat} {noformat}<dependency> <groupId>com.sybase</groupId> <artifactId>jconn4</artifactId> </dependency>{noformat} the query is {{select m1_0.my_user_id,m1_0.firstname,m1_0.lastname from my_user m1_0 where m1_0.firstname=? and m1_0.firstname is not null and m1_0.lastname=? and m1_0.lastname is not null}} with additional null checks. This breaks my code as it is no longer possible to pass null to the parameters in the {{getUser}} ` method. It worked properly with Hibernate 5.6.14. ( https://hibernate.atlassian.net/browse/HHH-16216#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16216#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#100216- sha1:64a4cf6 )

1 year, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues February 2023