May 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16606) ClassCastException retrieving byte[] from database

by Daniel Novo (JIRA)

Daniel Novo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ae986b... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjBhMDQ4NjJh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16606?atlOrigin=eyJpIjoiYjBhMD... ) HHH-16606 ( https://hibernate.atlassian.net/browse/HHH-16606?atlOrigin=eyJpIjoiYjBhMD... ) ClassCastException retrieving byte[] from database ( https://hibernate.atlassian.net/browse/HHH-16606?atlOrigin=eyJpIjoiYjBhMD... ) Change By: Daniel Novo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ae986b... ) Hi, I have an entity mapped with an byte[] attribute (SQL Server - Column definition: Photo IMAGE). {noformat}@Entity @Table(name = "MYTABLE") public class MyEntity { ... @Lob @Column(name = "Photo") private byte[] photo = null; ... } public byte[] getPhoto(String id) { CriteriaBuilder cb = getEntityManager().getCriteriaBuilder(); CriteriaQuery<byte[]> cq = cb.createQuery(byte[].class); Root<MyEntity> root = cq.from(MyEntity.class); cq.select(root.get(MyEntity_.photo)) .where(cb.equal(root.get(MyEntity_.id), id)); TypedQuery<byte[]> q = getEntityManager().createQuery(cq); return q.getSingleResult(); }{noformat} Executing the query i’m getting: {{Caused by: java.lang.ClassCastException: class [Ljava.lang.Object; cannot be cast to class [B ([Ljava.lang.Object; and [B are in module java.base of loader 'bootstrap')}} I created a unit test [https://github.com/DanielNovo/hibernate-test-case-templates/commit/dd2f5d...] ( https://hibernate.atlassian.net/browse/HHH-16606#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16606#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:a5851ae )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16606) ClassCastException retrieving byte[] from database

by Daniel Novo (JIRA)

Daniel Novo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ae986b... ) *commented* on HHH-16606 ( https://hibernate.atlassian.net/browse/HHH-16606?atlOrigin=eyJpIjoiNTRhYz... ) Re: ClassCastException retrieving byte[] from database ( https://hibernate.atlassian.net/browse/HHH-16606?atlOrigin=eyJpIjoiNTRhYz... ) Link for unit test: https://github.com/DanielNovo/hibernate-test-case-templates/commit/dd2f5d... ( https://hibernate.atlassian.net/browse/HHH-16606#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16606#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:a5851ae )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16495) A query with an non-cross entity join that lacks the on clause should fail with a SemanticQueryException

by Marco Belladelli (JIRA)

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16607) Hibernate bytecode enhancement makes private fields public

by SAI Générique (JIRA)

