March 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16380) Avoid map-based mapping metamodel access when instantiating entity instances

by Christian Beikov (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function st_extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzlmNTkzZTcx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiNzlmNT... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiNzlmNT... ) PostGIS function st_extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiNzlmNT... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent _st_extent(geometry)_. Entity/Repository: {code:java}@Entity @Table(name = "geometry_entity") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository JpaRepository <GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByJPQL(); @Query(value = "select st_extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByST_PrefixedFunctionName(); @Query(value = "select st_extent(the_geom) from geometry_entity", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); }{code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_... extent _extent_ AND st_extent _st_extent_ should work. I have three different queries, two of them are using JPQL, the other one is written native. None of them work, all results in an error. The attempt to call {{getExtentByJPQL}}() results in: {noformat}2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a]{noformat} The attempt to call {{getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: {noformat}org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} Just as a side note, using st_envelope _st_envelope_ / _envelope_ instead of st_extent _st_extent_ / _extent_ works on JPQL queries, using a native query ends up with same {{ConverterNotFoundException}} I get by using st_extent _st_extent_. * spring-boot:3.0.4 * hibernate-spatial:6.1.7 * postgres/postgis:15-3.3 Test case to reproduce the error: [https://github.com/marcozet/spring-boot-3-hibernate-spatial|https://githu...] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HBX-2444) Implement and use the generic adapter for IForeignKey in the experimental Hibernate runtime

by Koen Aers (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HBX-2450) Implement and use the generic adapter for IPrimaryKey in the experimental Hibernate runtime

by Koen Aers (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HBX-2437) Implement and use the generic adapter for IType in the experimental Hibernate runtime

by Koen Aers (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HBX-2459) Implement and use the generic adapter for IValue in the experimental Hibernate runtime

by Koen Aers (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HBX-2457) Implement and use the generic adapter for ITableFilter in the experimental Hibernate runtime

by Koen Aers (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HBX-2458) Implement and use the generic adapter for ITypeFactory in the experimental Hibernate runtime

by Koen Aers (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16381) Hibernate inheritance using mapped superclass JPA query issue

by amit mahajan (JIRA)

amit mahajan ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16381 ( https://hibernate.atlassian.net/browse/HHH-16381?atlOrigin=eyJpIjoiMmUwMz... ) Re: Hibernate inheritance using mapped superclass JPA query issue ( https://hibernate.atlassian.net/browse/HHH-16381?atlOrigin=eyJpIjoiMmUwMz... ) This issue does not happen when we use annotations along with xml mapping. ( https://hibernate.atlassian.net/browse/HHH-16381#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16381#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16337) EntityCollection is not deleted when replaced

by Alexander Schwartz (JIRA)

Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) *commented* on HHH-16337 ( https://hibernate.atlassian.net/browse/HHH-16337?atlOrigin=eyJpIjoiM2E4Nz... ) Re: EntityCollection is not deleted when replaced ( https://hibernate.atlassian.net/browse/HHH-16337?atlOrigin=eyJpIjoiM2E4Nz... ) Thank you for this fix. I build a local 6.2 SNAPSHOT release and tested the one failing test case locally: it fixes the issue. Successfully validated! I didn’t find a public snapshot build, so I wasn’t able to run the full tests suite on a CI system against 6.2 SNAPSHOT. ( https://hibernate.atlassian.net/browse/HHH-16337#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16337#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16380) Avoid map-based mapping metamodel access when instantiating entity instances

by Marco Belladelli (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16255) Logging "Executing import script" when it's not being executed

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4725) @ObjectProjection(includeDepth = ...) or @ObjectProjection(includePaths = ...) to apply projection constructors up to a certain depth

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16337) EntityCollection is not deleted when replaced

by Alexander Schwartz (JIRA)

Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzI1NmVlMDgx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16337?atlOrigin=eyJpIjoiMzI1Nm... ) HHH-16337 ( https://hibernate.atlassian.net/browse/HHH-16337?atlOrigin=eyJpIjoiMzI1Nm... ) EntityCollection is not deleted when replaced ( https://hibernate.atlassian.net/browse/HHH-16337?atlOrigin=eyJpIjoiMzI1Nm... ) Change By: Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) For the Keycloak project, I was able to reproduce the following: * Run Hibernate 6.2.0.CR3 on Quarkus aka Bytecode enhanced * Load an entry with a collection (ElementCollection in our case) * Replace the collection with a new collection * Run an unrelated query to trigger an autoflush test -> this will initialize a CollectionEntry with ignore=true, so it will be ignored throughout this session * commit Expected result: Only new entries are in the database Actual Result: Old and new entries are now in the database, als the old entries haven't been deleted. This problem doesn’t occur when bytecode enhancement is not used. Reproducer test case: [https://github.com/ahus1/hibernate-test-case-templates/tree/is-HHH-xxxx-e...] Keycloak issue: [https://github.com/keycloak/keycloak/issues/19162|https://github.com/keyc...] ( https://hibernate.atlassian.net/browse/HHH-16337#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16337#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16381) Hibernate inheritance using mapped superclass JPA query issue

by amit mahajan (JIRA)

amit mahajan ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOGZjNTkyZGI4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16381?atlOrigin=eyJpIjoiOGZjNT... ) HHH-16381 ( https://hibernate.atlassian.net/browse/HHH-16381?atlOrigin=eyJpIjoiOGZjNT... ) Hibernate inheritance using mapped superclass JPA query issue ( https://hibernate.atlassian.net/browse/HHH-16381?atlOrigin=eyJpIjoiOGZjNT... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-core, metamodel, query-hql Created: 27/Mar/2023 06:30 AM Environment: Spring boot 3, JPA Labels: JPA SQM inheritance spring-boot Priority: Major Reporter: amit mahajan ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Original estimate: 64h Remaining Estimate: 64h JPA queries involving MappedSuperclass are failing in latest Hibernate or Spring Boot 3 projects.The same worked fine in Spring boot 2 or Hibernate 5. *Steps to reproduce:* 1. Create Mapped Superclass inheritance using XML in spring boot 3 project. 2. Create Jpa repository for base type. 3. Create JPA Query having Base class attributes GitHub steps: * Checkout repository https://github.com/amitmahajanus/relationbook.git ( https://github.com/amitmahajanus/relationbook.git ) * run below command in the terminal in the project directory * mvn clean package * mvn spring-boot:run * compare the results after changing spring boot version to 2 and adding javax instead of jakarta dependencies. *Root cause:* The SQM fails to find parent class attributes and project fails to load/run. The same works fine with Spring Boot 2 or Hibernate 5 project. *Impact:* * Requiring to implement JpaRepository for each sub type and do lots of boiler plate code (querying sub type tables combining data and filtering) * Spring Boot 3 upgrade or Hibernate 6 upgrade / migration will fail. Attacing a sample project github link ( https://github.com/amitmahajanus/relationbook.git ) https://github.com/amitmahajanus/relationbook.git ( https://github.com/amitmahajanus/relationbook.git ). Please compare spring boot 2 and spring boot 3 (having hibernate 5 and 6 respectively) ( https://hibernate.atlassian.net/browse/HHH-16381#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16381#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

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

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-1182) excludePaths on indexedEmbedded

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-1359) Geo-distance aggregation

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4542) .within() and .withinAny() for the range predicate

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-3654) Upgrade to JUnit 5

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4674) Move to Testcontainers to start Elasticsearch/OpenSearch/databases/etc.

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-1182) excludePaths on indexedEmbedded

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-1359) Geo-distance aggregation

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4811) Automated code formatting

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4542) .within() and .withinAny() for the range predicate

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

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

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4815) Provide a user with a meaningful error when Fast Vector Highlighter is used on a field without term vectors

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4788) Fix some out-of-date javadoc for configuration properties

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-3654) Upgrade to JUnit 5

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-168) Ability to disable automatic indexing programmatically, ideally per-index, at the application level (all sessions)

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-1383) Ability to disable automatic indexing programmatically at the session level

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-2192) Highlighting in the Search API

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4674) Move to Testcontainers to start Elasticsearch/OpenSearch/databases/etc.

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16368) UnsupportedOperationException: compare() not implemented for EntityType

by Andrea Boriero (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16378) SQM fails to resolve target type of association defined in mappersuperclass with generics

