June 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16874) Hibernate 6 NativeQuery doesn't allow setting Array[] Parameter of Database Function

by Pedro Vitor (JIRA)

Pedro Vitor ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5daa227... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzVhODljNWQy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16874?atlOrigin=eyJpIjoiNzVhOD... ) HHH-16874 ( https://hibernate.atlassian.net/browse/HHH-16874?atlOrigin=eyJpIjoiNzVhOD... ) Hibernate 6 NativeQuery doesn't allow setting Array[] Parameter of Database Function ( https://hibernate.atlassian.net/browse/HHH-16874?atlOrigin=eyJpIjoiNzVhOD... ) Issue Type: Bug Affects Versions: 6.2.4 Assignee: Unassigned Components: hibernate-core, hibernate-orm-modules Created: 29/Jun/2023 13:12 PM Environment: Java: 20 Wildfly: 27.0.1.Final Hibernate: 6.2.4.Final PostgreSQL: 15 Operating System: Windows 11 Priority: Major Reporter: Pedro Vitor ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5daa227... ) I am encountering an issue with Hibernate 6's NativeQuery when trying to pass a parameter of type array to a database function. The problem arises when the parameter is passed as a single value or as a list of values. The issue occurs in the following method: public Integer getTotalHousedPoultry(List<Long> idOwners) { // Query StringBuilder sql = new StringBuilder("SELECT calculate_batch_poultry_quantity_housed_with_mortality_on_date(:idOwners)"); try { NativeQuery<Integer> query = getSession().createNativeQuery(sql.toString(), Integer.class); query.setParameterList("idOwners", idOwners); return query.getSingleResult(); } catch (Exception ex) { printError(getClass(), ex); return 0; } } The function declaration in the database is as follows: CREATE FUNCTION calculate_batch_poultry_quantity_housed_with_mortality_on_date(id_owners BIGINT[]); *Details:* * When a single value is passed in the parameter *(list size equals 1)* , the following error occurs: ERROR: function calculate_batch_poultry_quantity_housed_with_mortality_on_date(bigint) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 * When two or more values are passed in the parameter *(list size greater than 1)* , the following error occurs: ERROR: function calculate_batch_poultry_quantity_housed_with_mortality_on_date(record) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 *Attempted Solutions:* I have tried converting the list to an array using idOwners.toArray() when setting the parameter, but the same issue persists. I also attempted to pass the parameter as a direct string in the SQL query using the syntax "ARRAY [1, 2] ". Although *this approach seems to work* , it is not a recommended solution as the *syntax for array parameters may vary across different database systems* , posing compatibility issues. *Expected Behavior:* The Hibernate NativeQuery should correctly pass the parameter as bigint[] to match the function declaration in the database, regardless of whether it is a single value or a list of values. ( https://hibernate.atlassian.net/browse/HHH-16874#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16874#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#100227- sha1:d7f1864 )

11 months, 3 weeks

1
0
0 / 0

[JIRA] (HHH-16868) IN clause with more than 1000 expressions

by Jan Schatteman (JIRA)

11 months, 3 weeks

1
0
0 / 0

[JIRA] (HHH-16873) Expose fast-path cloning constructors for UpdateCoordinatorStandard

by Sanne Grinovero (JIRA)

Sanne Grinovero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2RmMWFkZjdl... ) / Task ( https://hibernate.atlassian.net/browse/HHH-16873?atlOrigin=eyJpIjoiN2RmMW... ) HHH-16873 ( https://hibernate.atlassian.net/browse/HHH-16873?atlOrigin=eyJpIjoiN2RmMW... ) Expose fast-path cloning constructors for UpdateCoordinatorStandard ( https://hibernate.atlassian.net/browse/HHH-16873?atlOrigin=eyJpIjoiN2RmMW... ) Issue Type: Task Assignee: Sanne Grinovero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: hibernate-core Created: 29/Jun/2023 12:30 PM Fix Versions: 6.3.0, 6.2.6 Priority: Major Reporter: Sanne Grinovero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Original estimate: 0.5h Remaining Estimate: 0.5h Hibernate Reactive is extending UpdateCoordinatorStandard and is going to need to construct such instances at runtime; in Hibernate ORM this type is constructed just once at boottime, so it performs some preparation work during its regular constructor. I’m introducing a new protected constructor to allow subclasses to efficiently clone themselves. Safe to backport as it has no impact on semantics. ( https://hibernate.atlassian.net/browse/HHH-16873#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16873#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#100227- sha1:d7f1864 )

11 months, 3 weeks

1
0
0 / 0

[JIRA] (HHH-16872) JDBC fetch size seems to be ignored post migration to hibernate6

by Sunil Bm (JIRA)

11 months, 3 weeks

1
0
0 / 0

[JIRA] (HHH-16872) JDBC fetch size seems to be ignored post migration to hiberante6

by Sunil Bm (JIRA)

11 months, 3 weeks

1
0
0 / 0

[JIRA] (HHH-16872) JDBC fetch size seems to be ignored

by Sunil Bm (JIRA)

11 months, 3 weeks

1
0
0 / 0

[JIRA] (HSEARCH-4884) Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4884 ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiYzZ... ) Re: Configuration property to have a dedicated docvalue field for the root document id in the Lucene backend's document ( https://hibernate.atlassian.net/browse/HSEARCH-4884?atlOrigin=eyJpIjoiYzZ... ) The configuration property was named hibernate.search.backend.schema.id.strategy and can be set to either lucene8 (the default) or lucene9 (for forward-compatibility of index content). ( https://hibernate.atlassian.net/browse/HSEARCH-4884#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4884#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#100227- sha1:d7f1864 )