SAI Générique ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63a1d8d... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmMxZThjYjU1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16607?atlOrigin=eyJpIjoiNmMxZT... ) HHH-16607 ( https://hibernate.atlassian.net/browse/HHH-16607?atlOrigin=eyJpIjoiNmMxZT... ) Hibernate bytecode enhancement makes private fields public ( https://hibernate.atlassian.net/browse/HHH-16607?atlOrigin=eyJpIjoiNmMxZT... ) Issue Type: Bug Affects Versions: 6.2.2 Assignee: Unassigned Components: bytecode-enhancement Created: 15/May/2023 07:17 AM Environment: - JDK17 - payara-embedded-all 6.2023.1 - Linux Debian Priority: Major Reporter: SAI Générique ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63a1d8d... ) Hello, We are using the maven plugin for byte code enhancement with the following configuration: <plugin> <groupId> org.hibernate.orm.tooling </groupId> <artifactId> hibernate-enhance-maven-plugin </artifactId> <executions> <execution> <configuration>  <failOnError> true </failOnError> <enableDirtyTracking> true </enableDirtyTracking> <enableLazyInitialization> false </enableLazyInitialization> <enableAssociationManagement> false </enableAssociationManagement> <enableExtendedEnhancement> false </enableExtendedEnhancement> </configuration> <goals> <goal> enhance </goal> </goals> </execution> </executions> </plugin> All our entities have *only* private fields: @Entity @Table(name = "mytable" ) public class MyTable { @EmbeddedId private IdTablePK mytablePK; @Column(name = "LIBELL" ) private String libell; public MyTable(IdTablePK pk) { this.mytablePK = pk; } public String getLibell() { return libell; } public void setLibell( String libell) { this.libell = libell; } } After upgrading, the following check fails in our CI: for (Field field : entity.getDeclaredFields()) { int modifiers = field.getModifiers(); boolean isPrivate = (modifiers & Modifier.PRIVATE)!=0; assertTrue(isPrivate, "The field must be private " ); } ( https://hibernate.atlassian.net/browse/HHH-16607#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16607#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:a5851ae )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16606) ClassCastException retrieving byte[] from database

by Daniel Novo (JIRA)

Daniel Novo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ae986b... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmZkYTgzMTJl... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16606?atlOrigin=eyJpIjoiYmZkYT... ) HHH-16606 ( https://hibernate.atlassian.net/browse/HHH-16606?atlOrigin=eyJpIjoiYmZkYT... ) ClassCastException retrieving byte[] from database ( https://hibernate.atlassian.net/browse/HHH-16606?atlOrigin=eyJpIjoiYmZkYT... ) Issue Type: Bug Affects Versions: 6.2.2 Assignee: Unassigned Components: hibernate-core Created: 15/May/2023 07:15 AM Priority: Blocker Reporter: Daniel Novo ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ae986b... ) Hi, I have an entity mapped with an byte[] attribute (SQL Server - Column definition: Photo IMAGE). @Entity @Table(name = "MYTABLE") public class MyEntity { ... @Lob @Column(name = "Photo") private byte[] photo = null; ... } public byte[] getPhoto(String id) { CriteriaBuilder cb = getEntityManager().getCriteriaBuilder(); CriteriaQuery<byte[]> cq = cb.createQuery(byte[].class); Root<MyEntity> root = cq.from(MyEntity.class); cq.select(root.get(MyEntity_.photo)) .where(cb.equal(root.get(MyEntity_.id), id)); TypedQuery<byte[]> q = getEntityManager().createQuery(cq); return q.getSingleResult(); } Executing the query i’m getting: Caused by: java.lang.ClassCastException: class [Ljava.lang.Object; cannot be cast to class [B ([Ljava.lang.Object; and [B are in module java.base of loader 'bootstrap') I created a unit test ( https://hibernate.atlassian.net/browse/HHH-16606#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16606#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:a5851ae )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16576) Problem in query involving union on MySQL 5.7, MariaDB and Oracle

by Marco Belladelli (JIRA)

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16599) No way to make attributes of record annotated @Struct not-null

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16599 ( https://hibernate.atlassian.net/browse/HHH-16599?atlOrigin=eyJpIjoiZjRkZj... ) Re: No way to make attributes of record annotated @Struct not-null ( https://hibernate.atlassian.net/browse/HHH-16599?atlOrigin=eyJpIjoiZjRkZj... ) I mean, I know this for sure because I clearly remember this discussion in the EJB 3.0 EG. ( https://hibernate.atlassian.net/browse/HHH-16599#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16599#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:a5851ae )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16599) No way to make attributes of record annotated @Struct not-null

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16599 ( https://hibernate.atlassian.net/browse/HHH-16599?atlOrigin=eyJpIjoiZTA2YT... ) Re: No way to make attributes of record annotated @Struct not-null ( https://hibernate.atlassian.net/browse/HHH-16599?atlOrigin=eyJpIjoiZTA2YT... ) WDYM? It does have that effect for any other @Embeddable. Including embeddables mapped to JSON. Not sure if the spec strictly-speaking requires that (it’s pretty silent on DDL generation in general) but that has certainly always been the intention. ( https://hibernate.atlassian.net/browse/HHH-16599#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16599#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:a5851ae )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16605) [6.2.2] Boolean vs Integer comparison crash

by SAI Générique (JIRA)

SAI Générique ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63a1d8d... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjA5ZGVmNDY5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16605?atlOrigin=eyJpIjoiMjA5ZG... ) HHH-16605 ( https://hibernate.atlassian.net/browse/HHH-16605?atlOrigin=eyJpIjoiMjA5ZG... ) [6.2.2] Boolean vs Integer comparison crash ( https://hibernate.atlassian.net/browse/HHH-16605?atlOrigin=eyJpIjoiMjA5ZG... ) Issue Type: Bug Affects Versions: 6.2.2 Assignee: Unassigned Components: query-hql Created: 15/May/2023 06:55 AM Environment: - JDK17 - payara-embedded-all 6.2023.1 - Linux Debian Priority: Major Reporter: SAI Générique ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63a1d8d... ) Hello, When comparing data, the following predicate worked until 6.1.7.Final: SELECT p FROM MyTable p WHERE INTERSECTS(p.spatialdata, TO_LINESTRING( '2018-09-01 00:00:00' , '2018-09-01 23:59:59' )) = 1 However, this query results in the following stacktrace: java.lang.IllegalArgumentException: org.hibernate.query.sqm.InterpretationException: Error interpreting query [...] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:168) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:795) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:704) at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:190) at com.sun.enterprise.container.common.impl.EntityManagerWrapper.createQuery(EntityManagerWrapper.java:458) ... Caused by: org.hibernate.query.sqm.InterpretationException: Error interpreting query [...] at org.hibernate.query.hql.internal.StandardHqlTranslator.translate(StandardHqlTranslator.java:97) at org.hibernate.internal.AbstractSharedSessionContract.lambda$interpretHql$2(AbstractSharedSessionContract.java:744) at org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.createHqlInterpretation(QueryInterpretationCacheStandardImpl.java:141) at org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.resolveHqlInterpretation(QueryInterpretationCacheStandardImpl.java:128) at org.hibernate.internal.AbstractSharedSessionContract.interpretHql(AbstractSharedSessionContract.java:741) at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:786) ... 79 more Caused by: java.lang.IllegalArgumentException: Can't compare test expression of type [basicType(a)33(java.lang.Boolean,16)] with element of type [basicType(a)4(java.lang.Integer,4)] at org.hibernate.query.sqm.internal.SqmCriteriaNodeBuilder.assertComparable(SqmCriteriaNodeBuilder.java:2098) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitComparisonPredicate(SemanticQueryBuilder.java:2493) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitComparisonPredicate(SemanticQueryBuilder.java:253) at org.hibernate.grammars.hql.HqlParser$ComparisonPredicateContext.accept(HqlParser.java:6111) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitAndPredicate(SemanticQueryBuilder.java:2313) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitAndPredicate(SemanticQueryBuilder.java:253) ... We were able to work this around by changing the ‘1' to 'true’: SELECT p FROM MyTable p WHERE INTERSECTS(p.spatialdata, TO_LINESTRING('2018-09-01 00:00:00','2018-09-01 23:59:59')) = true Also note that this hack is not necessary anymore since version 6.x because the right hand side can be omitted altogether: SELECT p FROM MyTable p WHERE INTERSECTS(p.spatialdata, TO_LINESTRING('2018-09-01 00:00:00','2018-09-01 23:59:59')) ( https://hibernate.atlassian.net/browse/HHH-16605#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16605#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:a5851ae )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16600) @Basic(optional=false) on embeddable held by subclass in single table inheritance

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16600 ( https://hibernate.atlassian.net/browse/HHH-16600?atlOrigin=eyJpIjoiMTljNm... ) Re: @Basic(optional=false) on embeddable held by subclass in single table inheritance ( https://hibernate.atlassian.net/browse/HHH-16600?atlOrigin=eyJpIjoiMTljNm... ) Oh well, yeah, that would be awesome. Nice idea. ( https://hibernate.atlassian.net/browse/HHH-16600#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16600#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:a5851ae )

3 years, 1 month

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 May 2023