by Marco Belladelli (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16343) Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16343 ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiZmIzOT... ) Re: Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiZmIzOT... ) I also reported that issue. The only thing that I need is to capture the Object[] state But now switching to PostLoadEvent , I wouldn’t need the state not being null in the preload. Of course, you’ll need to see if that makes sense or not within hibernate design for the preload. ( https://hibernate.atlassian.net/browse/HHH-16343#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16343#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16343) Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState

by Marco Belladelli (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16343) Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16343 ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiODU3ZT... ) Re: Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiODU3ZT... ) Yes that would be better IMO, closing this for now but let us know if there’s anything to add to this topic. PS: I’ll be looking into your other issue about the pre-load event.getState() method returning null in HIbernate 6. ( https://hibernate.atlassian.net/browse/HHH-16343#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16343#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16343) Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16343 ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiNjE5ND... ) Re: Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiNjE5ND... ) Ok, thanks. On hibernate 5 the PreLoadEvent always had the Object[] state and that's why I was using it. Switching to PostLoadEvent , I can obtain the Object[] state using event.getPersister().getValues(event.getEntity()) and I assume the PostLoadEvent will never have an uninitialized proxy. ( https://hibernate.atlassian.net/browse/HHH-16343#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16343#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function st_extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2M1ODEwZmU2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiN2M1OD... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiN2M1OD... ) PostGIS function st_extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiN2M1OD... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent. Entity/Repository: {code:java}@Entity @Table(name = "geometry_entity") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByJPQL(); @Query(value = "select st_extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByST_PrefixedFunctionName(); @Query(value = "select st_extent(the_geom) from geometry_entity", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); }{code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_... extent AND st_extent should work. I have three different queries, two of them are using JPQL, the other one is written native. None of them work, all results in an error. The attempt to call {{ getExtentByHQLQuery getExtentByJPQL }}() results in: {noformat}2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a]{noformat} The attempt to call {{getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: {noformat}org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} Just as a side note, using st_envelope instead of st_extent works on JPQL queries, using a native query ends up with same {{ConverterNotFoundException}} I get by using st_extent. * spring-boot:3.0.4 * hibernate-spatial:6.1.7 * postgres/postgis:15-3.3 Test case to reproduce the error: [https://github.com/marcozet/spring-boot-3-hibernate-spatial|https://githu...] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16343) Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16343 ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiMTExMW... ) Re: Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiMTExMW... ) No, the pre-load would not be called again when initializing a proxy. In fact, using *pre* -load to capture the loaded state is not correct, the entity will never be “loaded” at this point since this event is called before (pre) loading. For that purpose I’d suggest using Hibernate’s PostLoadEvent or even the @PostLoad JPA lifecycle callback ( https://jakarta.ee/specifications/persistence/3.1/jakarta-persistence-spe... ) method annotation on the entity class itself. ( https://hibernate.atlassian.net/browse/HHH-16343#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16343#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16343) Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16343 ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiZTAzZW... ) Re: Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiZTAzZW... ) Thanks. I’m using the PreLoadEventListener to capture the loaded state. I could ignore the non initialized proxy entities, but my question is: when this proxy is initialized, would it then call the preload listener again with the loaded state? Because I just want to guarantee that I capture the loaded state when it gets loaded. ( https://hibernate.atlassian.net/browse/HHH-16343#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16343#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function st_extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzYzY2UzNDRi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiYzYzY2... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiYzYzY2... ) PostGIS function st_extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiYzYzY2... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent. Entity/Repository: {code:java}@Entity @Table(name = "geometry_entity") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByHQLQuery getExtentByJPQL (); @Query(value = "select st_extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByST_PrefixedFunctionName(); @Query(value = "select st_extent(the_geom) from geometry_entity", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); }{code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_... extent AND st_extent should work. I have three different queries, two of them are using HQL JPQL , the other one is written native. None of them work, all results in an error. The attempt to call {{getExtentByHQLQuery}}() results in: {noformat}2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a]{noformat} The attempt to call {{getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: {noformat}org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} Just as a side note, using st_envelope instead of st_extent works on HQL JPQL queries, using a native query ends up with same {{ConverterNotFoundException}} I get by using st_extent. * spring-boot:3.0.4 * hibernate-spatial:6.1.7 * postgres/postgis:15-3.3 Test case to reproduce the error: [https://github.com/marcozet/spring-boot-3-hibernate-spatial|https://githu...] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16380) Avoid map-based mapping metamodel access when instantiating entity instances

by Marco Belladelli (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16380) Avoid map-based mapping metamodel access when instantiating entity instances

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjBhNjZkMWQw... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16380?atlOrigin=eyJpIjoiZjBhNj... ) HHH-16380 ( https://hibernate.atlassian.net/browse/HHH-16380?atlOrigin=eyJpIjoiZjBhNj... ) Avoid map-based mapping metamodel access when instantiating entity instances ( https://hibernate.atlassian.net/browse/HHH-16380?atlOrigin=eyJpIjoiZjBhNj... ) Issue Type: Improvement Assignee: Unassigned Created: 27/Mar/2023 03:58 AM Priority: Major Reporter: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) We can avoid accessing the mapping metamodel’s entity persister map by entity name when instantiating entities since we already have the concrete EntityPersister , see AbstractEntityInitializer#instantiateEntity. ( https://hibernate.atlassian.net/browse/HHH-16380#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16380#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function st_extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGUzYjY0Nzgw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiMGUzYj... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiMGUzYj... ) PostGIS function st_extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiMGUzYj... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent. Entity/Repository: {code:java}@Entity @Table(name = "geometry_entity") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByHQLQuery(); @Query(value = "select st_extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByST_PrefixedFunctionName(); @Query(value = "select st_extent(the_geom) from geometry_entity", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); }{code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_... extent AND st_extent should work. I have three different queries, two of them are using HQL, the other one is written native. None of them work, all results in an error. The attempt to call {{getExtentByHQLQuery}}() results in: {noformat}2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a]{noformat} The attempt to call {{getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: {noformat}org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} Just as a side note, using st_envelope instead of st_extent works on HQL queries, using a native query ends up with same {{ConverterNotFoundException}} I get by using st_extent. * spring-boot:3.0.4 * hibernate-spatial:6.1.7 * postgres/postgis:15-3.3 Simple app Test case to reproduce the error: [https://github.com/marcozet/spring-boot-3-hibernate-spatial|https://githu...] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16379) @DynamicUpdate and 'enableDirtyTracking=true' leads to wrong update statement

by Holger Bach (JIRA)

Holger Bach ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=642158a... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmEzMDcwMzUw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16379?atlOrigin=eyJpIjoiYmEzMD... ) HHH-16379 ( https://hibernate.atlassian.net/browse/HHH-16379?atlOrigin=eyJpIjoiYmEzMD... ) @DynamicUpdate and 'enableDirtyTracking=true' leads to wrong update statement ( https://hibernate.atlassian.net/browse/HHH-16379?atlOrigin=eyJpIjoiYmEzMD... ) Change By: Holger Bach ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=642158a... ) When updating an derived entity containing several field, not all changed fields will be updated Having a base entity containing two fields named *checksum* and *variantName* and a derived entity containing one field named *fileSize*. Create an database entry, {noformat}FileVersion version = new FileVersion(); version.setId("1"); version.setFileSize(100L); version.setCheckSumMD5("ABCDEF"); version.setVariantName("A");{noformat} change all fields of the existing database entry (see testcase *testWithDynamicUpdate*) {noformat}version.setCheckSumMD5("XXXXXXXX"); version.setVariantName("B"); version.setFileSize(200L);{noformat} The following update statement will be created {noformat}Hibernate: update Versionen set CHECKSUM=?, FILESIZE=? where VERS_NUMMER=?{noformat} Only *checksum* and *fileSize* will be updated, but not the field *variantName*. Problem occurs in file *AbstractEntityPersister* in function *resolveDirtyAttributeIndexes*. The dirty fields will be sorted bei name {noformat}Arrays.sort( attributeNames ); attributeName = {checkSum, fileSize, variantName}{noformat} In the for loop the fields in *attributeNames* will be compared to the array *attributeMappings*, which contains the mapping informations according to the annotations. *attributeMappings* has the following order: {noformat}attributeMappings = { AbstarctVersion AbstractVersion.checksum, AbstractVersion.variantName, FileVersion.fileSize}{noformat} The for loop does only recognize the fields *checksum* and *fileSize. variantName* will not be processed. A sample project with test case can be found [here|https://github.com/HoBa1975/hibernate-mapping] ( https://hibernate.atlassian.net/browse/HHH-16379#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16379#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16379) @DynamicUpdate and 'enableDirtyTracking=true' leads to wrong update statement

by Holger Bach (JIRA)

Holger Bach ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=642158a... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2VkMmYzMDc5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16379?atlOrigin=eyJpIjoiN2VkMm... ) HHH-16379 ( https://hibernate.atlassian.net/browse/HHH-16379?atlOrigin=eyJpIjoiN2VkMm... ) @DynamicUpdate and 'enableDirtyTracking=true' leads to wrong update statement ( https://hibernate.atlassian.net/browse/HHH-16379?atlOrigin=eyJpIjoiN2VkMm... ) Change By: Holger Bach ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=642158a... ) When updating an derived entity containing several field, not all changed fields will be updated Having a base entity containing two fields named *checksum* and *variantName* and a derived entity containing one field named *fileSize*. Create an database entry, {noformat}FileVersion version = new FileVersion(); version.setId("1"); version.setFileSize(100L); version.setCheckSumMD5("ABCDEF"); version.setVariantName("A");{noformat} change all fields of the existing database entry (see testcase *testWithDynamicUpdate*) {noformat}version.setCheckSumMD5("XXXXXXXX"); version.setVariantName("B"); version.setFileSize(200L);{noformat} The following update statement will be created {noformat}Hibernate: update Versionen set CHECKSUM=?, FILESIZE=? where VERS_NUMMER=?{noformat} Only *checksum* and *fileSize* will be updated, but not the field *variantName*. Problem occurs in file *AbstractEntityPersister* in function *resolveDirtyAttributeIndexes*. ch The dirty fields will be sorted bei name {noformat}Arrays.sort( attributeNames ); attributeName = {checkSum, fileSize, variantName}{noformat} In the for loop the fields in *attributeNames* will be compared to the array *attributeMappings*, which contains the mapping informations according to the annotations. *attributeMappings* has the following order: {noformat}attributeMappings = {AbstarctVersion.checksum, AbstractVersion.variantName, FileVersion.fileSize}{noformat} The for loop does only recognize the fields *checksum* and *fileSize. variantName* will not be processed. A sample project with test case can be found [here|https://github.com/HoBa1975/hibernate-mapping] ( https://hibernate.atlassian.net/browse/HHH-16379#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16379#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16379) @DynamicUpdate and 'enableDirtyTracking=true' leads to wrong update statement

by Holger Bach (JIRA)

Holger Bach ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=642158a... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjhlNWZiMmY2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16379?atlOrigin=eyJpIjoiMjhlNW... ) HHH-16379 ( https://hibernate.atlassian.net/browse/HHH-16379?atlOrigin=eyJpIjoiMjhlNW... ) @DynamicUpdate and 'enableDirtyTracking=true' leads to wrong update statement ( https://hibernate.atlassian.net/browse/HHH-16379?atlOrigin=eyJpIjoiMjhlNW... ) Issue Type: Bug Affects Versions: 6.0.2, 6.1.7 Assignee: Unassigned Components: hibernate-orm-modules Created: 27/Mar/2023 03:28 AM Environment: Java 17 Priority: Major Reporter: Holger Bach ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=642158a... ) When updating an derived entity containing several field, not all changed fields will be updated Having a base entity containing two fields named *checksum* and *variantName* and a derived entity containing one field named *fileSize*. Create an database entry, FileVersion version = new FileVersion(); version.setId("1"); version.setFileSize(100L); version.setCheckSumMD5("ABCDEF"); version.setVariantName("A"); change all fields of the existing database entry (see testcase *testWithDynamicUpdate* ) version.setCheckSumMD5("XXXXXXXX"); version.setVariantName("B"); version.setFileSize(200L); The following update statement will be created Hibernate: update Versionen set CHECKSUM=?, FILESIZE=? where VERS_NUMMER=? Only *checksum* and *fileSize* will be updated, but not the field *variantName*. Problem occurs in file *AbstractEntityPersister* in function *resolveDirtyAttributeIndexes*. ch The dirty fields will be sorted bei name Arrays.sort( attributeNames ); attributeName = {checkSum, fileSize, variantName} In the for loop the fields in *attributeNames* will be compared to the array *attributeMappings* , which contains the mapping informations according to the annotations. *attributeMappings* has the following order: attributeMappings = {AbstarctVersion.checksum, AbstractVersion.variantName, FileVersion.fileSize} The for loop does only recognize the fields *checksum* and *fileSize. variantName* will not be processed. A sample project with test case can be found here ( https://github.com/HoBa1975/hibernate-mapping ) ( https://hibernate.atlassian.net/browse/HHH-16379#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16379#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16378) SQM fails to resolve target type of association defined in mappersuperclass with generics

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16378 ( https://hibernate.atlassian.net/browse/HHH-16378?atlOrigin=eyJpIjoiNDc0YW... ) Re: SQM fails to resolve target type of association defined in mappersuperclass with generics ( https://hibernate.atlassian.net/browse/HHH-16378?atlOrigin=eyJpIjoiNDc0YW... ) Here’s a reproducer: https://github.com/hibernate/hibernate-orm/pull/6296 ( https://github.com/hibernate/hibernate-orm/pull/6296 ) And the same on 5.6 (doesn’t fail): https://github.com/hibernate/hibernate-orm/pull/6297 ( https://github.com/hibernate/hibernate-orm/pull/6297 ) ( https://hibernate.atlassian.net/browse/HHH-16378#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16378#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function st_extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzZiZWE1ZjAy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiNzZiZW... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiNzZiZW... ) PostGIS function st_extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiNzZiZW... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent. Entity/Repository: {code:java}@Entity @Table(name = "geometry_entity") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByHQLQuery(); @Query(value = "select st_extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByST_PrefixedFunctionName(); @Query(value = "select st_extent(the_geom) from geometry_entity", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); }{code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_... extent AND st_extent should work when using HQL queries. I have three different queries, two of them are using HQL, the other one is written native. None of them work, all results in an error. The attempt to call {{getExtentByHQLQuery}}() results in: {noformat}2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a]{noformat} The attempt to call {{getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: {noformat}org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} Just as a side note, using st_envelope instead of st_extent works on HQL queries, using a native query ends up with same {{ConverterNotFoundException}} I get by using st_extent. * spring-boot:3.0.4 * hibernate-spatial:6.1.7 * postgres/postgis:15-3.3 Simple app to reproduce the error: [https://github.com/marcozet/spring-boot-3-hibernate-spatial|https://githu...] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16378) SQM fails to resolve target type of association defined in mappersuperclass with generics

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWZhNTBhZWYw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16378?atlOrigin=eyJpIjoiMWZhNT... ) HHH-16378 ( https://hibernate.atlassian.net/browse/HHH-16378?atlOrigin=eyJpIjoiMWZhNT... ) SQM fails to resolve target type of association defined in mappersuperclass with generics ( https://hibernate.atlassian.net/browse/HHH-16378?atlOrigin=eyJpIjoiMWZhNT... ) Issue Type: Bug Assignee: Unassigned Components: hibernate-core Created: 27/Mar/2023 03:12 AM Fix Versions: 6.2.0 Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) This is a regression compared to Hibernate ORM 5.6. I confirmed it affects 6.2.0.CR4, but it probably also affects 6.0 and 6.1. Queries involving an association defined in a mappersuperclass with generics will fail, even though generics are correctly resolved and understood in the mapping phase. The exception: org.hibernate.query.sqm.InterpretationException: Error interpreting query [from Child where parent.id = :parentId]; this may indicate a semantic (user query) problem or a bug in the parser [from Child where parent.id = :parentId] at org.hibernate.query.hql.internal.StandardHqlTranslator.translate(StandardHqlTranslator.java:97) at org.hibernate.internal.AbstractSharedSessionContract.lambda$interpretHql$2(AbstractSharedSessionContract.java:735) 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:732) at org.hibernate.internal.AbstractSharedSessionContract.interpretAndCreateSelectionQuery(AbstractSharedSessionContract.java:709) at org.hibernate.internal.AbstractSharedSessionContract.createSelectionQuery(AbstractSharedSessionContract.java:761) at org.hibernate.orm.test.bytecode.enhancement.association.GenericAssociationTest.lambda$testMerge$1(GenericAssociationTest.java:40) at org.hibernate.testing.transaction.TransactionUtil2.inTransaction(TransactionUtil2.java:96) at org.hibernate.testing.transaction.TransactionUtil2.lambda$inTransaction$0(TransactionUtil2.java:76) at org.hibernate.testing.transaction.TransactionUtil2.inSession(TransactionUtil2.java:35) at org.hibernate.testing.transaction.TransactionUtil2.inTransaction(TransactionUtil2.java:74) at org.hibernate.testing.junit4.BaseCoreFunctionalTestCase.inTransaction(BaseCoreFunctionalTestCase.java:555) at org.hibernate.orm.test.bytecode.enhancement.association.GenericAssociationTest.testMerge(GenericAssociationTest.java:39) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:45) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: java.lang.IllegalArgumentException: org.hibernate.query.SemanticException: Could not resolve attribute 'id' of 'java.lang.Object' at org.hibernate.query.sqm.SqmPathSource.getSubPathSource(SqmPathSource.java:61) at org.hibernate.query.sqm.tree.domain.AbstractSqmPath.get(AbstractSqmPath.java:167) at org.hibernate.query.sqm.tree.domain.SqmEntityValuedSimplePath.resolvePathPart(SqmEntityValuedSimplePath.java:55) at org.hibernate.query.hql.internal.DomainPathPart.resolvePathPart(DomainPathPart.java:42) at org.hibernate.query.hql.internal.BasicDotIdentifierConsumer.consumeIdentifier(BasicDotIdentifierConsumer.java:91) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitSimplePath(SemanticQueryBuilder.java:5179) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitIndexedPathAccessFragment(SemanticQueryBuilder.java:5126) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitGeneralPathFragment(SemanticQueryBuilder.java:5095) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitGeneralPathExpression(SemanticQueryBuilder.java:1723) at org.hibernate.grammars.hql.HqlParser$GeneralPathExpressionContext.accept(HqlParser.java:7590) at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46) at org.hibernate.grammars.hql.HqlParserBaseVisitor.visitBarePrimaryExpression(HqlParserBaseVisitor.java:720) at org.hibernate.grammars.hql.HqlParser$BarePrimaryExpressionContext.accept(HqlParser.java:7064) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitComparisonPredicate(SemanticQueryBuilder.java:2427) 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.visitWhereClause(SemanticQueryBuilder.java:2271) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitWhereClause(SemanticQueryBuilder.java:253) at org.hibernate.grammars.hql.HqlParser$WhereClauseContext.accept(HqlParser.java:5910) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitQuery(SemanticQueryBuilder.java:1161) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitQuerySpecExpression(SemanticQueryBuilder.java:937) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitQuerySpecExpression(SemanticQueryBuilder.java:253) at org.hibernate.grammars.hql.HqlParser$QuerySpecExpressionContext.accept(HqlParser.java:1818) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitSimpleQueryGroup(SemanticQueryBuilder.java:931) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitSimpleQueryGroup(SemanticQueryBuilder.java:253) at org.hibernate.grammars.hql.HqlParser$SimpleQueryGroupContext.accept(HqlParser.java:1711) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitSelectStatement(SemanticQueryBuilder.java:418) at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitStatement(SemanticQueryBuilder.java:377) at org.hibernate.query.hql.internal.SemanticQueryBuilder.buildSemanticModel(SemanticQueryBuilder.java:295) at org.hibernate.query.hql.internal.StandardHqlTranslator.translate(StandardHqlTranslator.java:81) ... 28 more Caused by: org.hibernate.query.SemanticException: Could not resolve attribute 'id' of 'java.lang.Object' ... 58 more The query: session.createQuery( "from Child where parent.id = :parentId", Child.class ) .setParameter( "parentId", 1L ) .list() The model: @Entity(name = "Parent") public static class Parent { @Id private Long id; public Parent() { } public Parent(Long id) { this.id = id; } public Long getId() { return this.id; } public void setId(Long id) { this.id = id; } } @MappedSuperclass public abstract static class AbstractChild<T> { @OneToOne(optional = false) private T parent; public AbstractChild() { } public abstract Long getId(); public T getParent() { return this.parent; } public void setParent(T parent) { this.parent = parent; } } @Entity(name = "Child") public static class Child extends AbstractChild<Parent> { @Id protected Long id; public Child() { } public Child(Long id) { this.id = id; } @Override public Long getId() { return this.id; } public void setId(Long id) { this.id = id; } } I will provide a PR with a test case for both 5.6 and 6.2 in the comments. ( https://hibernate.atlassian.net/browse/HHH-16378#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16378#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16377) LocalTime not saved correctly in MSSQL

by Davide D'Alto (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16377) LocalTime not saved correctly in MSSQL

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjQ5OTRlMGY1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16377?atlOrigin=eyJpIjoiNjQ5OT... ) HHH-16377 ( https://hibernate.atlassian.net/browse/HHH-16377?atlOrigin=eyJpIjoiNjQ5OT... ) LocalTime not saved correctly in MSSQL ( https://hibernate.atlassian.net/browse/HHH-16377?atlOrigin=eyJpIjoiNjQ5OT... ) Change By: Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Here’s the simple test case for an entity Flour: {code:java} @Test public void test() { final Flour rose = new Flour( 2, "Rose", "made from ground rose pedals.", "Full fragrance" ); rose.setLocalTime( LocalTime.MAX ); try (Session ormSession = ormFactory.openSession()) { ormSession.beginTransaction(); ormSession.persist( rose ); ormSession.getTransaction().commit(); } try (Session ormSession = ormFactory.openSession()) { Flour flour = ormSession.find( Flour.class, rose.id ); Assertions.assertThat( rose.localTime ).isEqualToIgnoringSeconds( flour.localTime ); } } {code} {code:java} @Entity(name = "Flour") @Table(name = "Flour") public static class Flour { @Id private Integer id; private String name; private String description; private String type; private LocalTime localTime; public Flour() { } public Flour(Integer id, String name, String description, String type) { this.id = id; this.name = name; this.description = description; this.type = type; } ... }{code} The error: {noformat}Expecting actual: 23:59:59.999999999 to have same hour and minute as: 13:46:39 but had not. java.lang.AssertionError: Expecting actual: 23:59:59.999999999 to have same hour and minute as: 13:46:39 but had not. {noformat} I’m using the following image: {noformat}podman run --rm -it --name HibernateTestingMSSQL -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=~!HReact!~' -p 1433:1433 mcr.microsoft.com/mssql/server:2022-latest{noformat} Note that it works with ORM 5.6.14.Final ( https://hibernate.atlassian.net/browse/HHH-16377#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16377#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16377) LocalTime not saved correctly in MSSQL

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjRlN2E1OTNj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16377?atlOrigin=eyJpIjoiZjRlN2... ) HHH-16377 ( https://hibernate.atlassian.net/browse/HHH-16377?atlOrigin=eyJpIjoiZjRlN2... ) LocalTime not saved correctly in MSSQL ( https://hibernate.atlassian.net/browse/HHH-16377?atlOrigin=eyJpIjoiZjRlN2... ) Issue Type: Bug Assignee: Unassigned Created: 27/Mar/2023 03:05 AM Priority: Major Reporter: Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Here’s the simple test case for an entity Flour: @Test public void test() { final Flour rose = new Flour( 2, "Rose" , "made from ground rose pedals." , "Full fragrance" ); rose.setLocalTime( LocalTime.MAX ); try (Session ormSession = ormFactory.openSession()) { ormSession.beginTransaction(); ormSession.persist( rose ); ormSession.getTransaction().commit(); } try (Session ormSession = ormFactory.openSession()) { Flour flour = ormSession.find( Flour.class, rose.id ); Assertions.assertThat( rose.localTime ).isEqualToIgnoringSeconds( flour.localTime ); } } @Entity(name = "Flour" ) @Table(name = "Flour" ) public static class Flour { @Id private Integer id; private String name; private String description; private String type; private LocalTime localTime; public Flour() { } public Flour( Integer id, String name, String description, String type) { this.id = id; this.name = name; this.description = description; this.type = type; } ... } The error: Expecting actual: 23:59:59.999999999 to have same hour and minute as: 13:46:39 but had not. java.lang.AssertionError: Expecting actual: 23:59:59.999999999 to have same hour and minute as: 13:46:39 but had not. I’m using the following image: podman run --rm -it --name HibernateTestingMSSQL -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=~!HReact!~' -p 1433:1433 mcr.microsoft.com/mssql/server:2022-latest ( https://hibernate.atlassian.net/browse/HHH-16377#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16377#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function st_extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGIxNDA1Yjg1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiMGIxND... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiMGIxND... ) PostGIS function st_extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiMGIxND... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent in HQL queries. Entity/Repository: {code:java}@Entity @Table(name = "geometry_entity") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByHQLQuery(); @Query(value = "select st_extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByST_PrefixedFunctionName(); @Query(value = "select st_extent(the_geom) from geometry_entity", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); }{code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_... extent AND st_extent should work when using HQL queries. I have three different queries, two of them are using HQL, the other one is written native. None of them work, all results in an error. The attempt to call {{getExtentByHQLQuery}}() results in: {noformat}2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a]{noformat} The attempt to call {{getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: {noformat}org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} Just as a side note, using st_envelope instead of st_extent works on HQL queries, using a native query ends up with same {{ConverterNotFoundException}} I get by using st_extent. * spring-boot:3.0.4 * hibernate-spatial:6.1.7 * postgres/postgis:15-3.3 Simple app to reproduce the error: [https://github.com/marcozet/spring-boot-3-hibernate-spatial|https://githu...] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16343) Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16343 ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiN2Y2N2... ) Re: Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState ( https://hibernate.atlassian.net/browse/HHH-16343?atlOrigin=eyJpIjoiN2Y2N2... ) Hello Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) and thank you for reporting the issue. The cause of the error you’re encountering is the same as we discussed in https://hibernate.atlassian.net/browse/HHH-16254 ( https://hibernate.atlassian.net/browse/HHH-16254 ) : the getEntity() method in your pre-load event is returning a proxy}}ed entity (needed for handling caching+batching associations). This, in turn, causes the {{Hibernate.getClass() method to trigger an initialization of the proxy, that leads to the pre-load event being called again with the same proxy, causing an infinite recursion loop. We’re exploring the possibility of not using a proxy in this particular case, but since it’s always possible to obtain one in a pre-load event I’d strongly suggest handling this case correctly. You could, for example, avoid forcing initialization by checking Hibernate.isInitialized( event.getEntity() ) first. ( https://hibernate.atlassian.net/browse/HHH-16343#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16343#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16376) Paginated results for AS400

by Nico (JIRA)

Nico ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a2a370... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjQ2NjllNjRm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16376?atlOrigin=eyJpIjoiYjQ2Nj... ) HHH-16376 ( https://hibernate.atlassian.net/browse/HHH-16376?atlOrigin=eyJpIjoiYjQ2Nj... ) Paginated results for AS400 ( https://hibernate.atlassian.net/browse/HHH-16376?atlOrigin=eyJpIjoiYjQ2Nj... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-core Created: 27/Mar/2023 02:54 AM Priority: Major Reporter: Nico ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a2a370... ) For a query paginated on AS400 via the getResultList method in org.hibernate.query.Query, I see the right paging values in limit object in the org.hibernate.sql.ast.spi.AbstractSqlAstTranslator but the method needsMawRows() called in the method getMaxRows() returns hardly false. So paging values are not used to build the query and pagination does not work properly. Workaround found: I override the AbstractSqlAstTranslator to return true in getMaxRows() method. ( https://hibernate.atlassian.net/browse/HHH-16376#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16376#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16254) Session load by pk returns proxy in association when using "batch fetch size", "cache", "fetch mode select", "single table inheritance"

by Marco Belladelli (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (OGM-1586) Enverse: Wrong Auditing of @ManyToMany or ElementCollection Fileds

by Abdullah B. Shahen (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16350) PreLoadEvent listeners might receive PreLoadEvent with null state

by Marco Belladelli (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function st_extent(geometry) does not work

by Marco Zühlke (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiODg2NmZhNTNl... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiODg2Nm... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiODg2Nm... ) PostGIS function extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiODg2Nm... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent in HQL queries. Entity/Repository: {code:java}@Entity @Table(name = " field geometry_entity ") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByHQLQuery(); @Query(value = "select st_extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByST_PrefixedFunctionName(); @Query(value = "select st_extent(the_geom) from field geometry_entity ", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); }{code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_... extent AND st_extent should work when using HQL queries. I have three different queries, two of them are using HQL, the other one is written native. None of them work, all results in an error. The attempt to call {{getExtentByHQLQuery}}() results in: {noformat}2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a]{noformat} The attempt to call {{getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: {noformat}org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} * spring-boot:3.0.4 * hibernate-spatial:6.1.7 * postgres/postgis:15-3.3 Simple app to reproduce the error: [https://github.com/marcozet/spring-boot-3-hibernate-spatial|https://githu...] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjIxN2JmYTQ3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiYjIxN2... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiYjIxN2... ) PostGIS function extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiYjIxN2... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent in HQL queries. Entity/Repository: {code:java}@Entity @Table(name = "field") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByHQLQuery(); @Query(value = "select st_extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByST_PrefixedFunctionName(); @Query(value = "select st_extent(the_geom) from field", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); }{code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_... extent AND st_extent should work when using HQL queries. I have three different queries, two of them are using HQL, the other one is written native. None of them work, all results in an error. The attempt to call {{getExtentByHQLQuery}}() results in: {noformat}2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a]{noformat} The attempt to call {{getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: {noformat}org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} * spring-boot:3.0.4 * postgres/postgis * hibernate-spatial:6.1.7 * postgres/postgis:15-3.3 Simple app to reproduce the error: [https://github.com/marcozet/spring-boot-3-hibernate-spatial|https://githu...] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function extent(geometry) does not work

by Marco Zühlke (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOGM0Mzk1NjRl... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiOGM0Mz... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiOGM0Mz... ) PostGIS function extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiOGM0Mz... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent in HQL queries. Entity/Repository: {code:java}@Entity @Table(name = "field") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByHQLQuery(); @Query(value = "select st_extent(geometry) from GeometryEntity") Optional<Polygon> getExtentByST_PrefixedFunctionName(); @Query(value = "select st_extent(the_geom) from field", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); }{code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_...] using extent and AND st_extent should work when using HQL queries. I have three different queries, two of them are using HQL, the other one is written native. None of them work, all results in an error. The attempt to call {{getExtentByHQLQuery}}() results in: {noformat}2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a]{noformat} The attempt to call {{getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: {noformat}org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} * spring-boot:3.0.4 * postgres/postgis * hibernate-spatial:6.1.7 Simple app to reproduce the error: [https://github.com/marcozet/spring-boot-3-hibernate-spatial|https://githu...] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function extent(geometry) does not work

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjUzYWE1MjJi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiYjUzYW... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiYjUzYW... ) PostGIS function extent(geometry) does not work ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiYjUzYW... ) Change By: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent in HQL queries. Entity/Repository: {code:java} @Entity @Table(name = "field") @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid") @GenericGenerator(name = "system-uuid", strategy = "org.hibernate.id.UUIDGenerator") private UUID id; @Column(name = "the_geom") private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity") Optional<Polygon> getExtent getExtentByHQLQuery (); @Query(value = "select envelope st_extent (geometry) from GeometryEntity") Optional<Polygon> getEnvelope getExtentByST_PrefixedFunctionName (); } @Query(value = "select st_extent(the_geom) from field", nativeQuery = true) Optional<Polygon> getExtentByNativeQuery(); } {code} According to the doc [https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_... and st_extent should work when using HQL queries. I have three different queries, two of them are using HQL, the other one is written native. None of them work, all results in an error. The attempt to call getExtent {{getExtentByHQLQuery}} () results in: {noformat} 2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a] {noformat} The attempt to call { {getExtentByST_PrefixedFunctionName}}() and {{getExtentByNativeQuery()}}results in: { noformat} org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [org.locationtech.jts.geom.Polygon] Using the st_envelope function works as expected at org. springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:322){noformat} - * spring-boot:3.0.4 - * postgres/postgis - * hibernate-spatial:6.1.7 Simple app to reproduce the error: [ https://github.com/marcozet/spring-boot-3-hibernate-spatial |https://github.com/marcozet/spring-boot-3-hibernate-spatial] ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function extent(geometry) does not work

by Marco Zühlke (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4826) Remove unused Maven plugins from the POM

by Yoann Rodière (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4825) Hibernate Search's dynamic templates are lost when using a custom mapping through schema_management.mapping_file

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiZmUzZmNh... ) / Bug ( https://hibernate.atlassian.net/browse/HSEARCH-4825?atlOrigin=eyJpIjoiZmU... ) HSEARCH-4825 ( https://hibernate.atlassian.net/browse/HSEARCH-4825?atlOrigin=eyJpIjoiZmU... ) Hibernate Search's dynamic templates are lost when using a custom mapping through schema_management.mapping_file ( https://hibernate.atlassian.net/browse/HSEARCH-4825?atlOrigin=eyJpIjoiZmU... ) Issue Type: Bug Assignee: Unassigned Components: backend-elasticsearch Created: 27/Mar/2023 01:48 AM Fix Versions: 6.2.0.Beta1 Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) See https://stackoverflow.com/questions/75806530/hibernate-search-6-trying-to... ( https://stackoverflow.com/questions/75806530/hibernate-search-6-trying-to... ) It seems the dynamic_templates section was dropped as soon as the developer set hibernate.search.schema_management.mapping_file. While it seems reasonable to ignore most of Hibernate Search’s generated mapping when using a custom mapping (it’s too complex to do merging smartly), I think dynamic_templates should be retained if it’s not mentioned in the custom mapping, because it’s complex to get right manually, and because it’s similar to properties , which we decided to merge. I wouldn’t merge dynamic_templates , though: just use the one from the custom mapping if it exists, otherwise use Hibernate Search’s auto-generated one. Similarly, we should probably preserve dynamic}}and {{routing in RootTypeMapping (without trying to merge them: just use the custom one or fall back to Hibernate Search’s generated one) . People wanting to override those can do so easily. In short, I would: * Override org.hibernate.search.backend.elasticsearch.lowlevel.index.mapping.impl.AbstractTypeMapping#merge in RootTypeMapping * Implement RootTypeMapping#merge this way: * Call super() to merge properties as before (no change there) * For other mapping attributes, uses the custom value if defined, falling back to Hibernate Search’s. * Do *not* change anything for PropertyMapping#merge (no override, no handling of non-`properties` mapping attributes: no change there) We’ll need to update the documentation to reflect those changes: https://docs.jboss.org/hibernate/stable/search/reference/en-US/html_singl... ( https://docs.jboss.org/hibernate/stable/search/reference/en-US/html_singl... ) ( https://hibernate.atlassian.net/browse/HSEARCH-4825#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4825#add-comment?atlOrigin... ) 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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HV-1943) Some french validation messages are not quite accurate

by Maelig Gohin (JIRA)

Maelig Gohin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a5a7df... ) *updated* an issue Hibernate Validator ( https://hibernate.atlassian.net/browse/HV?atlOrigin=eyJpIjoiNGZhZmE4ZDRiM... ) / Improvement ( https://hibernate.atlassian.net/browse/HV-1943?atlOrigin=eyJpIjoiNGZhZmE4... ) HV-1943 ( https://hibernate.atlassian.net/browse/HV-1943?atlOrigin=eyJpIjoiNGZhZmE4... ) Some french validation messages are not quite accurate ( https://hibernate.atlassian.net/browse/HV-1943?atlOrigin=eyJpIjoiNGZhZmE4... ) Change By: Maelig Gohin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a5a7df... ) Some validation messages are not correct in french (or not “perfect“). And sometimes there were two whitespaces. Here are changes to make (I’ve done a pull request requests for versions 6, 7 and 8 ) * {color:#ff991f}before{color} * {color:#36b37e}after{color} * {color:#ff991f}doit être inférieur à ou égal à 100{color} * {color:#36b37e}doit être inférieur ou égal à 100{color} * {color:#ff991f}doit être supérieur à ou égal à 100{color} * {color:#36b37e}doit être supérieur ou égal à 100{color} * {color:#ff991f}doit être plus court que ou égal à 3 secondes{color} * {color:#36b37e}doit être plus court ou égal à 3 secondes{color} * {color:#ff991f}doit être plus long que ou égal à 1 seconde{color} * {color:#36b37e}doit être plus long ou égal à 1 seconde{color} ( https://hibernate.atlassian.net/browse/HV-1943#add-comment?atlOrigin=eyJp... ) Add Comment ( https://hibernate.atlassian.net/browse/HV-1943#add-comment?atlOrigin=eyJp... ) 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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function extent(geometry) does not exist

by Marco Zühlke (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4801) Upgrade build dependencies to the latest version in Search 6.2.0.Beta1

by Marko Bekhta (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HSEARCH-4824) Detect ValueBridge applied to composite objects and warn or fix the dependency model

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiY2NiYTlj... ) / Improvement ( https://hibernate.atlassian.net/browse/HSEARCH-4824?atlOrigin=eyJpIjoiY2N... ) HSEARCH-4824 ( https://hibernate.atlassian.net/browse/HSEARCH-4824?atlOrigin=eyJpIjoiY2N... ) Detect ValueBridge applied to composite objects and warn or fix the dependency model ( https://hibernate.atlassian.net/browse/HSEARCH-4824?atlOrigin=eyJpIjoiY2N... ) Issue Type: Improvement Assignee: Unassigned Components: mapper-pojo-base Created: 27/Mar/2023 00:07 AM Fix Versions: 7.x-backlog Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) See here: https://discourse.hibernate.org/t/tried-to-implement-associationinversesi... ( https://discourse.hibernate.org/t/tried-to-implement-associationinversesi... ) @Embedded @AttributeOverride( name = "data", column = @Column(name = "name", columnDefinition = "TEXT") ) @FullTextField( projectable = Projectable.NO, searchable = Searchable.YES, analyzer = "customAnalyzer", valueBridge = @ValueBridgeRef(type = LocalizedFieldBridge.class) ) private LocalizedField name; This will lead to problems since, depending on how ORM sends us change events, reindexing may only happen when name changes, not when name.english changes for example. We should: * Warn about such misuses on startup. * Try to fix such misuses by automatically registering dependencies to name.english , etc. if the content of the composite object doesn’t include any entity (i.e. it encompasses a tree, not a graph). Maybe in that casse we shouldn’t produce a warning an just consider it fair use? ( https://hibernate.atlassian.net/browse/HSEARCH-4824#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4824#add-comment?atlOrigin... ) 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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16375) java.lang.ClassCastException when using @Enumerated(STRING) with length=1 on varchar column

by Erwan Leroux (JIRA)

Erwan Leroux ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6218b52... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGUzMDk1ZTY1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16375?atlOrigin=eyJpIjoiNGUzMD... ) HHH-16375 ( https://hibernate.atlassian.net/browse/HHH-16375?atlOrigin=eyJpIjoiNGUzMD... ) java.lang.ClassCastException when using @Enumerated(STRING) with length=1 on varchar column ( https://hibernate.atlassian.net/browse/HHH-16375?atlOrigin=eyJpIjoiNGUzMD... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-core Created: 26/Mar/2023 08:21 AM Environment: Tested on java 17 and Spring Boot 3.0.5 Priority: Major Reporter: Erwan Leroux ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6218b52... ) After upgrading to Spring Boot 3 and Hibernate 6, I have a use case not working about an enum : @Column(name = "way", length = 1) @Enumerated(EnumType.STRING) private Way way; // Forward(Aller in french), Backward(Retour in french) public enum Way {A,R} CREATE TABLE working ( id VARCHAR PRIMARY KEY NOT NULL, way VARCHAR(1) ); It throws this exception : Expecting code not to raise a throwable but caught "org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction ... at fr.elendar.hibernate_enum_mvce.repository.EntityClassNotWorkingRepositoryTest.lambda$test_ko$0(EntityClassNotWorkingRepositoryTest.java:22) at org.assertj.core.api.ThrowableAssert.catchThrowable(ThrowableAssert.java:63) at org.assertj.core.api.AssertionsForClassTypes.catchThrowable(AssertionsForClassTypes.java:892) at org.assertj.core.api.AssertionsForClassTypes.assertThatCode(AssertionsForClassTypes.java:863) at org.assertj.core.api.Assertions.assertThatCode(Assertions.java:1287) at fr.elendar.hibernate_enum_mvce.repository.EntityClassNotWorkingRepositoryTest.test_ko(EntityClassNotWorkingRepositoryTest.java:18) ... Caused by: jakarta.persistence.RollbackException: Error while committing the transaction at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:83) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:104) at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:561) ... 104 more Caused by: java.lang.ClassCastException: class java.lang. String cannot be cast to class java.lang. Character (java.lang. String and java.lang. Character are in module java.base of loader 'bootstrap' ) at org.hibernate.type.descriptor.java.CharacterJavaType.unwrap(CharacterJavaType.java:20) at org.hibernate.type.descriptor.jdbc.VarcharJdbcType$1.doBind(VarcharJdbcType.java:97) at org.hibernate.type.descriptor.jdbc.BasicBinder.bind(BasicBinder.java:63) ... ... 105 more I debugged it to this class and commit : https://github.com/hibernate/hibernate-orm/commit/2f8f04747b5a4555836d5b7... ( https://github.com/hibernate/hibernate-orm/commit/2f8f04747b5a4555836d5b7... ) and was told on Zulip Chat ( https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user/topi... ) to create a bug here. I made a reproducer here ( https://github.com/ErwanLeroux/hibernate_enum_mvce ) , the test case in EntityClassNotWorkingRepositoryTest.java ( https://github.com/ErwanLeroux/hibernate_enum_mvce/blob/main/src/test/jav... ) is failling and show the exception. I hope it’s enough, I tried to make a test case directly in hibernate-core and submit a PR, but I lacked enough knownleged to make it work 🙂 ( https://hibernate.atlassian.net/browse/HHH-16375#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16375#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16374) Use tuple comparison for FK join

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTk4ZDVlOThh... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16374?atlOrigin=eyJpIjoiNTk4ZD... ) HHH-16374 ( https://hibernate.atlassian.net/browse/HHH-16374?atlOrigin=eyJpIjoiNTk4ZD... ) Use tuple comparison for FK join ( https://hibernate.atlassian.net/browse/HHH-16374?atlOrigin=eyJpIjoiNTk4ZD... ) Issue Type: Improvement Assignee: Unassigned Created: 26/Mar/2023 04:43 AM Fix Versions: 6.wishlist Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Would be nice to use tuple comparison in the SQL AST for the join predicate of associations, so that we can render that into SQL when supported by the DB. It’s shorter and IMO easier to read. For DBs that don’t support this, we emulate this through chaining x1=y1 and ... anyway, so this is safe. ( https://hibernate.atlassian.net/browse/HHH-16374#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16374#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16373) NPE when trying to marshal null AccessType in JaxbEntityMappings

by Ilia Basin (JIRA)

Ilia Basin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjgzZmUwNGVk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16373?atlOrigin=eyJpIjoiYjgzZm... ) HHH-16373 ( https://hibernate.atlassian.net/browse/HHH-16373?atlOrigin=eyJpIjoiYjgzZm... ) NPE when trying to marshal null AccessType in JaxbEntityMappings ( https://hibernate.atlassian.net/browse/HHH-16373?atlOrigin=eyJpIjoiYjgzZm... ) Change By: Ilia Basin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I used {{hibernate.transform_hbm_xml.enabled}} to convert a legacy {{.hbm.xml}} to the modern format and then tried to dump it as XML to standard output. I used {{org.glassfish.jaxb:jaxb-runtime:4.0.2}} {code:java}JaxbEntityMappings obj = ... jaxbContext = JAXBContext.newInstance(JaxbEntityMappings.class); final Marshaller marshaller = jaxbContext.createMarshaller(); marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, Boolean.TRUE); marshaller.marshal(obj, System.out);{code} Got this error: { \{noformat} } Caused by: java.lang.NullPointerException at org.hibernate.boot.jaxb.mapping.marshall.AccessTypeMarshalling.toXml(AccessTypeMarshalling.java:22) at org.hibernate.boot.jaxb.mapping.Adapter1.marshal(Adapter1.java:17) at org.hibernate.boot.jaxb.mapping.Adapter1.marshal(Adapter1.java:7) at org.glassfish.jaxb.runtime.v2.runtime.reflect.AdaptedAccessor.get(AdaptedAccessor.java:46) ... 23 more { \{noformat} } Same problem with the class {{FetchTypeMarshalling}} I think a null check is needed in {{toXml()}} ( https://hibernate.atlassian.net/browse/HHH-16373#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16373#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16373) NPE when trying to marshal null AccessType in JaxbEntityMappings

by Ilia Basin (JIRA)

Ilia Basin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjQ3N2NiMjIw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16373?atlOrigin=eyJpIjoiZjQ3N2... ) HHH-16373 ( https://hibernate.atlassian.net/browse/HHH-16373?atlOrigin=eyJpIjoiZjQ3N2... ) NPE when trying to marshal null AccessType in JaxbEntityMappings ( https://hibernate.atlassian.net/browse/HHH-16373?atlOrigin=eyJpIjoiZjQ3N2... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Created: 26/Mar/2023 02:15 AM Priority: Major Reporter: Ilia Basin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I used hibernate.transform_hbm_xml.enabled to convert a legacy.hbm.xml to the modern format and then tried to dump it as XML to standard output. I used org.glassfish.jaxb:jaxb-runtime:4.0.2 JaxbEntityMappings obj = ... jaxbContext = JAXBContext.newInstance(JaxbEntityMappings.class); final Marshaller marshaller = jaxbContext.createMarshaller(); marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, Boolean.TRUE); marshaller.marshal(obj, System.out); Got this error: noformat Caused by: java.lang.NullPointerException at org.hibernate.boot.jaxb.mapping.marshall.AccessTypeMarshalling.toXml(AccessTypeMarshalling.java:22) at org.hibernate.boot.jaxb.mapping.Adapter1.marshal(Adapter1.java:17) at org.hibernate.boot.jaxb.mapping.Adapter1.marshal(Adapter1.java:7) at org.glassfish.jaxb.runtime.v2.runtime.reflect.AdaptedAccessor.get(AdaptedAccessor.java:46) ... 23 more noformat Same problem with the class FetchTypeMarshalling I think a null check is needed in toXml() ( https://hibernate.atlassian.net/browse/HHH-16373#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16373#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-15968) Sporadic ClassCastException when querying for Set<Enum>.

by Usama Umar (JIRA)

Usama Umar ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=630df75... ) *commented* on HHH-15968 ( https://hibernate.atlassian.net/browse/HHH-15968?atlOrigin=eyJpIjoiMGM5OT... ) Re: Sporadic ClassCastException when querying for Set<Enum>. ( https://hibernate.atlassian.net/browse/HHH-15968?atlOrigin=eyJpIjoiMGM5OT... ) For now, at least with the Spring Data JPA, you can make that problem disappear using spEL {{((:# {#filterByRole == null} = true) OR role IN (:filterByRole))}} ( https://hibernate.atlassian.net/browse/HHH-15968#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15968#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16372) NPE in EmbeddedIdentifierMappingImpl#disassemble

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYWJjZmViNzM0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16372?atlOrigin=eyJpIjoiYWJjZm... ) HHH-16372 ( https://hibernate.atlassian.net/browse/HHH-16372?atlOrigin=eyJpIjoiYWJjZm... ) NPE in EmbeddedIdentifierMappingImpl#disassemble ( https://hibernate.atlassian.net/browse/HHH-16372?atlOrigin=eyJpIjoiYWJjZm... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Created: 25/Mar/2023 07:19 AM Fix Versions: 6.2.0 Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) There is an NPE when the passed value is null for org.hibernate.metamodel.mapping.internal.EmbeddedIdentifierMappingImpl#disassemble. I suppose other embeddable model parts might suffer from the same problem, but it should be easy to fix. ( https://hibernate.atlassian.net/browse/HHH-16372#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16372#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16371) Support enum storage for discriminator values

by Steve Ebersole (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16366) UnknownTableReferenceException when selecting entity using IdClass

by Robin De Mol (JIRA)

Robin De Mol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTE1OGM2YTdk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16366?atlOrigin=eyJpIjoiZTE1OG... ) HHH-16366 ( https://hibernate.atlassian.net/browse/HHH-16366?atlOrigin=eyJpIjoiZTE1OG... ) UnknownTableReferenceException when selecting entity using IdClass ( https://hibernate.atlassian.net/browse/HHH-16366?atlOrigin=eyJpIjoiZTE1OG... ) Change By: Robin De Mol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) See [ reproducer at |https://github. com/hibernate/hibernate-test-case-templates/pull/256]. Running the test yields: {noformat}org.hibernate.HibernateException: Could not generate fetch : foo.OrganisationUser(o) -> {id} at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.buildFetch(BaseSqmToSqlAstConverter.java:7460) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.createFetch(BaseSqmToSqlAstConverter.java:7289) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitIdentifierFetch(BaseSqmToSqlAstConverter.java:7137) at org.hibernate.sql.results.graph.entity.AbstractEntityResultGraphNode.afterInitialize(AbstractEntityResultGraphNode.java:63) at org.hibernate.persister.entity.AbstractEntityPersister.createDomainResult(AbstractEntityPersister.java:1217) at org.hibernate.query.sqm.sql.internal.AbstractSqmPathInterpretation.createDomainResult(AbstractSqmPathInterpretation.java:55) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.lambda$visitSelection$23(BaseSqmToSqlAstConverter.java:2241) at java.base/java.util.Collections$SingletonList.forEach(Collections.java:4966) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitSelection(BaseSqmToSqlAstConverter.java:2236) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitSelectClause(BaseSqmToSqlAstConverter.java:2154) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitQuerySpec(BaseSqmToSqlAstConverter.java:2022) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitQuerySpec(BaseSqmToSqlAstConverter.java:426) at org.hibernate.query.sqm.tree.select.SqmQuerySpec.accept(SqmQuerySpec.java:122) at org.hibernate.query.sqm.spi.BaseSemanticQueryWalker.visitQueryPart(BaseSemanticQueryWalker.java:221) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitQueryPart(BaseSqmToSqlAstConverter.java:1882) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitSelectStatement(BaseSqmToSqlAstConverter.java:1567) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitSelectStatement(BaseSqmToSqlAstConverter.java:426) at org.hibernate.query.sqm.tree.select.SqmSelectStatement.accept(SqmSelectStatement.java:222) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.translate(BaseSqmToSqlAstConverter.java:760) at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.buildCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:344) at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:267) at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:243) at org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:521) at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:367) at org.hibernate.query.sqm.internal.QuerySqmImpl.list(QuerySqmImpl.java:1084) at org.hibernate.query.Query.getResultList(Query.java:119) at org.hibernate.bugs.JPAUnitTestCase.UnknownTableReferenceException(JPAUnitTestCase.java:55) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63) at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.ParentRunner.run(ParentRunner.java:413) at org.junit.runner.JUnitCore.run(JUnitCore.java:137) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69) at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38) at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11) at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35) at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235) at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54) Caused by: org.hibernate.HibernateException: Could not generate fetch : foo.OrganisationUser(o).{id}(u) -> organisation at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.buildFetch(BaseSqmToSqlAstConverter.java:7460) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.createFetch(BaseSqmToSqlAstConverter.java:7289) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitFetches(BaseSqmToSqlAstConverter.java:7406) at org.hibernate.sql.results.graph.AbstractFetchParent.afterInitialize(AbstractFetchParent.java:32) at org.hibernate.sql.results.graph.embeddable.internal.EmbeddableFetchImpl.<init>(EmbeddableFetchImpl.java:75) at org.hibernate.metamodel.internal.AbstractCompositeIdentifierMapping.generateFetch(AbstractCompositeIdentifierMapping.java:114) at org.hibernate.sql.results.graph.FetchParent.generateFetchableFetch(FetchParent.java:108) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.buildFetch(BaseSqmToSqlAstConverter.java:7449) ... 55 more Caused by: org.hibernate.sql.ast.tree.from.UnknownTableReferenceException: Unable to determine TableReference (`ORGANISATION_USER`) for `foo.OrganisationUser(o).{id}(u).organisation.{fk}` at org.hibernate.sql.ast.tree.from.LazyTableGroup.resolveTableReference(LazyTableGroup.java:256) at org.hibernate.sql.ast.tree.from.DelegatingTableGroup.resolveTableReference(DelegatingTableGroup.java:62) at org.hibernate.metamodel.mapping.internal.SimpleForeignKeyDescriptor.createDomainResult(SimpleForeignKeyDescriptor.java:302) at org.hibernate.metamodel.mapping.internal.SimpleForeignKeyDescriptor.createDomainResult(SimpleForeignKeyDescriptor.java:251) at org.hibernate.metamodel.mapping.internal.ToOneAttributeMapping.generateFetch(ToOneAttributeMapping.java:1435) at org.hibernate.metamodel.mapping.internal.ToOneAttributeMapping.generateFetch(ToOneAttributeMapping.java:106) at org.hibernate.sql.results.graph.FetchParent.generateFetchableFetch(FetchParent.java:108) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.buildFetch(BaseSqmToSqlAstConverter.java:7449) ... 62 more{noformat} ( https://hibernate.atlassian.net/browse/HHH-16366#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16366#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16370) Using MapKey on ManyToMany leads to wrong insert SQL

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTljNWI5MTQx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16370?atlOrigin=eyJpIjoiZTljNW... ) HHH-16370 ( https://hibernate.atlassian.net/browse/HHH-16370?atlOrigin=eyJpIjoiZTljNW... ) Using MapKey on ManyToMany leads to wrong insert SQL ( https://hibernate.atlassian.net/browse/HHH-16370?atlOrigin=eyJpIjoiZTljNW... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Components: hibernate-core Created: 24/Mar/2023 12:02 PM Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) The model is: @Entity(name = "MapContainer" ) @Table(name = "map_container" ) public static class MapContainer { @Id private Long id; @ManyToMany @MapKey(name = "mapKey" ) private Map<MapKeyEntity, MapValueEntity> map = new HashMap<>(); public MapContainer() { } public MapContainer( Long id) { this.id = id; } } @Entity(name = "MapKeyEntity" ) @Table(name = "map_key_entity" ) public static class MapKeyEntity { @Id private Long id; public MapKeyEntity() { } public MapKeyEntity( Long id) { this.id = id; } } @Entity(name = "MapValueEntity" ) @Table(name = "map_value_entity" ) public static class MapValueEntity { @Id private Long id; @ManyToOne(optional = false ) private MapContainer mapContainer; @ManyToOne(optional = false ) @JoinColumn(unique = true ) private MapKeyEntity mapKey; public MapValueEntity() { } public MapValueEntity( Long id) { this.id = id; } } I don’t know if @MapKey makes sense here or what 5 did, but it worked before. ( https://hibernate.atlassian.net/browse/HHH-16370#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16370#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16365) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server

by Christian Beikov (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect foreign key column order for @OneToMany with multiple join columns and @IdClass

by Christian Beikov (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) PostGIS function extent(geometry) does not exist

by Marco Zühlke (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16369) function extent(geometry) does not exist

by Marco Zühlke (JIRA)

Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTYyMjM1YTU0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiMTYyMj... ) HHH-16369 ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiMTYyMj... ) function extent(geometry) does not exist ( https://hibernate.atlassian.net/browse/HHH-16369?atlOrigin=eyJpIjoiMTYyMj... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-spatial Created: 24/Mar/2023 10:42 AM Priority: Major Reporter: Marco Zühlke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f9220... ) I'm troubleshooting with an issue when using PostGIS function st_extent in HQL queries. Entity/Repository: @Entity @Table(name = "field" ) @Data public class GeometryEntity { @Id @GeneratedValue(generator = "system-uuid" ) @GenericGenerator(name = "system-uuid" , strategy = "org.hibernate.id.UUIDGenerator" ) private UUID id; @Column(name = "the_geom" ) private Polygon geometry; } public interface GeometryEntityRepository extends CrudRepository<GeometryEntity, UUID> { @Query(value = "select extent(geometry) from GeometryEntity" ) Optional<Polygon> getExtent(); @Query(value = "select envelope(geometry) from GeometryEntity" ) Optional<Polygon> getEnvelope(); } The attempt to call getExtent() results in: 2023-03-24T17:19:37.115+01:00 ERROR 456308 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: function extent(geometry) does not exist Hinweis: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [select extent(g1_0.the_geom) from field g1_0]; SQL [n/a] Using the st_envelope function works as expected. * spring-boot:3.0.4 * postgres/postgis * hibernate-spatial:6.1.7 Simple app to reproduce the error: https://github.com/marcozet/spring-boot-3-hibernate-spatial ( https://github.com/marcozet/spring-boot-3-hibernate-spatial ) ( https://hibernate.atlassian.net/browse/HHH-16369#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16369#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16368) UnsupportedOperationException: compare() not implemented for EntityType

by Alexander Schwartz (JIRA)

Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTc4NTY3MmY4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16368?atlOrigin=eyJpIjoiNTc4NT... ) HHH-16368 ( https://hibernate.atlassian.net/browse/HHH-16368?atlOrigin=eyJpIjoiNTc4NT... ) UnsupportedOperationException: compare() not implemented for EntityType ( https://hibernate.atlassian.net/browse/HHH-16368?atlOrigin=eyJpIjoiNTc4NT... ) Change By: Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) An example from migrating from H5 to H6 for Keycloak. This happens with Hibernate 6.2.CR4, and used to work with Hibernate 5: * In Quarkus, the default is hibernate.order_updates is set to true in FastBootMetadataBuilder * Given updating two entities with a compsite key / IdClass which references its parent entity, it tries to compare the EntityKey, which fails in H6, but worked in H5 * On flush, the comparison fails with the exception shown below when Hibernate tries to sort the updates There is a reproducer here: [https://github.com/ahus1/hibernate-test-case-templates/tree/is-HHH-xxxx-c...] Discussed on the Zulip chat here: [https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user|http...] Keycloak issue: [https://github.com/keycloak/keycloak/issues/19321|https://github.com/keyc...] {noformat}java.lang.UnsupportedOperationException: compare() not implemented for EntityType at org.hibernate.type.EntityType.compare(EntityType.java:255) at org.hibernate.type.ComponentType.compare(ComponentType.java:215) at org.hibernate.type.Type.compare(Type.java:222) at org.hibernate.action.internal.EntityAction.compareTo(EntityAction.java:160) at org.hibernate.action.internal.EntityAction.compareTo(EntityAction.java:28) at org.hibernate.engine.spi.ExecutableList.add(ExecutableList.java:225) at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:311) at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:353) at org.hibernate.event.internal.DefaultFlushEntityEventListener.scheduleUpdate(DefaultFlushEntityEventListener.java:252) at org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:143) 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.flush(SessionImpl.java:1398) at org.hibernate.bugs.ORMUnitTestCase.hhh123Test(ORMUnitTestCase.java:115){noformat} ( https://hibernate.atlassian.net/browse/HHH-16368#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16368#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16368) UnsupportedOperationException: compare() not implemented for EntityType

by Alexander Schwartz (JIRA)

Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjExYTEyOTEz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16368?atlOrigin=eyJpIjoiMjExYT... ) HHH-16368 ( https://hibernate.atlassian.net/browse/HHH-16368?atlOrigin=eyJpIjoiMjExYT... ) UnsupportedOperationException: compare() not implemented for EntityType ( https://hibernate.atlassian.net/browse/HHH-16368?atlOrigin=eyJpIjoiMjExYT... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Components: hibernate-core Created: 24/Mar/2023 10:29 AM Priority: Major Reporter: Alexander Schwartz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6267ec4... ) An example from migrating from H5 to H6 for Keycloak. This happens with Hibernate 6.2.CR4, and used to work with Hibernate 5: * In Quarkus, the default is hibernate.order_updates is set to true in FastBootMetadataBuilder * Given updating two entities with a compsite key / IdClass which references its parent entity, it tries to compare the EntityKey, which fails in H6, but worked in H5 * On flush, the comparison fails with the exception shown below when Hibernate tries to sort the updates There is a reproducer here: https://github.com/ahus1/hibernate-test-case-templates/tree/is-HHH-xxxx-c... ( https://github.com/ahus1/hibernate-test-case-templates/tree/is-HHH-xxxx-c... ) Discussed on the Zulip chat here: https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user ( https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user ) java.lang.UnsupportedOperationException: compare() not implemented for EntityType at org.hibernate.type.EntityType.compare(EntityType.java:255) at org.hibernate.type.ComponentType.compare(ComponentType.java:215) at org.hibernate.type.Type.compare(Type.java:222) at org.hibernate.action.internal.EntityAction.compareTo(EntityAction.java:160) at org.hibernate.action.internal.EntityAction.compareTo(EntityAction.java:28) at org.hibernate.engine.spi.ExecutableList.add(ExecutableList.java:225) at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:311) at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:353) at org.hibernate.event.internal.DefaultFlushEntityEventListener.scheduleUpdate(DefaultFlushEntityEventListener.java:252) at org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:143) 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.flush(SessionImpl.java:1398) at org.hibernate.bugs.ORMUnitTestCase.hhh123Test(ORMUnitTestCase.java:115) ( https://hibernate.atlassian.net/browse/HHH-16368#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16368#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16337) EntityCollection is not deleted when replaced

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16337 ( https://hibernate.atlassian.net/browse/HHH-16337?atlOrigin=eyJpIjoiZmE3ZD... ) Re: EntityCollection is not deleted when replaced ( https://hibernate.atlassian.net/browse/HHH-16337?atlOrigin=eyJpIjoiZmE3ZD... ) As we plan to release 6.2 Final next week, the sooner you can validate this fix the better. Thanks! ( https://hibernate.atlassian.net/browse/HHH-16337#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16337#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16281) Inconsistent Behaivor of L2 cache between Hibernate 5 and 6

by Christian Beikov (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16334) Persisting and loading an entity with a null all-delete-orphan collection results in error

by Christian Beikov (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16319) H6: Problem with order insert to table with batch is ON

by Danilov Roman (JIRA)

Danilov Roman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HHH-16319 ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiYzg2Zm... ) Re: H6: Problem with order insert to table with batch is ON ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiYzg2Zm... ) In the process of testing the solutions that were described here, another problem appeared: https://hibernate.atlassian.net/browse/HHH-16367 ( https://hibernate.atlassian.net/browse/HHH-16367 ) ( https://hibernate.atlassian.net/browse/HHH-16319#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16319#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16367) H6: Problem with flush and batch is ON