11 months, 3 weeks

1
0
0 / 0

[JIRA] (HHH-16868) IN clause with more than 1000 expressions

by Jan Schatteman (JIRA)

11 months, 3 weeks

1
0
0 / 0

[JIRA] (HHH-16247) Criteria Query with Object-Typed Embedded Parameter throws AssertionError

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16247 ( https://hibernate.atlassian.net/browse/HHH-16247?atlOrigin=eyJpIjoiYjFiNm... ) Re: Criteria Query with Object-Typed Embedded Parameter throws AssertionError ( https://hibernate.atlassian.net/browse/HHH-16247?atlOrigin=eyJpIjoiYjFiNm... ) Folks, I’m not sure this issue was correctly-resolved. My read of the issue description is that the issue here is that an AssertionError was thrown instead of a meaningful exception. It’s not clear why we need to accept this code, and accepting it requires we do something inconsistent in the type checking logic. But perhaps there was extra discussion of this issue elsewhere that I’ve missed. ( https://hibernate.atlassian.net/browse/HHH-16247#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16247#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#100227- sha1:d7f1864 )

11 months, 3 weeks

1
0
0 / 0

[JIRA] (HHH-16766) Unable to fully load entity with IdClass lazily or with max fetch depth

by James Bodkin (JIRA)

James Bodkin ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61f7ce4... ) *commented* on HHH-16766 ( https://hibernate.atlassian.net/browse/HHH-16766?atlOrigin=eyJpIjoiYWIxMm... ) Re: Unable to fully load entity with IdClass lazily or with max fetch depth ( https://hibernate.atlassian.net/browse/HHH-16766?atlOrigin=eyJpIjoiYWIxMm... ) I’ve managed to come up with a patch for the Hibernate 6.1 branch (as this is what we’re using) that fixes the test cases in the issue. What are the next steps? hibernate-fix.patch ( https://hibernate.atlassian.net/rest/api/3/attachment/content/50480 ) ( https://hibernate.atlassian.net/browse/HHH-16766#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16766#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#100227- sha1:d7f1864 )

11 months, 3 weeks

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues June 2023