June 2020 - hibernate-issues - Jboss List Archives

[JIRA] (BVAL-752) Automatically break large collections into chunks

by Peter Holvenstot (JIRA)

Peter Holvenstot ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Bean Validation ( https://hibernate.atlassian.net/browse/BVAL?atlOrigin=eyJpIjoiNDUwMGNkZmR... ) / Improvement ( https://hibernate.atlassian.net/browse/BVAL-752?atlOrigin=eyJpIjoiNDUwMGN... ) BVAL-752 ( https://hibernate.atlassian.net/browse/BVAL-752?atlOrigin=eyJpIjoiNDUwMGN... ) Automatically break large collections into chunks ( https://hibernate.atlassian.net/browse/BVAL-752?atlOrigin=eyJpIjoiNDUwMGN... ) Issue Type: Improvement Assignee: Unassigned Created: 10/Jun/2020 13:54 PM Priority: Major Reporter: Peter Holvenstot ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Oracle has a limit of 1000 elements in an 'in' clause collection. If you need to check more than 1000 elements you need to break it into two clauses. For example: "select from Person where firstName IN (:largeCollection " can be transformed into: "select from Person where (firstName IN :largeCollection1 or firstName IN :largeCollection2 or firstName IN largeCollection3 ...)" Can the task of breaking the collection into sub-collections of 1000 and modifying the string be added to the Oracle dialect automatically if a collection of above 1000 elements is used as a parameter? ( https://hibernate.atlassian.net/browse/BVAL-752#add-comment?atlOrigin=eyJ... ) Add Comment ( https://hibernate.atlassian.net/browse/BVAL-752#add-comment?atlOrigin=eyJ... ) 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#100128- sha1:0213fc8 )

5 years, 10 months

1
0
0 / 0

[JIRA] (BVAL-751) Collection padding for Oracle queries

by Peter Holvenstot (JIRA)

Peter Holvenstot ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Bean Validation ( https://hibernate.atlassian.net/browse/BVAL?atlOrigin=eyJpIjoiOWYyN2FhMjZ... ) / Improvement ( https://hibernate.atlassian.net/browse/BVAL-751?atlOrigin=eyJpIjoiOWYyN2F... ) BVAL-751 ( https://hibernate.atlassian.net/browse/BVAL-751?atlOrigin=eyJpIjoiOWYyN2F... ) Collection padding for Oracle queries ( https://hibernate.atlassian.net/browse/BVAL-751?atlOrigin=eyJpIjoiOWYyN2F... ) Issue Type: Improvement Assignee: Unassigned Created: 10/Jun/2020 13:47 PM Priority: Minor Reporter: Peter Holvenstot ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Oracle matches its query planning cache using an exact hash of the SQL string (with bind variable placeholders). This means, for example, the query "select * from Person where person.firstName IN ('Larry', 'Curly')" will not hit the same query plan as the query "select * from Person where person.firstName IN ('Larry','Curly','Moe')". The trivial solution to this is to pad all collections to the maximum size (1000 elements) by repeating one of the elements. For example: "select * from Person where person.FirstName IN ('Larry','Curly','Larry','Larry','Larry' .... )". It can be seen that this is logically equivalent to the first query yet we can fill any number of elements up to the maximum and hit the same query plan. Having to manually alter every collection every place an "in" query is used is undesirable, and mucks up things because now the translated HQL string (when printed for debuggin) gets clumsy and has needless repetition. Could this be integrated into the Oracle dialect so that it happens automatically? ( https://hibernate.atlassian.net/browse/BVAL-751#add-comment?atlOrigin=eyJ... ) Add Comment ( https://hibernate.atlassian.net/browse/BVAL-751#add-comment?atlOrigin=eyJ... ) 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#100128- sha1:0213fc8 )

5 years, 10 months

1
0
0 / 0

[JIRA] (HHH-7135) NoSuchElementException in AnnotationBinder.makeInheritanceJoinColumns() when Joined subclass mixed with @MapsId foreign-key id

by Ondřej Fischer (JIRA)

Ondřej Fischer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5e7e3d1... ) *commented* on HHH-7135 ( https://hibernate.atlassian.net/browse/HHH-7135?atlOrigin=eyJpIjoiZmE3YjZ... ) Re: NoSuchElementException in AnnotationBinder.makeInheritanceJoinColumns() when Joined subclass mixed with @MapsId foreign-key id ( https://hibernate.atlassian.net/browse/HHH-7135?atlOrigin=eyJpIjoiZmE3YjZ... ) Hi, I'm facing the same issue in version 5.4.10.Final, but cannot update the affected version. The problem I see is in the class DependantValue . This one on one hand extends SimpleValue, so it inherits field: private final List<Selectable> columns; which is initialized to empty list. On the other hand, it's a wrapper on top of delegated value from the parent entity, which is referenced by field: private KeyValue wrappedValue; The wrappedValue has proper columns available. But the DependantValue doesn't delegate call getColumnIterator() to the wrappedValue. It simply inherits this method, so it accesses it's empty list of columns instead of returning the wrapped one. The MapsId logic is using this iterator, and in turn tries to map from empty iterator to non-empty list of columns, which hits the NoSuchElementException when calling next() on empty iterator (without testing hasNext() first). ( https://hibernate.atlassian.net/browse/HHH-7135#add-comment?atlOrigin=eyJ... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-7135#add-comment?atlOrigin=eyJ... ) 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#100128- sha1:0213fc8 )

5 years, 10 months

1
0
0 / 0

[JIRA] (HSEARCH-3946) Remove the reference to SearchContext in predicate builders

by Yoann Rodière (JIRA)

5 years, 10 months

1
0
0 / 0

[JIRA] (HSEARCH-3946) Remove the reference to SearchContext in predicate builders

by Yoann Rodière (JIRA)

5 years, 10 months

1
0
0 / 0

[JIRA] (HBX-2044) Update Hibernate ORM dependency to 5.5.0-SNAPSHOT

by Koen Aers (JIRA)

5 years, 10 months

1
0
0 / 0

[JIRA] (HHH-11490) UUID mapped as GEOMETRY with PostGisDialect

by Ulrich Knaack (JIRA)

Ulrich Knaack ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ec50ef... ) *commented* on HHH-11490 ( https://hibernate.atlassian.net/browse/HHH-11490?atlOrigin=eyJpIjoiNWRkN2... ) Re: UUID mapped as GEOMETRY with PostGisDialect ( https://hibernate.atlassian.net/browse/HHH-11490?atlOrigin=eyJpIjoiNWRkN2... ) same issue with JDK 11, Hibernate 5.4.12 and PostgreSQl 12. Replacing {{ @Column(name = "ident") @Type(type = "pg-uuid") }} with @Column(name="ident", columnDefinition = "uuid" ) solved the problem for me. ( https://hibernate.atlassian.net/browse/HHH-11490#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-11490#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#100128- sha1:0213fc8 )

5 years, 10 months

1
0
0 / 0

[JIRA] (HBX-2044) Update Hibernate ORM dependency to 5.5.0-SNAPSHOT

by Koen Aers (JIRA)

5 years, 10 months

1
0
0 / 0

[JIRA] (HBX-2043) Set up 5.5 branch

by Koen Aers (JIRA)

5 years, 10 months

1
0
0 / 0

[JIRA] (HSEARCH-3517) Optimize the computation of total hit count

by Yoann Rodière (JIRA)

5 years, 10 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues June 2020