by Danilov Roman (JIRA)

Danilov Roman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNWQ5NTQ4YjUz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16367?atlOrigin=eyJpIjoiNWQ5NT... ) HHH-16367 ( https://hibernate.atlassian.net/browse/HHH-16367?atlOrigin=eyJpIjoiNWQ5NT... ) H6: Problem with flush and batch is ON ( https://hibernate.atlassian.net/browse/HHH-16367?atlOrigin=eyJpIjoiNWQ5NT... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Attachments: hibernate-orm-6.zip Components: hibernate-core Created: 24/Mar/2023 07:32 AM Priority: Major Reporter: Danilov Roman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) Hello. I have two entites: @Entity @DynamicUpdate @Table(name = "laterals") public class Lateral extends Well implements Serializable { @Column(name = "id", insertable = false, updatable = false, nullable = false, columnDefinition = "serial") @Generated(GenerationTime.INSERT) public Long id; public Long diameter; public Long diameter1; public String paka1; public String paka2; } and @Entity @DynamicUpdate @Table(name = "wells") @Inheritance(strategy = InheritanceType.JOINED) public class Well { @Id public UUID uuid; public String name; public String name1; public String name2; public long gui1; public long gui2; } And when first we select one Lateral , String hql = "from `Lateral` where uuid = ?1"; Query query = entityManager.createQuery(hql); query.setParameter(1, uuid); Lateral lateral = (Lateral) query.getSingleResult(); In the console showed select request. select * from laterals ... Then we are begining to change element’s params: lateral.setName("TEST2"); lateral.setName1("TEST12"); Then we make another any select request: String hql2 = "from Well where uuid = ?1"; Query query2 = entityManager.createQuery(hql2); query2.setParameter(1, uuid); Object object = query2.getSingleResult(); In the console we see update query (with two changed params) and second select query: update wells set name=?, name1=? where uuid=? select * from wells ... Then we are changing more parameters and do persist and flush: lateral.setDiameter(55L); lateral.setDiameter1(55L); lateral.setPaka1("PAKA1"); lateral.setPaka1("PAKA2"); lateral.setName("TEST3"); lateral.setName1("TEST13"); lateral.setName2("TEST23"); lateral.setGui1(111L); lateral.setGui2(222L); entityManager.persist(lateral); entityManager.flush(); And In the console we see update query (with *two* *old params* ) and error: update wells set name=?, name1=? where uuid=? 2023-03-24 18:21:13 TRACE bind:28 - binding parameter [1] as [BIGINT] - [111] 2023-03-24 18:21:13 TRACE bind:28 - binding parameter [2] as [BIGINT] - [222] 2023-03-24 18:21:13 TRACE bind:28 - binding parameter [3] as [VARCHAR] - [TEST3] 2023-03-24 18:21:13 TRACE bind:28 - binding parameter [4] as [VARCHAR] - [TEST13] 2023-03-24 18:21:13 WARN SqlExceptionHelper:145 - SQL Error: 90008, SQLState: 90008 2023-03-24 18:21:13 ERROR SqlExceptionHelper:150 - Invalid value "4" for parameter "parameterIndex" [90008-214] 1) It turns out that before the second select request the makes a flush although I didn't call him? 2) and after my flush it makes the old update request but with new list of parameters. Without “batch” everything works without errors (and on hibernate 5 too). Test cases attached. ( https://hibernate.atlassian.net/browse/HHH-16367#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16367#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-304) Subselect fetching with setMaxResults()

by Ivan Stanic (JIRA)

Ivan Stanic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5eadd5a... ) *commented* on HHH-304 ( https://hibernate.atlassian.net/browse/HHH-304?atlOrigin=eyJpIjoiOTg3NTU5... ) Re: Subselect fetching with setMaxResults() ( https://hibernate.atlassian.net/browse/HHH-304?atlOrigin=eyJpIjoiOTg3NTU5... ) Hi Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , Sorry for late reply. I think that adding some config that would control this behavior is way to go, and by default it would not be applicable. I see that there are following options: * Introduce 2 options, one to apply the limit to subquery, another to check for correspondence of data. With this setup one who uses SNAPSHOT or SERIALIZABLE transaction isolation levels can go with true and false, and the one who uses READ_COMMITED can go with true and true options. SUBQUERY_APPLY_LIMIT SUBQUERY_CHECK_CORRESPONDENCE SNAPSHOT or SERIALIZABLE true false READ_COMMITED true true With this parametrization we would avoid additional correspondence check if not necessary. If SUBQUERY_CHECK_CORRESPONDENCE is true, and some data is found that does not belong here than another query can be executed with no limit option. 2. Introduce only SUBQUERY_APPLY_LIMIT and always check for correspondence. This would introduce some not needed check in case of transactions levels SNAPSHOT or SERIALIZABLE 3. Introduce only SUBQUERY_APPLY_LIMIT and never check for correspondence by default. This should be followed with some documentation that this should be used only if transaction isolation levels are SNAPSHOT or SERIALIZABLE 4. Do not use any options, always apply limit and always check for correspondence. I am in favor of the option 1 as the one with the most flexibility but other options are fine as well. Regards, Ivan ( https://hibernate.atlassian.net/browse/HHH-304#add-comment?atlOrigin=eyJp... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-304#add-comment?atlOrigin=eyJp... ) 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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16337) EntityCollection is not deleted when replaced

by Steve Ebersole (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16097) Move all tests from documentation into hibernate-core

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *resolved* as *Fixed* Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjg3MzA3Y2Q5... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-16097?atlOrigin=eyJpIjoiZjg3Mz... ) HHH-16097 ( https://hibernate.atlassian.net/browse/HHH-16097?atlOrigin=eyJpIjoiZjg3Mz... ) Move all tests from documentation into hibernate-core ( https://hibernate.atlassian.net/browse/HHH-16097?atlOrigin=eyJpIjoiZjg3Mz... ) Change By: Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Resolution: Fixed Status: Open Resolved ( https://hibernate.atlassian.net/browse/HHH-16097#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16097#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16097) Move all tests from documentation into hibernate-core

by Steve Ebersole (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16339) Consolidate DiscriminatorType, DiscriminatorMetadata, MetadataTpe

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmVjNmIyMGRh... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16339?atlOrigin=eyJpIjoiYmVjNm... ) HHH-16339 ( https://hibernate.atlassian.net/browse/HHH-16339?atlOrigin=eyJpIjoiYmVjNm... ) Consolidate DiscriminatorType, DiscriminatorMetadata, MetadataTpe ( https://hibernate.atlassian.net/browse/HHH-16339?atlOrigin=eyJpIjoiYmVjNm... ) Change By: Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) At the moment, Hibernate is using a mix of new and legacy descriptors for mapping entity discriminators. The legacy contracts include: * {{org.hibernate.persister.entity.DiscriminatorMetadata}} * {{org.hibernate.persister.entity.DiscriminatorType}} * {{org.hibernate.type.MetaType}} The corresponding new runtime mapping contract is: * {{org.hibernate.metamodel.mapping.EntityDiscriminatorMapping}} * {{org.hibernate.metamodel.mapping.internal.AnyDiscriminatorPart}} Much of the consolidation happens through the shared converter - {{org.hibernate.metamodel.mapping.DiscriminatorConverter}} ( https://hibernate.atlassian.net/browse/HHH-16339#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16339#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16339) Consolidate DiscriminatorType, DiscriminatorMetadata, MetadataTpe

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYTQxMTc3Njgx... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16339?atlOrigin=eyJpIjoiYTQxMT... ) HHH-16339 ( https://hibernate.atlassian.net/browse/HHH-16339?atlOrigin=eyJpIjoiYTQxMT... ) Consolidate DiscriminatorType, DiscriminatorMetadata, MetadataTpe ( https://hibernate.atlassian.net/browse/HHH-16339?atlOrigin=eyJpIjoiYTQxMT... ) Change By: Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) At the moment, Hibernate is using a mix of new and legacy descriptors for mapping entity discriminators. The legacy contracts include: * {{org.hibernate.persister.entity.DiscriminatorMetadata}} * {{org.hibernate.persister.entity.DiscriminatorType}} * {{org.hibernate.type.MetaType}} The corresponding new runtime mapping contract is: * {{org.hibernate.metamodel.mapping.EntityDiscriminatorMapping}} * {{org.hibernate.metamodel.mapping.internal.AnyDiscriminatorPart}} ( https://hibernate.atlassian.net/browse/HHH-16339#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16339#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#100219- sha1:ac3e918 )

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16357) Clean up EntityPersister and CollectionPersister state

by Steve Ebersole (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16366) UnknownTableReferenceException when selecting entity using IdClass

by Robin De Mol (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16366) UnknownTableReferenceException when selecting entity using IdClass

by Robin De Mol (JIRA)

3 years, 2 months

1
0
0 / 0

[JIRA] (HHH-16343) Batch Fetch Size + PreLoadEventListener + Polymorphic Entity with cache enabled could lead to IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16366) UnknownTableReferenceException when selecting entity using IdClass

by Robin De Mol (JIRA)

Robin De Mol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16366 ( https://hibernate.atlassian.net/browse/HHH-16366?atlOrigin=eyJpIjoiZWIyZG... ) Re: UnknownTableReferenceException when selecting entity using IdClass ( https://hibernate.atlassian.net/browse/HHH-16366?atlOrigin=eyJpIjoiZWIyZG... ) I’ve created PR https://github.com/hibernate/hibernate-test-case-templates/pull/256/files ( https://github.com/hibernate/hibernate-test-case-templates/pull/256/files ) with a reproducer for the issue. ( https://hibernate.atlassian.net/browse/HHH-16366#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16366#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#100219- sha1:ac3e918 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16366) UnknownTableReferenceException when selecting entity using IdClass

by Robin De Mol (JIRA)

Robin De Mol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNDVkMDdlZmMw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16366?atlOrigin=eyJpIjoiNDVkMD... ) HHH-16366 ( https://hibernate.atlassian.net/browse/HHH-16366?atlOrigin=eyJpIjoiNDVkMD... ) UnknownTableReferenceException when selecting entity using IdClass ( https://hibernate.atlassian.net/browse/HHH-16366?atlOrigin=eyJpIjoiNDVkMD... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Components: hibernate-orm-modules Created: 24/Mar/2023 05:00 AM Priority: Major Reporter: Robin De Mol ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) See reproducer at . Running the test yields: org.hibernate.HibernateException: Could not generate fetch : foo.OrganisationUser(o) -> {id} at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.buildFetch(BaseSqmToSqlAstConverter.java:7460) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.createFetch(BaseSqmToSqlAstConverter.java:7289) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitIdentifierFetch(BaseSqmToSqlAstConverter.java:7137) at org.hibernate.sql.results.graph.entity.AbstractEntityResultGraphNode.afterInitialize(AbstractEntityResultGraphNode.java:63) at org.hibernate.persister.entity.AbstractEntityPersister.createDomainResult(AbstractEntityPersister.java:1217) at org.hibernate.query.sqm.sql.internal.AbstractSqmPathInterpretation.createDomainResult(AbstractSqmPathInterpretation.java:55) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.lambda$visitSelection$23(BaseSqmToSqlAstConverter.java:2241) at java.base/java.util.Collections$SingletonList.forEach(Collections.java:4966) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitSelection(BaseSqmToSqlAstConverter.java:2236) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitSelectClause(BaseSqmToSqlAstConverter.java:2154) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitQuerySpec(BaseSqmToSqlAstConverter.java:2022) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitQuerySpec(BaseSqmToSqlAstConverter.java:426) at org.hibernate.query.sqm.tree.select.SqmQuerySpec.accept(SqmQuerySpec.java:122) at org.hibernate.query.sqm.spi.BaseSemanticQueryWalker.visitQueryPart(BaseSemanticQueryWalker.java:221) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitQueryPart(BaseSqmToSqlAstConverter.java:1882) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitSelectStatement(BaseSqmToSqlAstConverter.java:1567) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitSelectStatement(BaseSqmToSqlAstConverter.java:426) at org.hibernate.query.sqm.tree.select.SqmSelectStatement.accept(SqmSelectStatement.java:222) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.translate(BaseSqmToSqlAstConverter.java:760) at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.buildCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:344) at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:267) at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:243) at org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:521) at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:367) at org.hibernate.query.sqm.internal.QuerySqmImpl.list(QuerySqmImpl.java:1084) at org.hibernate.query.Query.getResultList(Query.java:119) at org.hibernate.bugs.JPAUnitTestCase.UnknownTableReferenceException(JPAUnitTestCase.java:55) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63) at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) at org.junit.runners.ParentRunner.run(ParentRunner.java:413) at org.junit.runner.JUnitCore.run(JUnitCore.java:137) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69) at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38) at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11) at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35) at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235) at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54) Caused by: org.hibernate.HibernateException: Could not generate fetch : foo.OrganisationUser(o).{id}(u) -> organisation at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.buildFetch(BaseSqmToSqlAstConverter.java:7460) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.createFetch(BaseSqmToSqlAstConverter.java:7289) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.visitFetches(BaseSqmToSqlAstConverter.java:7406) at org.hibernate.sql.results.graph.AbstractFetchParent.afterInitialize(AbstractFetchParent.java:32) at org.hibernate.sql.results.graph.embeddable.internal.EmbeddableFetchImpl.<init>(EmbeddableFetchImpl.java:75) at org.hibernate.metamodel.internal.AbstractCompositeIdentifierMapping.generateFetch(AbstractCompositeIdentifierMapping.java:114) at org.hibernate.sql.results.graph.FetchParent.generateFetchableFetch(FetchParent.java:108) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.buildFetch(BaseSqmToSqlAstConverter.java:7449) ... 55 more Caused by: org.hibernate.sql.ast.tree.from.UnknownTableReferenceException: Unable to determine TableReference (`ORGANISATION_USER`) for `foo.OrganisationUser(o).{id}(u).organisation.{fk}` at org.hibernate.sql.ast.tree.from.LazyTableGroup.resolveTableReference(LazyTableGroup.java:256) at org.hibernate.sql.ast.tree.from.DelegatingTableGroup.resolveTableReference(DelegatingTableGroup.java:62) at org.hibernate.metamodel.mapping.internal.SimpleForeignKeyDescriptor.createDomainResult(SimpleForeignKeyDescriptor.java:302) at org.hibernate.metamodel.mapping.internal.SimpleForeignKeyDescriptor.createDomainResult(SimpleForeignKeyDescriptor.java:251) at org.hibernate.metamodel.mapping.internal.ToOneAttributeMapping.generateFetch(ToOneAttributeMapping.java:1435) at org.hibernate.metamodel.mapping.internal.ToOneAttributeMapping.generateFetch(ToOneAttributeMapping.java:106) at org.hibernate.sql.results.graph.FetchParent.generateFetchableFetch(FetchParent.java:108) at org.hibernate.query.sqm.sql.BaseSqmToSqlAstConverter.buildFetch(BaseSqmToSqlAstConverter.java:7449) ... 62 more ( https://hibernate.atlassian.net/browse/HHH-16366#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16366#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#100219- sha1:ac3e918 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16365) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjkwYTZkMmMw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiZjkwYT... ) HHH-16365 ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiZjkwYT... ) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiZjkwYT... ) Change By: Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Entity example: {code:java} @Entity(name = "Flour") @Table(name = "Flour") public static class Flour { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; ... }{code} and setting {noformat}hibernate.jdbc.use_get_generated_keys = false{noformat} will produce the following invalid query with Sql Server: {code:sql}insert into Flour (description,name,type) values (?,?,?) returning id{code} instead of ( ORM 5.6.14) {code:sql}insert into Flour (description, name, type) values (?, ?, ?) select scope_identity(){code} or {code:sql}insert into Flour (description, name, type) output inserted.id values (?, ?, ?){code} Note that using the output syntax will also fix the issue for Hibernate Reactive ( https://hibernate.atlassian.net/browse/HHH-16365#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16365#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#100219- sha1:ac3e918 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16365) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjI1YjhlZTQ5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiZjI1Yj... ) HHH-16365 ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiZjI1Yj... ) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiZjI1Yj... ) Change By: Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Entity example: {code:java} @Entity(name = "Flour") @Table(name = "Flour") public static class Flour { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; ... }{code} and setting {noformat}hibernate.jdbc.use_get_generated_keys = false{noformat} It will produce the following invalid query with Sql Server: {code:sql}insert into Flour (description,name,type) values (?,?,?) returning id{code} instead of ( ORM 5.6.14) {code:sql}insert into Flour (description, name, type) values (?, ?, ?) select scope_identity(){code} or {code:sql}insert into Flour (description, name, type) output inserted.id values (?, ?, ?){code} ( https://hibernate.atlassian.net/browse/HHH-16365#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16365#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#100219- sha1:ac3e918 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16365) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTFlYzMzOTJh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiMTFlYz... ) HHH-16365 ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiMTFlYz... ) Wrong insert identity query generated when disabling use_get_generated_keys with Sql Server ( https://hibernate.atlassian.net/browse/HHH-16365?atlOrigin=eyJpIjoiMTFlYz... ) Issue Type: Bug Assignee: Unassigned Created: 24/Mar/2023 03:44 AM Priority: Major Reporter: Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Entity example: @Entity(name = "Flour" ) @Table(name = "Flour" ) public static class Flour { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; ... } and setting hibernate.jdbc.use_get_generated_keys = false It will produce the following invalid query with Sql Server: insert into Flour (description, name , type ) values (?,?,?) returning id instead of ( ORM 5.6.14) insert into Flour (description, name , type ) values (?, ?, ?) select scope_identity() or insert into Flour (description, name , type ) output inserted.id values (?, ?, ?) ( https://hibernate.atlassian.net/browse/HHH-16365#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16365#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#100219- sha1:ac3e918 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16353) Make it possible for Hibernate Reactive to override the creation of AttributeMapping and Fetch strategies

by Davide D'Alto (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16353) Make it possible for Hibernate Reactive to override the creation of AttributeMapping and Fetch strategies

by Davide D'Alto (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16353) Make it possible for Hibernate Reactive to override the creation of AttributeMapping and Fetch strategies

by Davide D'Alto (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16353) Make it possible for Hibernate Reactive to override the creation of AttributeMapping and Fetch strategies

by Davide D'Alto (JIRA)

Davide D'Alto ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16353 ( https://hibernate.atlassian.net/browse/HHH-16353?atlOrigin=eyJpIjoiOWIwZm... ) Re: Make it possible for Hibernate Reactive to override the creation of AttributeMapping and Fetch strategies ( https://hibernate.atlassian.net/browse/HHH-16353?atlOrigin=eyJpIjoiOWIwZm... ) Merged in 6.2 and main branches ( https://hibernate.atlassian.net/browse/HHH-16353#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16353#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#100219- sha1:ac3e918 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16353) Make it possible for Hibernate Reactive to override the creation of AttributeMapping and Fetch strategies

by Davide D'Alto (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16248) Problem with batching and inheritance with @ManyToOne mapped in multiple subclasses

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16248) Problem with batching and inheritance with @ManyToOne mapped in multiple subclasses

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4822) Extend @FullTextField with `highlightable` configuration

by Marko Bekhta (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4815) Provide a user with a meaningful error when Fast Vector Highlighter is used on a field without term vectors

by Marko Bekhta (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16319) H6: Problem with order insert to table with batch is ON

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16319 ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiOGY1Mz... ) Re: H6: Problem with order insert to table with batch is ON ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiOGY1Mz... ) I meant to say, with the manual refresh() workaround you’ll obtain a similar behavior. ( https://hibernate.atlassian.net/browse/HHH-16319#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16319#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#100219- sha1:ac3e918 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect foreign key column order for @OneToMany with multiple join columns and @IdClass

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect foreign key column order for @OneToMany with multiple join columns and @IdClass

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect binding @OneToMany with multiple join columns

by Akshaya Gawand (JIRA)

Akshaya Gawand ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6409b5d... ) *commented* on HHH-16274 ( https://hibernate.atlassian.net/browse/HHH-16274?atlOrigin=eyJpIjoiYjhmYT... ) Re: Incorrect binding @OneToMany with multiple join columns ( https://hibernate.atlassian.net/browse/HHH-16274?atlOrigin=eyJpIjoiYjhmYT... ) Hello @Marco Thank you for your quick response. I confirm that removing @Id annotation from the ID class fixes my problem for now. All the best for fixing this problem Kind Regards, ( https://hibernate.atlassian.net/browse/HHH-16274#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16274#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16364) com.sybase.jdbc4.jdbc.SybDriver ddl-auto update not working

by razvan dana (JIRA)

razvan dana ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDg4ZTAzODAx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16364?atlOrigin=eyJpIjoiZDg4ZT... ) HHH-16364 ( https://hibernate.atlassian.net/browse/HHH-16364?atlOrigin=eyJpIjoiZDg4ZT... ) com.sybase.jdbc4.jdbc.SybDriver ddl-auto update not working ( https://hibernate.atlassian.net/browse/HHH-16364?atlOrigin=eyJpIjoiZDg4ZT... ) Issue Type: Bug Affects Versions: 5.6.11 Assignee: Unassigned Created: 23/Mar/2023 11:05 AM Environment: JDK 11 Spring boot 2.6.12 Hibernate 5.6.11 Sybase ASE 16 Driver: com.sybase.jdbc4.jdbc.SybDriver Dialect: org.hibernate.dialect.SybaseASE15Dialect spring.jpa.generate-ddl=true spring.jpa.hibernate.ddl-auto=update or hibernate.hbm2ddl.auto=update Priority: Major Reporter: razvan dana ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I expect that when running my application with the specified environment/app settings that it will skip creating table definitions if they already exists(as it happens with other drivers/dialects such as postgresql). But rather, after each restart of the application, after DDL has already been generated, it tries to generate always, ignoring the ddl-auto update option (which should only look for schema changes). ( https://hibernate.atlassian.net/browse/HHH-16364#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16364#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16319) H6: Problem with order insert to table with batch is ON

by Danilov Roman (JIRA)

Danilov Roman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HHH-16319 ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiOGY5Zm... ) Re: H6: Problem with order insert to table with batch is ON ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiOGY5Zm... ) “this is a similar behavior to Hibernate 5“ - but in Hibernate 5 everything worked for me without these additional steps. Or did you mean something other? ( https://hibernate.atlassian.net/browse/HHH-16319#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16319#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16352) DynamicUpdate and Statement/jdbc batch size leads to wrong parameter binding exception

by Jan Schatteman (JIRA)

Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16352 ( https://hibernate.atlassian.net/browse/HHH-16352?atlOrigin=eyJpIjoiYWE4NT... ) Re: DynamicUpdate and Statement/jdbc batch size leads to wrong parameter binding exception ( https://hibernate.atlassian.net/browse/HHH-16352?atlOrigin=eyJpIjoiYWE4NT... ) Looking into this, I found that ( as a temporary workaround ) you could set the batch size directly on the Session, it does not seem to happen then. ( https://hibernate.atlassian.net/browse/HHH-16352#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16352#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect binding @OneToMany with multiple join columns

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect binding @OneToMany with multiple join columns

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect binding @OneToMany with multiple join columns

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect binding @OneToMany with multiple join columns

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16319) H6: Problem with order insert to table with batch is ON

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16319 ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiNjRiMj... ) Re: H6: Problem with order insert to table with batch is ON ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiNjRiMj... ) Yeah, the flush is needed after persisting InterpretationData. Otherwise, as I said, if you want to keep batching for both entities you can remove the @Generated annotation, and manually call refresh(interpretation) - this is a similar behavior to Hibernate 5. ( https://hibernate.atlassian.net/browse/HHH-16319#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16319#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16308) NullPointerException when using CriteriaBuilder.function() inside CriteriaBuilder.construct()

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect binding @OneToMany with multiple join columns

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16274 ( https://hibernate.atlassian.net/browse/HHH-16274?atlOrigin=eyJpIjoiNWMyYW... ) Re: Incorrect binding @OneToMany with multiple join columns ( https://hibernate.atlassian.net/browse/HHH-16274?atlOrigin=eyJpIjoiNWMyYW... ) Hello Akshaya Gawand ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6409b5d... ) , thank you very much for the reproducers. Looks like the error in Hibernate 6 is caused by the @Id annotations on the InProcessRefSeqNoId class that is used as @IdClass that cause the foreign key constraint to be generated with a wrong order of columns. Simply removing those annotations, which by the way are not needed since it’s already an @IdClass so they have no effect, should solve your problem. Let me know if that works for you so I can close the issue. ( https://hibernate.atlassian.net/browse/HHH-16274#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16274#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16308) NullPointerException when using CriteriaBuilder.function() inside CriteriaBuilder.construct()

by Archie Cobbs (JIRA)

Archie Cobbs ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16308 ( https://hibernate.atlassian.net/browse/HHH-16308?atlOrigin=eyJpIjoiNWYwYT... ) Re: NullPointerException when using CriteriaBuilder.function() inside CriteriaBuilder.construct() ( https://hibernate.atlassian.net/browse/HHH-16308?atlOrigin=eyJpIjoiNWYwYT... ) OK - thanks for taking a look. ( https://hibernate.atlassian.net/browse/HHH-16308#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16308#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16356) Regression in Hibernate 6, multiple columns @id doesn't allow null value

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16319) H6: Problem with order insert to table with batch is ON

by Danilov Roman (JIRA)

Danilov Roman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HHH-16319 ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiMjE1YW... ) Re: H6: Problem with order insert to table with batch is ON ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiMjE1YW... ) 😞 Sad news. ”You will have to either manually flush when inserting the parent entity” - Is this not a mistake? maybe stit do flush after persist child ( InterpretationData ) ? ( https://hibernate.atlassian.net/browse/HHH-16319#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16319#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16358) OneToMany with abstract TABLE_PER_CLASS element not working

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiY2RjZTY0Njgx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16358?atlOrigin=eyJpIjoiY2RjZT... ) HHH-16358 ( https://hibernate.atlassian.net/browse/HHH-16358?atlOrigin=eyJpIjoiY2RjZT... ) OneToMany with abstract TABLE_PER_CLASS element not working ( https://hibernate.atlassian.net/browse/HHH-16358?atlOrigin=eyJpIjoiY2RjZT... ) Change By: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) {code:java}@Entity @Table(name = "table_per_class_base") @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) public abstract class TablePerClassBase { TablePerClassEmbeddable embeddable; } @ Embeddable Id public class TablePerClassEmbeddable { Integer id; @OneToMany @JoinColumn(name = "embeddableParent") Set<TablePerClassBase> children; } @Entity @Table(name = "table_per_class_sub_1") public class TablePerClassSub1 extends TablePerClassBase {} @Entity @Table(name = "table_per_class_sub_2") public class TablePerClassSub2 extends TablePerClassBase {}{code} Roughly this This model fails to persist elements. An assertion in {{OneToManyPersister#buildTableUpdate}} The problem seems to be too strict or maybe even wrong that we currently don’t handle abstract/denormalized tables in the collection persister. {{assert tableReference.getTableName().equals( elementType.getIdentifierMapping().getContainingTableExpression() )}} I think it should rather be {{assert elementType.containsTableReference(tableReference.getTableName())}} ( https://hibernate.atlassian.net/browse/HHH-16358#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16358#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16358) OneToMany with abstract TABLE_PER_CLASS element not working

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16358) OneToMany with abstract TABLE_PER_CLASS element not working

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16363) OneToMany object properties not set when EmbeddedId and it holds an OneToOne relationship to itself

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=eyJpIjoiOGU1MzE1OTVh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16363?atlOrigin=eyJpIjoiOGU1Mz... ) HHH-16363 ( https://hibernate.atlassian.net/browse/HHH-16363?atlOrigin=eyJpIjoiOGU1Mz... ) OneToMany object properties not set when EmbeddedId and it holds an OneToOne relationship to itself ( https://hibernate.atlassian.net/browse/HHH-16363?atlOrigin=eyJpIjoiOGU1Mz... ) Change By: Alina Ricciuti ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61fb92a... ) Attachment: hibernate_properties_wronly_set.log ( https://hibernate.atlassian.net/browse/HHH-16363#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16363#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16363) OneToMany object properties not set when EmbeddedId and it holds an OneToOne relationship to itself

by Alina Ricciuti (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16363) OneToMany object properties not set when EmbeddedId and it holds an OneToOne relationship to itself

by Alina Ricciuti (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16363) OneToMany object properties not set when EmbeddedId and it holds an OneToOne relationship to itself

by Alina Ricciuti (JIRA)

Alina Ricciuti ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61fb92a... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDBmMzA2ODQx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16363?atlOrigin=eyJpIjoiMDBmMz... ) HHH-16363 ( https://hibernate.atlassian.net/browse/HHH-16363?atlOrigin=eyJpIjoiMDBmMz... ) OneToMany object properties not set when EmbeddedId and it holds an OneToOne relationship to itself ( https://hibernate.atlassian.net/browse/HHH-16363?atlOrigin=eyJpIjoiMDBmMz... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Created: 23/Mar/2023 04:55 AM Environment: Hibernate: 6.2.0.CR4 Postgresql: 11 Spring Data JPA: 3.0.3 Spring Boot: 3.0.4 JDK: Oracle OpenJDK 17.0.2 OS: Windows 11 Priority: Major Reporter: Alina Ricciuti ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61fb92a... ) I have a migration issue from hibernate 5.4.32 to hibernate 6: the properties of one of my entities are not properly set. Please find below a simplified model that reproduces this issue. So, I have Elements and Tags, as presented in the attached diagram: * Elements have Tags in a relationship ManyToOne , fetch EAGER * Tags have composite identifiers * Tag may have a OneToOne relationship “linkedTag” My sample project is using Lombok / Spring Data : * Element: @Entity @Getter @Setter public class Element { @EmbeddedId private PkComposite id; @Column(name = "NAME") private String name; @ManyToOne(fetch = FetchType.EAGER, cascade = CascadeType.ALL) @JoinColumn(name = "ID_TAG") private Tag tag; } * Tag: @Entity @Getter @Setter public class Tag { @EmbeddedId private PkComposite id; private String name; @OneToMany(mappedBy = "tag", fetch = FetchType.EAGER) private List<Element> elements; @OneToOne(cascade = CascadeType.ALL) @JoinColumn(name = "ID_TAG_LINKED") private Tag linkedTag; } * The composite key: @Getter @Setter public class PkComposite implements Serializable { @Column(name = "ID") private Long id; public PkComposite withId(Long id) { this.id = id; return this; } } * The test class: @Test @Transactional public void issue3_name_not_filled() { // create some data Session session = entityManager.unwrap(Session.class); session.createNativeQuery("insert into TAG (id, NAME) values (100, 'NAME for TAG 100')").executeUpdate(); session.createNativeQuery("insert into ELEMENT (id, NAME, ID_TAG) values (200, 'NAME for ELEMENT 200', 100)").executeUpdate(); // move line to other item Element element200 = elementRepository.findById(new PkComposite().withId(200L)).orElse(null); Assertions.assertNotNull(element200); Assertions.assertNotNull(element200.getTag()); Assertions.assertNotNull(element200.getTag().getName(), "Tag name is null !"); } The test fails since the name property is not set on Element’s Tag. None of tag’s properties is set, except for its identifier. Few remarks: * the issue is reproduced whether the Element identifier is composite or simple (may be Long as example) * The OneToMany relationship to Element in Tag class may also be lazy - in my project it is actually LAZY with LazyCollection(LazyCollectionOption.FALSE) * If I remove the “linkedTag” the issue in no longer reproduced But if I set the “linkedTag“: @Test @Transactional public void issue3_tag_not_properly_set() { // create some data Session session = entityManager.unwrap(Session.class); session.createNativeQuery("insert into TAG (id, NAME) values (101, 'NAME for LINKED TAG 101')").executeUpdate(); session.createNativeQuery("insert into TAG (id, NAME, ID_TAG_LINKED) values (100, 'NAME for TAG 100', 101)").executeUpdate(); session.createNativeQuery("insert into ELEMENT (id, NAME, ID_TAG) values (200, 'NAME for ELEMENT 200', 100)").executeUpdate(); // move line to other item Element element200 = elementRepository.findById(new PkComposite().withId(200L)).orElse(null); Assertions.assertNotNull(element200); Assertions.assertNotNull(element200.getTag()); Assertions.assertNotNull(element200.getTag().getId()); Assertions.assertEquals(100L, element200.getTag().getId().getId(), "Tag is not the good one !"); Assertions.assertEquals("NAME for TAG 100", element200.getTag().getName(), "Tag properties are not good !"); } The Element’s Tag’s properties are set, but with wrong values, those of the linked Tag. I have attached the tests logs and if needed, I can also share my sample project. ( https://hibernate.atlassian.net/browse/HHH-16363#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16363#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16362) H5->H6: JOIN FETCH errors

by Danilov Roman (JIRA)

Danilov Roman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOTc3MzJhZThl... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16362?atlOrigin=eyJpIjoiOTc3Mz... ) HHH-16362 ( https://hibernate.atlassian.net/browse/HHH-16362?atlOrigin=eyJpIjoiOTc3Mz... ) H5->H6: JOIN FETCH errors ( https://hibernate.atlassian.net/browse/HHH-16362?atlOrigin=eyJpIjoiOTc3Mz... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Attachments: hibernate-orm-6.zip Components: hibernate-core Created: 23/Mar/2023 04:43 AM Priority: Major Reporter: Danilov Roman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) Hello. In Hibernate 6.2.0.CR4. I have some entities: public class ImageLog { @ManyToOne @JoinColumn(name = "lateral_id", nullable = false) public Lateral lateral; } public class Lateral { @ManyToOne(fetch = FetchType.EAGER) @JoinColumn(name = "project_uuid", nullable = false, updatable = false) public Project project; } public class Project { @ManyToOne(fetch = FetchType.EAGER) @Column(name = "company_id", insertable = false, updatable = false) public Company company; } And repository query: @Query("SELECT ilog.lateral.project FROM ImageLog ilog JOIN FETCH ilog.lateral.project.company WHERE ilog.uuid = ?1") Optional<Project> findParentProject(UUID logUuid); And the error appears: org.hibernate.query.SemanticException: query specified join fetching, but the owner of the fetched association was not present in the select list [SqmSingularJoin(com.repository.project.imagelog.entity.ImageLog(ilog).lateral : lateral)] Is it a bug? ( https://hibernate.atlassian.net/browse/HHH-16362#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16362#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15160) Extend Postgis support to distance operators

by Karel Maesen (JIRA)

Karel Maesen ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15160 ( https://hibernate.atlassian.net/browse/HHH-15160?atlOrigin=eyJpIjoiN2YyZG... ) Re: Extend Postgis support to distance operators ( https://hibernate.atlassian.net/browse/HHH-15160?atlOrigin=eyJpIjoiN2YyZG... ) Not yet, but I’ll see if I can start on this in the next weeks. ( https://hibernate.atlassian.net/browse/HHH-15160#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15160#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16361) Pass current Entity info to Naming Strategy callbacks for columns

by Ilia Basin (JIRA)

Ilia Basin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDdmZmRlMzVm... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16361?atlOrigin=eyJpIjoiZDdmZm... ) HHH-16361 ( https://hibernate.atlassian.net/browse/HHH-16361?atlOrigin=eyJpIjoiZDdmZm... ) Pass current Entity info to Naming Strategy callbacks for columns ( https://hibernate.atlassian.net/browse/HHH-16361?atlOrigin=eyJpIjoiZDdmZm... ) Issue Type: Improvement Affects Versions: 6.1.7 Assignee: Unassigned Created: 23/Mar/2023 04:33 AM Priority: Major Reporter: Ilia Basin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Please consider passing the info about the current entity when calling ImplicitBasicColumnNameSource.determineBasicColumnName and PhysicalNamingStrategy.toPhysicalColumnName The reason is described here: https://stackoverflow.com/questions/75816005/choice-based-on-current-enti... ( https://stackoverflow.com/questions/75816005/choice-based-on-current-enti... ) > > > > I know a logical schema of a 3rd-party readonly DB and I want to access it > with Hibernate 6. I used the schema to generate `@Entity` beans for it, > but there's one problem: > > > > Different entities may have identical logical attribute names, but the > physical column names are mapped in a special registry table in the same > DB and they may differ among entities and even for the same entity in > different environments. For instance, on one environment the column is > called "name" and on another it's "name2". > > > > To solve this I'm trying to implement one of these two methods: > > > > * `org.hibernate.boot.model.naming.ImplicitNamingStrategy.determineBasicColumnName(ImplicitBasicColumnNameSource)` > > * `org.hibernate.boot.model.naming.PhysicalNamingStrategy.toPhysicalColumnName(Identifier, > JdbcEnvironment)` > > > > > They are supposed to access the registry table and convert the property > accordingly. > > > > However, the caller does not pass the current entity name to the callbacks > and I don't know for which entity to retrieve the physical column name! > > > > Is there a workaround better than prefixing all like this? > `@Column("MyEntiy$MyProperty")` > > See also https://stackoverflow.com/questions/22639588/hibernate-naming-strategy-pe... ( https://stackoverflow.com/questions/22639588/hibernate-naming-strategy-pe... ) https://stackoverflow.com/questions/10877626/hibernate-column-names-based... ( https://stackoverflow.com/questions/10877626/hibernate-column-names-based... ) ( https://hibernate.atlassian.net/browse/HHH-16361#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16361#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16355) Map association with entity typed key breaks if mappedBy is specified

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16317) InstantAsTimestampWithTimeZoneJdbcType doesn't work for timestamp on PG-JDBC and MSSQL

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16287) Consider hibernate.timezone.default_storage for OffsetTime typing and storage

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16317) InstantAsTimestampWithTimeZoneJdbcType doesn't work for timestamp on PG-JDBC

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16360) On Postgresql with hbm2ddl.auto=update, timestamp columns are updated even when correct

by ClementC (JIRA)

ClementC ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYTdmMGMzYTE4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16360?atlOrigin=eyJpIjoiYTdmMG... ) HHH-16360 ( https://hibernate.atlassian.net/browse/HHH-16360?atlOrigin=eyJpIjoiYTdmMG... ) On Postgresql with hbm2ddl.auto=update, timestamp columns are updated even when correct ( https://hibernate.atlassian.net/browse/HHH-16360?atlOrigin=eyJpIjoiYTdmMG... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Components: hibernate-jpamodelgen Created: 23/Mar/2023 03:52 AM Environment: Postgresql 14 Priority: Major Reporter: ClementC ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) With hbm2ddl.auto=update on Postgresql, columns for properties persisted as timestamps (like Instant, OffsetDateTime, LocalDateTime, …) are updated on every startup, even if the alter statement does not perform any actual change. hbm2ddl.auto=validate does not detect any problem. This did not happen on 6.1.7 (because it did not have the capability to update existing columns anyway). *Sample* My entity: @Entity @Getter @Setter public class Test { @Id private String id; private Instant instant; private OffsetDateTime offsetDateTime; private ZonedDateTime zonedDateTime; private LocalDateTime localDateTime; private Date date; } Startup logs (even when columns already exist with the right type): [Hibernate] alter table if exists auth0.test alter column date set data type timestamp(6) [Hibernate] alter table if exists auth0.test alter column instant set data type timestamp(6) with time zone [Hibernate] alter table if exists auth0.test alter column local_date_time set data type timestamp(6) [Hibernate] alter table if exists auth0.test alter column offset_date_time set data type timestamp(6) with time zone [Hibernate] alter table if exists auth0.test alter column zoned_date_time set data type timestamp(6) with time zone *Quick analysis (using 6.2.0.CR4)* With hbm2ddl.auto=update: StandardTableMigrator#sqlAlterStrings checks both type and length //StandardTableMigrator line 88 if ( !ColumnDefinitions.hasMatchingType( column, columnInformation, metadata, dialect ) || !ColumnDefinitions.hasMatchingLength( column, columnInformation, metadata, dialect ) ) With hbm2ddl.auto=validate: AbstractSchemaValidator#validateColumnType only checks the type (which matches) //AbstractSchemaValidator line 163 if ( !ColumnDefinitions.hasMatchingType( column, columnInformation, metadata, dialect ) ) { So the problem is in ColumnDefinitions.hasMatchingLength : final int actualSize = columnInformation.getColumnSize(); if ( actualSize == 0 ) { return true ; } else { final Size size = column.getColumnSize( dialect, metadata ); final Long requiredLength = size.getLength(); final Integer requiredPrecision = size.getPrecision(); return requiredLength != null && requiredLength == actualSize || requiredPrecision != null && requiredPrecision == actualSize || requiredPrecision == null && requiredLength == null ; } For a timestamp with zone column: * actualSize = 35 (no idea why) * requiredLength is null * requiredPrecision = 6 * ==> requiredPrecision != null && requiredPrecision == actualSize is false ( https://hibernate.atlassian.net/browse/HHH-16360#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16360#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16274) Incorrect binding @OneToMany with multiple join columns

by Akshaya Gawand (JIRA)

Akshaya Gawand ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6409b5d... ) *commented* on HHH-16274 ( https://hibernate.atlassian.net/browse/HHH-16274?atlOrigin=eyJpIjoiNjZjOW... ) Re: Incorrect binding @OneToMany with multiple join columns ( https://hibernate.atlassian.net/browse/HHH-16274?atlOrigin=eyJpIjoiNjZjOW... ) @Marco Belladelli Thanks, I have created the reproducer using only hibernate here: https://github.com/akshaya15g/HibernateReproducerORM6Issue ( https://github.com/akshaya15g/HibernateReproducerORM6Issue ) I have also created another test case using the older version which does the exact same thing where everything worked fine https://github.com/akshaya15g/HibernateReproducerORM5WorkingFine ( https://github.com/akshaya15g/HibernateReproducerORM5WorkingFine ) ( https://hibernate.atlassian.net/browse/HHH-16274#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16274#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16359) SingularAttribute with non-nullable column is wrongly reported as optional

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDNkZjlhZmNk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16359?atlOrigin=eyJpIjoiZDNkZj... ) HHH-16359 ( https://hibernate.atlassian.net/browse/HHH-16359?atlOrigin=eyJpIjoiZDNkZj... ) SingularAttribute with non-nullable column is wrongly reported as optional ( https://hibernate.atlassian.net/browse/HHH-16359?atlOrigin=eyJpIjoiZDNkZj... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Components: hibernate-core Created: 23/Mar/2023 03:20 AM Fix Versions: 6.2.0 Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) A singular attribute with just @Column(nullable = false) is wrongly reported as SingularAttribute.isOptional() == true. ( https://hibernate.atlassian.net/browse/HHH-16359#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16359#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16351) Migrating from 5.6 to 6.1 to_timestamp(double) function now throws QueryException

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16351 ( https://hibernate.atlassian.net/browse/HHH-16351?atlOrigin=eyJpIjoiNWEzM2... ) Re: Migrating from 5.6 to 6.1 to_timestamp(double) function now throws QueryException ( https://hibernate.atlassian.net/browse/HHH-16351?atlOrigin=eyJpIjoiNWEzM2... ) Please create a new issue for this with a full stack trace and ideally also with a reproducer, using this test case template: https://github.com/hibernate/hibernate-test-case-templates/blob/master/or... ( https://github.com/hibernate/hibernate-test-case-templates/blob/master/or... ) ( https://hibernate.atlassian.net/browse/HHH-16351#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16351#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16351) Migrating from 5.6 to 6.1 to_timestamp(double) function now throws QueryException

by Richard Turner (JIRA)

Richard Turner ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bed604... ) *commented* on HHH-16351 ( https://hibernate.atlassian.net/browse/HHH-16351?atlOrigin=eyJpIjoiNTRhMm... ) Re: Migrating from 5.6 to 6.1 to_timestamp(double) function now throws QueryException ( https://hibernate.atlassian.net/browse/HHH-16351?atlOrigin=eyJpIjoiNTRhMm... ) Thanks for the update, I also see this error during startup now: HHH000099: an assertion failure occurred (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session): org.hibernate.AssertionFailure: value involves formulas Which is thrown when evaluating an entity with a @Formula annotation like this: @Formula("(select ra.VALUE from PUBLIC.REALM_ATTRIBUTE ra where ra.REALM_ID = ID and ra.name = 'displayName')") But the calculated field seems to function OK, is this the same issue of stricter validation? ( https://hibernate.atlassian.net/browse/HHH-16351#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16351#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16319) H6: Problem with order insert to table with batch is ON

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16319 ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiNzJjOD... ) Re: H6: Problem with order insert to table with batch is ON ( https://hibernate.atlassian.net/browse/HHH-16319?atlOrigin=eyJpIjoiNzJjOD... ) Hello Danilov Roman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) , thank you for reporting the issue and providing a reproducer. The error is caused by the @Generated property in the Interpretation entity: to be able to retrieve insert-generated values correctly Hibernate has to disable batching for entities having that annotation. This causes the order of operations to be changed: instead of inserting InterpretationData first, that gets added to the batch queue whereas the Interpretation insert is executed immediately, causing the foreign key error. You will have to either manually flush when inserting the parent entity or handle inserts in different transactions. ( https://hibernate.atlassian.net/browse/HHH-16319#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16319#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#100219- sha1:0c2c9f2 )

3 years, 3 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... ) *commented* on HHH-16215 ( https://hibernate.atlassian.net/browse/HHH-16215?atlOrigin=eyJpIjoiYmJhYj... ) Re: 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=eyJpIjoiYmJhYj... ) Thanks Andrea. Your fix solves my issue. ( 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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16351) Migrating from 5.6 to 6.1 to_timestamp(double) function now throws QueryException

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16351 ( https://hibernate.atlassian.net/browse/HHH-16351?atlOrigin=eyJpIjoiOTAwZT... ) Re: Migrating from 5.6 to 6.1 to_timestamp(double) function now throws QueryException ( https://hibernate.atlassian.net/browse/HHH-16351?atlOrigin=eyJpIjoiOTAwZT... ) It’s a bug. What changed is that we added stricter validation for functions to be able to emit better errors, but we appear to be too strict in some cases. ( https://hibernate.atlassian.net/browse/HHH-16351#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16351#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16308) NullPointerException when using CriteriaBuilder.function() inside CriteriaBuilder.construct()

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16308) NullPointerException when using CriteriaBuilder.function() inside CriteriaBuilder.construct()

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16308 ( https://hibernate.atlassian.net/browse/HHH-16308?atlOrigin=eyJpIjoiZTRjYW... ) Re: NullPointerException when using CriteriaBuilder.function() inside CriteriaBuilder.construct() ( https://hibernate.atlassian.net/browse/HHH-16308?atlOrigin=eyJpIjoiZTRjYW... ) Hello Archie Cobbs ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , you reproducer works correctly with Hibernate 6. We won’t be releasing new versions of Hibernate 5 so I don’t think this issue will be fixed, I’d suggest considering an upgrade to the latest version. ( https://hibernate.atlassian.net/browse/HHH-16308#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16308#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#100219- sha1:0c2c9f2 )

3 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4823) Clarify the documentation of the configuration property about the Elasticsearch version

by Yoann Rodière (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4823) Clarify the documentation of the configuration property about the Elasticsearch version

by Yoann Rodière (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16352) DynamicUpdate and Statement/jdbc batch size leads to wrong parameter binding exception

by Jan Schatteman (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16317) InstantAsTimestampWithTimeZoneJdbcType doesn't work for timestamp on PG-JDBC

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16317) InstantAsTimestampWithTimeZoneJdbcType doesn't work for timestamp on PG-JDBC

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16317) InstantAsTimestampWithTimeZoneJdbcType doesn't work for timestamp on PostgreSQL

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzVkMDkzOWFh... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16317?atlOrigin=eyJpIjoiMzVkMD... ) HHH-16317 ( https://hibernate.atlassian.net/browse/HHH-16317?atlOrigin=eyJpIjoiMzVkMD... ) InstantAsTimestampWithTimeZoneJdbcType doesn't work for timestamp on PostgreSQL ( https://hibernate.atlassian.net/browse/HHH-16317?atlOrigin=eyJpIjoiMzVkMD... ) Change By: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) This There is useful when one wants to bind a {{timestamp}} parameter pg-jdbc issue that prevents us from using this type: [https://github.com/pgjdbc/pgjdbc/issues/2862|https://github.com/pgjdbc/pg...] Binding to an {{ Instant timestamptz }}, which might fail on PostgreSQL, because right now, we use {{InstantAsTimestampWithTimeZoneJdbcType}} is our default choice for that dialect, which binds {{ OffsetDateTime Instant }} through the JDBC driver. It has yet to be confirmed if this is a bug or not , works without problems, but pgjdbc shifts {{OffsetDateTime}} to the JVM TZ when binding to a {{timestamp}} column. If we can’t be sure that this type is correct JDBC behavior, we might as well drop the {{InstantAsTimestampWithTimeZoneJdbcType}} and use {{InstantAsTimestampJdbcType}} instead for PostgreSQL used. NB: Using the default {{ InstantAsTimestampJdbcType TimestampUtcAsJdbcTimestampJdbcType }} uses a shared calendar for passing UTC on the other hand will work perfectly fine, as that will always pass the time zone as argument. Maybe we need to copy that to be safe, but we could switch between a copying and shared implementation based on what we know about the drivers. ( https://hibernate.atlassian.net/browse/HHH-16317#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16317#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16317) InstantAsTimestampWithTimeZoneJdbcType doesn't work for timestamp on PostgreSQL

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiZGZkY2... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiZGZkY2... ) By using @get: you are telling the Kotlin Compiler to put the annotations on the Getter it generates for the data class property instead of the field. Since Kotlin duplicates fields, using field annotations is actually not a good idea. It’s so strange, Kotlin prefers to model properties through getters/setters but still puts annotations on the field. This simply is a recipe for disaster. Anyway, I don’t know what changed in Hibernate 6 that changed the behavior, but we will look into this when we can. ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16358) TABLE_PER_CLASS one-to-many fails to persist

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYjdmMTc3Mjk3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16358?atlOrigin=eyJpIjoiYjdmMT... ) HHH-16358 ( https://hibernate.atlassian.net/browse/HHH-16358?atlOrigin=eyJpIjoiYjdmMT... ) TABLE_PER_CLASS one-to-many fails to persist ( https://hibernate.atlassian.net/browse/HHH-16358?atlOrigin=eyJpIjoiYjdmMT... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: hibernate-core Created: 22/Mar/2023 11:32 AM Fix Versions: 6.2.0 Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) @Entity @Table(name = "table_per_class_base" ) @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) public abstract class TablePerClassBase { TablePerClassEmbeddable embeddable; } @Embeddable public class TablePerClassEmbeddable { @OneToMany @JoinColumn(name = "embeddableParent" ) Set<TablePerClassBase> children; } @Entity @Table(name = "table_per_class_sub_1" ) public class TablePerClassSub1 extends TablePerClassBase {} @Entity @Table(name = "table_per_class_sub_2" ) public class TablePerClassSub2 extends TablePerClassBase {} Roughly this model fails to persist elements. An assertion in OneToManyPersister#buildTableUpdate seems to be too strict or maybe even wrong. assert tableReference.getTableName().equals( elementType.getIdentifierMapping().getContainingTableExpression() ) I think it should rather be assert elementType.containsTableReference(tableReference.getTableName()) ( https://hibernate.atlassian.net/browse/HHH-16358#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16358#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16348) Re-add JdbcOperationQuery#getAppliedParameters for query extensions

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16333) Handle converters properly in BasicPluralType

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16357) Clean up EntityPersister and CollectionPersister state

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTNlMDM0YzM5... ) / Task ( https://hibernate.atlassian.net/browse/HHH-16357?atlOrigin=eyJpIjoiNTNlMD... ) HHH-16357 ( https://hibernate.atlassian.net/browse/HHH-16357?atlOrigin=eyJpIjoiNTNlMD... ) Clean up EntityPersister and CollectionPersister state ( https://hibernate.atlassian.net/browse/HHH-16357?atlOrigin=eyJpIjoiNTNlMD... ) Issue Type: Task Assignee: Unassigned Created: 22/Mar/2023 09:27 AM Fix Versions: 6.2.0 Priority: Major Reporter: Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) A lot of state (memory wise) held in the persisters is related to the legacy approach of building SQL strings via concatenation (aka, not SQL AST). Most of those usages have been converted to using SQL AST instead so the state is unnecessary. Go back and look for any such state that we can prune. ( https://hibernate.atlassian.net/browse/HHH-16357#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16357#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16305) Error when using parameter as both a select function argument and in where clause

by Marco Belladelli (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16266) Error when using @Query with EmbeddedId after upgrading to Spring Boot 3.0.4

by karthik (JIRA)

karthik ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6331f78... ) *commented* on HHH-16266 ( https://hibernate.atlassian.net/browse/HHH-16266?atlOrigin=eyJpIjoiMDBiZm... ) Re: Error when using @Query with EmbeddedId after upgrading to Spring Boot 3.0.4 ( https://hibernate.atlassian.net/browse/HHH-16266?atlOrigin=eyJpIjoiMDBiZm... ) Thank you Christian. Appreciate the response. ( https://hibernate.atlassian.net/browse/HHH-16266#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16266#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16356) Regression in Hibernate 6, multiple columns @id doesn't allow null value

by Giuseppe Milicia (JIRA)

Giuseppe Milicia ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTUxYWFlNDBm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16356?atlOrigin=eyJpIjoiZTUxYW... ) HHH-16356 ( https://hibernate.atlassian.net/browse/HHH-16356?atlOrigin=eyJpIjoiZTUxYW... ) Regression in Hibernate 6, multiple columns @id doesn't allow null value ( https://hibernate.atlassian.net/browse/HHH-16356?atlOrigin=eyJpIjoiZTUxYW... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-core Created: 22/Mar/2023 09:01 AM Environment: Spring Boot 3, JVM 17 Priority: Major Reporter: Giuseppe Milicia ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) We have identified a regression in Hibernate 6 where an entity with @Id on multiple columns behaves differently than in Hibernate 5. Specifically, if one of the columns in the @Id annotation is null, the entire row is returned as null, whereas in Hibernate 5, the same code worked correctly. This regression is causing issues in our project, particularly when dealing with stored procedures where it may not always be possible to have a unique identifier for the entity. We would like to either have this bug fixed, or alternatively, have the ability to define a property that allows for the previous behavior seen in Hibernate 5. Steps to reproduce: * Define an entity with @Id annotation on multiple columns. * Create a row in the database where one of the columns in the @Id annotation is null. * Retrieve the entity using Hibernate 6. Expected result: The entity should be retrieved correctly, with the null column treated as a valid value. Actual result: The entire row is returned as null, which is not the expected behavior. ( https://hibernate.atlassian.net/browse/HHH-16356#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16356#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16355) Map association with entity typed key breaks if mappedBy is specified

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYmUwYmIxOTky... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16355?atlOrigin=eyJpIjoiYmUwYm... ) HHH-16355 ( https://hibernate.atlassian.net/browse/HHH-16355?atlOrigin=eyJpIjoiYmUwYm... ) Map association with entity typed key breaks if mappedBy is specified ( https://hibernate.atlassian.net/browse/HHH-16355?atlOrigin=eyJpIjoiYmUwYm... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) Created: 22/Mar/2023 08:39 AM Priority: Major Reporter: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) In Hibernate 6.2 mapping a Map association with and entity typed key and mappedBy causes an error. Here is an example mapping: @Entity @Table( name = "map_container_entity" ) public static class MapContainerEntity { @Id private Long id; @OneToMany(mappedBy = "container" ) private Map<MapKeyEntity, MapValueEntity> map; } @Entity @Table( name = "map_key_entity" ) public static class MapKeyEntity { @Id private Long id; } @Entity @Table( name = "map_value_entity" ) public static class MapValueEntity { @Id private Long id; @ManyToOne private MapContainerEntity container; } And the error is: Caused by: org.hibernate.MappingException: property [container] not found on entity [com.blazebit.persistence.testsuite.AliasBasedMapKeyDereferencingTest$MapKeyEntity] at org.hibernate.mapping.PersistentClass.getRecursiveProperty(PersistentClass.java:570) at org.hibernate.boot.model.internal.CollectionBinder.bindUnownedManyToManyInverseForeignKey(CollectionBinder.java:2657) at org.hibernate.boot.model.internal.CollectionBinder.bindManyToManyInverseForeignKey(CollectionBinder.java:2619) at org.hibernate.boot.model.internal.MapBinder.handleMapKey(MapBinder.java:184) at org.hibernate.boot.model.internal.MapBinder.bindKeyFromAssociationTable(MapBinder.java:167) at org.hibernate.boot.model.internal.MapBinder$1.secondPass(MapBinder.java:95) at org.hibernate.boot.model.internal.CollectionSecondPass.doSecondPass(CollectionSecondPass.java:45) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.processSecondPasses(InFlightMetadataCollectorImpl.java:1850) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.processSecondPasses(InFlightMetadataCollectorImpl.java:1807) at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:324) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1380) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1451) at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:142) at com.blazebit.persistence.testsuite.base.jpa.AbstractJpaPersistenceTest.createEntityManagerFactory(AbstractJpaPersistenceTest.java:848) ... 42 more Caused by: org.hibernate.MappingException: property [container] not found on entity [com.blazebit.persistence.testsuite.AliasBasedMapKeyDereferencingTest$MapKeyEntity] at org.hibernate.mapping.PersistentClass.getRecursiveProperty(PersistentClass.java:613) at org.hibernate.mapping.PersistentClass.getRecursiveProperty(PersistentClass.java:566) ... 55 more ( https://hibernate.atlassian.net/browse/HHH-16355#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16355#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Jan Schumacher (JIRA)

Jan Schumacher ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=60d46a1... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiNjQxOT... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiNjQxOT... ) As soon as I add one instance of @get on any property the behaviour is 100% correct even for those properties without ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Jan Schumacher (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16354) Ability to open a StatelessSession which is subordinate to a Session

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTQ5YzEzNWZj... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-16354?atlOrigin=eyJpIjoiMTQ5Yz... ) HHH-16354 ( https://hibernate.atlassian.net/browse/HHH-16354?atlOrigin=eyJpIjoiMTQ5Yz... ) Ability to open a StatelessSession which is subordinate to a Session ( https://hibernate.atlassian.net/browse/HHH-16354?atlOrigin=eyJpIjoiMTQ5Yz... ) Issue Type: New Feature Assignee: Unassigned Created: 22/Mar/2023 08:16 AM Priority: Major Reporter: Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Similar to the feature of opening a “temporary” Session which we added for Envers, it would be nice to be able to open a “temporary” StatelessSession which shares the transactional and JDB context from the containing Session. I like the phrase subordinate over temporary. ( https://hibernate.atlassian.net/browse/HHH-16354#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16354#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16353) Make it possible for Hibernate Reactive to override the creation of AttributeMapping and Fetch strategies

by Davide D'Alto (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Jan Schumacher (JIRA)

Jan Schumacher ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=60d46a1... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiOWVkYj... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiOWVkYj... ) The interesting fact is that even though I’m using @get:Column the Entity1.setter gets called. ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Jan Schumacher (JIRA)

Jan Schumacher ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=60d46a1... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiZWY5NT... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiZWY5NT... ) @Ilja Pavkovic Thats exactly what I discovered in debugging. @Christian Baikov can you explain whats the difference between @get:Column and @Column? ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Ilja Pavkovic (JIRA)

Ilja Pavkovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5d8cd77... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiMzkxNG... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiMzkxNG... ) persistence context of hibernate ORM 6 seems to pick setter method of superclass instead of setter method of sub-class. In the given example Order.setOid() instead of PlaneOrder.setOid(). Therefore, PlaneOrder.getOid() returns null ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16345) PostgreSQL*ProcedureTest.testProcedureWithJDBCByName fails with EnterpriseDB

by Martin Simka (JIRA)

Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16345 ( https://hibernate.atlassian.net/browse/HHH-16345?atlOrigin=eyJpIjoiNTY2YT... ) Re: PostgreSQL*ProcedureTest.testProcedureWithJDBCByName fails with EnterpriseDB ( https://hibernate.atlassian.net/browse/HHH-16345?atlOrigin=eyJpIjoiNTY2YT... ) Description updated with PSQLException stack trace. Just {{ {call sp_count_phones(?,?)} }} without listing parameter names doesn’t work. ( https://hibernate.atlassian.net/browse/HHH-16345#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16345#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16345) PostgreSQL*ProcedureTest.testProcedureWithJDBCByName fails with EnterpriseDB

by Martin Simka (JIRA)

Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMmNjYjg2Y2Q4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16345?atlOrigin=eyJpIjoiMmNjYj... ) HHH-16345 ( https://hibernate.atlassian.net/browse/HHH-16345?atlOrigin=eyJpIjoiMmNjYj... ) PostgreSQL*ProcedureTest.testProcedureWithJDBCByName fails with EnterpriseDB ( https://hibernate.atlassian.net/browse/HHH-16345?atlOrigin=eyJpIjoiMmNjYj... ) Change By: Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) {{PostgreSQLStoredProcedureTest.testProcedureWithJDBCByName}} {{PostgreSQLFunctionProcedureTest.testFunctionWithJDBCByName}} fail with similar error using named parameters: {noformat} java.lang.AssertionError: expected:<class java.sql.SQLFeatureNotSupportedException> but was:<class com.edb.util.PSQLException>{noformat} {noformat}com.edb.util.PSQLException: A CallableStatement has a named parameter undefined in the calling statement. Parameter: phoneCount at com.edb.jdbc.PgCallableStatement.getNamedParameterIndex(PgCallableStatement.java:1152) ~[edb-jdbc-42.5.0.1.jar:42.5.0.1-SNAPSHOT] at com.edb.jdbc.PgCallableStatement.registerOutParameter(PgCallableStatement.java:831) ~[edb-jdbc-42.5.0.1.jar:42.5.0.1-SNAPSHOT] at org.hibernate.orm.test.procedure.PostgreSQLStoredProcedureTest.lambda$testProcedureWithJDBCByName$5(PostgreSQLStoredProcedureTest.java:221) ~[test/:?] at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:56) ~[main/:?] at org.hibernate.internal.AbstractSharedSessionContract.lambda$doReturningWork$6(AbstractSharedSessionContract.java:973) ~[main/:?] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:290) ~[main/:?] at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:977) ~[main/:?] at org.hibernate.internal.AbstractSharedSessionContract.doReturningWork(AbstractSharedSessionContract.java:973) ~[main/:?] at org.hibernate.orm.test.procedure.PostgreSQLStoredProcedureTest.lambda$testProcedureWithJDBCByName$6(PostgreSQLStoredProcedureTest.java:217) ~[test/:?] at org.hibernate.testing.transaction.TransactionUtil.doInJPA(TransactionUtil.java:258) [hibernate-testing-6.2.0-SNAPSHOT.jar:6.2.0-SNAPSHOT] at org.hibernate.testing.transaction.TransactionUtil.doInJPA(TransactionUtil.java:299) [hibernate-testing-6.2.0-SNAPSHOT.jar:6.2.0-SNAPSHOT] at org.hibernate.orm.test.procedure.PostgreSQLStoredProcedureTest.testProcedureWithJDBCByName(PostgreSQLStoredProcedureTest.java:214) [test/:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) [junit-4.13.2.jar:4.13.2] at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.13.2.jar:4.13.2] at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) [junit-4.13.2.jar:4.13.2] at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:45) [hibernate-testing-6.2.0-SNAPSHOT.jar:6.2.0-SNAPSHOT] at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) [junit-4.13.2.jar:4.13.2] at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) [junit-4.13.2.jar:4.13.2] at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) [junit-4.13.2.jar:4.13.2] at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299) [junit-4.13.2.jar:4.13.2] at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293) [junit-4.13.2.jar:4.13.2] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at java.lang.Thread.run(Thread.java:829) [?:?]{noformat} while {{PostgreSQLFunctionProcedureTest}} could by be fixed by referencing parameters in query {{sp_count_phones(?,?)}} → {{call sp_count_phones(phoneCount=>?,personId=>?)}} I didn’t find a similar syntax for {{PostgreSQLFunctionProcedureTest}}. ( https://hibernate.atlassian.net/browse/HHH-16345#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16345#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16352) DynamicUpdate and Statement/jdbc batch size leads to wrong parameter binding exception

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzhmYTg1MDVj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16352?atlOrigin=eyJpIjoiNzhmYT... ) HHH-16352 ( https://hibernate.atlassian.net/browse/HHH-16352?atlOrigin=eyJpIjoiNzhmYT... ) DynamicUpdate and Statement/jdbc batch size leads to wrong parameter binding exception ( https://hibernate.atlassian.net/browse/HHH-16352?atlOrigin=eyJpIjoiNzhmYT... ) Change By: Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given * {{STATEMENT_BATCH_SIZE}} is enabled * An entity with DynamicUpdate When * When changing multiple instances of a managed entity Then * An exception occurs trying to bind a parameter using the wrong generated sql {code:java}@DynamicUpdate @Entity @Table(name = "ENTITY_A") public class EntityA { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") Integer id; @Column(name = "PROPERTY_A") int propertyA; @Column(name = "PROPERTY_B") int propertyB; }{code} {code:java} @Override protected void configure(Configuration configuration) { super.configure(configuration); configuration.setProperty(AvailableSettings.SHOW_SQL, Boolean.TRUE.toString()); configuration.setProperty(AvailableSettings.FORMAT_SQL, Boolean.TRUE.toString()); configuration.setProperty(AvailableSettings.STATEMENT_BATCH_SIZE, "2"); } @Test public void hhhXXXXTest() throws Exception { // BaseCoreFunctionalTestCase automatically creates the SessionFactory and // provides the Session. try (Session s = openSession()) { Transaction tx = s.beginTransaction(); EntityA entityA1 = new EntityA(); EntityA entityA2 = new EntityA(); s.persist(entityA1); s.persist(entityA2); tx.commit(); } try (Session s = openSession()) { Transaction tx = s.beginTransaction(); String hql = "select e from org.hibernate.bugs.EntityA e"; Query<EntityA> query = s.createQuery(hql, EntityA.class); List<EntityA> actual = query.list(); actual.get(0).propertyA = 1; actual.get(1).propertyA = 2; actual.get(1).propertyB = 2; s.flush(); tx.commit(); } }{code} {noformat}org.hibernate.exception.DataException: Unable to bind parameter #3 - 2 [Invalid value "3" for parameter "parameterIndex" [90008-214]] [n/a] at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:53) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:94) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.lambda$beforeStatement$0(JdbcValueBindingsImpl.java:95) at java.base/java.lang.Iterable.forEach(Iterable.java:75) at org.hibernate.engine.jdbc.mutation.spi.BindingGroup.forEachBinding(BindingGroup.java:51) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.beforeStatement(JdbcValueBindingsImpl.java:85) at org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$addToBatch$0(BatchImpl.java:129) at org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59) at org.hibernate.engine.jdbc.batch.internal.BatchImpl.addToBatch(BatchImpl.java:114) at org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.performBatchedOperations(MutationExecutorSingleBatched.java:60) at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.execute(AbstractMutationExecutor.java:45) at org.hibernate.persister.entity.mutation.UpdateCoordinatorStandard.doDynamicUpdate(UpdateCoordinatorStandard.java:939) at org.hibernate.persister.entity.mutation.UpdateCoordinatorStandard.performUpdate(UpdateCoordinatorStandard.java:279) at org.hibernate.persister.entity.mutation.UpdateCoordinatorStandard.coordinateUpdate(UpdateCoordinatorStandard.java:209) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2739) at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:166) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:616) at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:487) at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:484) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:358) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) 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.flush(SessionImpl.java:1398) at org.hibernate.bugs.ORMUnitTestCase.hhhXXXXXTest(ORMUnitTestCase.java:80) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:45) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: org.h2.jdbc.JdbcSQLDataException: Invalid value "3" for parameter "parameterIndex" [90008-214] at org.h2.message.DbException.getJdbcSQLException(DbException.java:646) at org.h2.message.DbException.getJdbcSQLException(DbException.java:477) at org.h2.message.DbException.get(DbException.java:223) at org.h2.message.DbException.getInvalidValueException(DbException.java:298) at org.h2.jdbc.JdbcPreparedStatement.setParameter(JdbcPreparedStatement.java:1395) at org.h2.jdbc.JdbcPreparedStatement.setInt(JdbcPreparedStatement.java:359) at org.hibernate.type.descriptor.jdbc.IntegerJdbcType$1.doBind(IntegerJdbcType.java:72) at org.hibernate.type.descriptor.jdbc.BasicBinder.bind(BasicBinder.java:61) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.lambda$beforeStatement$0(JdbcValueBindingsImpl.java:87) ... 38 more {noformat} Test scenario to be attached and also available here [https://github.com/ratoaq2/HHH-16352|https://github.com/ratoaq2/HHH-16352...] ( https://hibernate.atlassian.net/browse/HHH-16352#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16352#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16352) DynamicUpdate and Statement/jdbc batch size leads to wrong parameter binding exception

by Jones (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16352) DynamicUpdate and Statement/jdbc batch size leads to wrong parameter binding exception

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGQ3MzdjN2Rh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16352?atlOrigin=eyJpIjoiMGQ3Mz... ) HHH-16352 ( https://hibernate.atlassian.net/browse/HHH-16352?atlOrigin=eyJpIjoiMGQ3Mz... ) DynamicUpdate and Statement/jdbc batch size leads to wrong parameter binding exception ( https://hibernate.atlassian.net/browse/HHH-16352?atlOrigin=eyJpIjoiMGQ3Mz... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Components: hibernate-core Created: 22/Mar/2023 06:03 AM Priority: Critical Reporter: Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given * STATEMENT_BATCH_SIZE is enabled * An entity with DynamicUpdate When * When changing multiple instances of a managed entity Then * An exception occurs trying to bind a parameter using the wrong generated sql @DynamicUpdate @Entity @Table(name = "ENTITY_A" ) public class EntityA { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID" ) Integer id; @Column(name = "PROPERTY_A" ) int propertyA; @Column(name = "PROPERTY_B" ) int propertyB; } @Override protected void configure(Configuration configuration) { super.configure(configuration); configuration.setProperty(AvailableSettings.SHOW_SQL, Boolean.TRUE.toString()); configuration.setProperty(AvailableSettings.FORMAT_SQL, Boolean.TRUE.toString()); configuration.setProperty(AvailableSettings.STATEMENT_BATCH_SIZE, "2" ); } @Test public void hhhXXXXTest() throws Exception { // BaseCoreFunctionalTestCase automatically creates the SessionFactory and // provides the Session. try (Session s = openSession()) { Transaction tx = s.beginTransaction(); EntityA entityA1 = new EntityA(); EntityA entityA2 = new EntityA(); s.persist(entityA1); s.persist(entityA2); tx.commit(); } try (Session s = openSession()) { Transaction tx = s.beginTransaction(); String hql = "select e from org.hibernate.bugs.EntityA e" ; Query<EntityA> query = s.createQuery(hql, EntityA.class); List<EntityA> actual = query.list(); actual.get(0).propertyA = 1; actual.get(1).propertyA = 2; actual.get(1).propertyB = 2; s.flush(); tx.commit(); } } org.hibernate.exception.DataException: Unable to bind parameter #3 - 2 [Invalid value "3" for parameter "parameterIndex" [90008-214]] [n/a] at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:53) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:94) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.lambda$beforeStatement$0(JdbcValueBindingsImpl.java:95) at java.base/java.lang.Iterable.forEach(Iterable.java:75) at org.hibernate.engine.jdbc.mutation.spi.BindingGroup.forEachBinding(BindingGroup.java:51) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.beforeStatement(JdbcValueBindingsImpl.java:85) at org.hibernate.engine.jdbc.batch.internal.BatchImpl.lambda$addToBatch$0(BatchImpl.java:129) at org.hibernate.engine.jdbc.mutation.internal.PreparedStatementGroupSingleTable.forEachStatement(PreparedStatementGroupSingleTable.java:59) at org.hibernate.engine.jdbc.batch.internal.BatchImpl.addToBatch(BatchImpl.java:114) at org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleBatched.performBatchedOperations(MutationExecutorSingleBatched.java:60) at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.execute(AbstractMutationExecutor.java:45) at org.hibernate.persister.entity.mutation.UpdateCoordinatorStandard.doDynamicUpdate(UpdateCoordinatorStandard.java:939) at org.hibernate.persister.entity.mutation.UpdateCoordinatorStandard.performUpdate(UpdateCoordinatorStandard.java:279) at org.hibernate.persister.entity.mutation.UpdateCoordinatorStandard.coordinateUpdate(UpdateCoordinatorStandard.java:209) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2739) at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:166) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:616) at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:487) at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:484) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:358) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) 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.flush(SessionImpl.java:1398) at org.hibernate.bugs.ORMUnitTestCase.hhhXXXXXTest(ORMUnitTestCase.java:80) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:45) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: org.h2.jdbc.JdbcSQLDataException: Invalid value "3" for parameter "parameterIndex" [90008-214] at org.h2.message.DbException.getJdbcSQLException(DbException.java:646) at org.h2.message.DbException.getJdbcSQLException(DbException.java:477) at org.h2.message.DbException.get(DbException.java:223) at org.h2.message.DbException.getInvalidValueException(DbException.java:298) at org.h2.jdbc.JdbcPreparedStatement.setParameter(JdbcPreparedStatement.java:1395) at org.h2.jdbc.JdbcPreparedStatement.setInt(JdbcPreparedStatement.java:359) at org.hibernate.type.descriptor.jdbc.IntegerJdbcType$1.doBind(IntegerJdbcType.java:72) at org.hibernate.type.descriptor.jdbc.BasicBinder.bind(BasicBinder.java:61) at org.hibernate.engine.jdbc.mutation.internal.JdbcValueBindingsImpl.lambda$beforeStatement$0(JdbcValueBindingsImpl.java:87) ... 38 more Test scenario to be attached ( https://hibernate.atlassian.net/browse/HHH-16352#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16352#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16345) PostgreSQL*ProcedureTest.testProcedureWithJDBCByName fails with EnterpriseDB

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16345) PostgreSQL*ProcedureTest.testProcedureWithJDBCByName fails with EnterpriseDB

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16345 ( https://hibernate.atlassian.net/browse/HHH-16345?atlOrigin=eyJpIjoiYTFiNW... ) Re: PostgreSQL*ProcedureTest.testProcedureWithJDBCByName fails with EnterpriseDB ( https://hibernate.atlassian.net/browse/HHH-16345?atlOrigin=eyJpIjoiYTFiNW... ) Are you saying that the EDB driver supports named parameters on CallableStatement , or is it just that it throws a different error? Can you please post the stack trace? As far as I understand the JDBC specification, a query like {{ {call sp_count_phones(?,?)} }} should allow using named parameters, where the names should refer to the parameter names of the stored procedure parameters as specified in the stored procedure definition. ( https://hibernate.atlassian.net/browse/HHH-16345#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16345#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Jan Schumacher (JIRA)

Jan Schumacher ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=60d46a1... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiNmI3ZW... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiNmI3ZW... ) @Christian Beikov I had to change the test a little bit, for some reason the entity wasn’t fetchable by id. https://github.com/jan-schumacher/KotlinJpaInheritanceIssue/tree/5.6.15.F... ( https://github.com/jan-schumacher/KotlinJpaInheritanceIssue/tree/5.6.15.F... ) ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Jan Schumacher (JIRA)

Jan Schumacher ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=60d46a1... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiZjMyNT... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiZjMyNT... ) Thats interesting! That actually works. In both 6.1 and 6.2.I will provide an example for you with hibernate 5 ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiNTMyOD... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiNTMyOD... ) I don’t know how this could have worked in Hibernate 5, you’d have to show me a reproducer for that, but since Kotlin creates a new field for every overridden property, you have to use property access with Hibernate. For Kotlin, this usually means that you have to prefix your annotations with @get: i.e. @get:Id etc. so that Hibernate uses Getter/Setter for interacting with objects instead of fields. ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Jan Schumacher (JIRA)

Jan Schumacher ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=60d46a1... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiMmQ3MW... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiMmQ3MW... ) @Christian Beikov Thanks for replying! I tried that and got the same behaviour. See branch https://github.com/jan-schumacher/KotlinJpaInheritanceIssue/tree/6.2.0.RC... ( https://github.com/jan-schumacher/KotlinJpaInheritanceIssue/tree/6.2.0.RC... ) ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16266) Error when using @Query with EmbeddedId after upgrading to Spring Boot 3.0.4

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16266 ( https://hibernate.atlassian.net/browse/HHH-16266?atlOrigin=eyJpIjoiY2JhOW... ) Re: Error when using @Query with EmbeddedId after upgrading to Spring Boot 3.0.4 ( https://hibernate.atlassian.net/browse/HHH-16266?atlOrigin=eyJpIjoiY2JhOW... ) > > > > I think if there is a alias used in the top query and no alias used in the > sub query, then the auto interpretation should be that the id attribute if > used as such (id.queryId) should belong to the subquery right? > > Well, it’s a 50:50 thing. Some people are going to argue for one or the other interpretation. We chose the sensible way, which is to throw an error if there is an ambiguity. It wasn’t really defined what Hibernate 5 did in this case, so maybe it was doing the wrong thing for you all along! Be happy that you can now disambiguate this matter by introducing aliases like you should have done in the first place. ( https://hibernate.atlassian.net/browse/HHH-16266#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16266#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16300) PrePersist not executed with ManyToMany Jointable nested entity

by Christian Beikov (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16300) PrePersist not executed with ManyToMany Jointable nested entity

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16300 ( https://hibernate.atlassian.net/browse/HHH-16300?atlOrigin=eyJpIjoiZTcwMG... ) Re: PrePersist not executed with ManyToMany Jointable nested entity ( https://hibernate.atlassian.net/browse/HHH-16300?atlOrigin=eyJpIjoiZTcwMG... ) This mapping makes absolutely no sense. Use two one-to-many mappings instead: @Entity @Table(name = "bar" ) public class Bar { @GeneratedValue(strategy = GenerationType.IDENTITY) @Id private Long id; @OneToMany(mappedBy = "bar" ) private List<FooBar> fooBars; } @Entity @Table(name = "foo" ) public class Foo { @GeneratedValue(strategy = GenerationType.IDENTITY) @Id private Long id; @ManyToMany(mappedBy = "foo" , cascade = CascadeType.ALL) private List<FooBar> fooBars; } @Entity @Table(name = "foo_bar" ) public class FooBar { @GeneratedValue(strategy = GenerationType.IDENTITY) @Id private Long id; @ManyToOne(fetch = FetchType.LAZY) private Bar bar; @ManyToOne(fetch = FetchType.LAZY) private Foo foo; private String note; @PrePersist void prePersist(){ setNote( "XXXXX" ); } } ( https://hibernate.atlassian.net/browse/HHH-16300#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16300#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15874) Can't access override property in sub-class when use kotlin data class

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15874 ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiOTlkND... ) Re: Can't access override property in sub-class when use kotlin data class ( https://hibernate.atlassian.net/browse/HHH-15874?atlOrigin=eyJpIjoiOTlkND... ) Please test again with 6.2.0.CR4 ( https://hibernate.atlassian.net/browse/HHH-15874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15874#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16350) PreLoadEvent listeners might receive PreLoadEvent with null state

by Jones (JIRA)

Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDkwMTQxZDdi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16350?atlOrigin=eyJpIjoiZDkwMT... ) HHH-16350 ( https://hibernate.atlassian.net/browse/HHH-16350?atlOrigin=eyJpIjoiZDkwMT... ) PreLoadEvent listeners might receive PreLoadEvent with null state ( https://hibernate.atlassian.net/browse/HHH-16350?atlOrigin=eyJpIjoiZDkwMT... ) Change By: Jones ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) PreLoadEvent listeners might receive events with null state, which never happened in hibernate 5 {code:java}@Entity @Table(name = "ENTITY_A") public class EntityA { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "ID") Integer id; }{code} {code:java}public class MyPreLoadEventListener implements PreLoadEventListener { @Override public void onPreLoad(PreLoadEvent event) { assertThat(event.getState()).isNotNull(); } }{code} {code:java} @Test public void foobarTest() throws Exception { // BaseCoreFunctionalTestCase automatically creates the SessionFactory and // provides the Session. try (Session s = openSession()) { Transaction tx = s.beginTransaction(); EntityA entityA1 = new EntityA(); s.persist(entityA1); tx.commit(); } try (Session s = openSession()) { Transaction tx = s.beginTransaction(); String hql = "select e from org.hibernate.bugs.EntityA e"; Query<EntityA> query = s.createQuery(hql, EntityA.class); List<EntityA> actual = query.list(); assertThat(actual).hasSize(1); tx.rollback(); } }{code} Test case to be attached and also available here [https://github.com/ratoaq2/HHH-16350|https://github.com/ratoaq2/HHH-16350...] ( https://hibernate.atlassian.net/browse/HHH-16350#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16350#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#100219- sha1:eb3f1fe )

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16350) PreLoadEvent listeners might receive PreLoadEvent with null state

by Jones (JIRA)

3 years, 3 months

1
0
0 / 0

[JIRA] (HHH-16351) Migrating from 5.6 to 6.1 to_timestamp(double) function now throws QueryException

by Richard Turner (JIRA)

Richard Turner ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bed604... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDQ0OWFjODVh... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16351?atlOrigin=eyJpIjoiZDQ0OW... ) HHH-16351 ( https://hibernate.atlassian.net/browse/HHH-16351?atlOrigin=eyJpIjoiZDQ0OW... ) Migrating from 5.6 to 6.1 to_timestamp(double) function now throws QueryException ( https://hibernate.atlassian.net/browse/HHH-16351?atlOrigin=eyJpIjoiZDQ0OW... ) Issue Type: Improvement Affects Versions: 6.1.7 Assignee: Unassigned Components: query-hql Created: 22/Mar/2023 03:56 AM Environment: hubernate 6.1, java 17, postgresql 14 Priority: Major Reporter: Richard Turner ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bed604... ) Upgrading to Hibernate 6.1 from 5.6 now throws a QueryException where it used to work OK; the exception states: function to_timestamp() has type STRING, but argument is of type java.lang.Double For the following query: entityManager.createQuery( "select r from Realm r where r.notBefore is null or r.notBefore = 0 or to_timestamp(r.notBefore) <= now()" , Realm.class ).getResultList(); Seems that hibernate no longer recognises the alternative to_timestamp(double) The dialect is being autodetected as org.hibernate.dialect.PostgreSQLDialect ; I don’t know the internals of Hibernate to understand where this validation check is performed (I cannot see any mention of to_timestamp in the dialect code. Is this breaking change expected? I couldn’t see anything in the release notes related to this but appreciate a lot has changed in 6.x. I can work around the problem but would like to understand what has changed and also feel this should be documented if not already. ( https://hibernate.atlassian.net/browse/HHH-16351#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16351#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#100219- sha1:eb3f1fe )

3 years, 3 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 March 2023