April 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16489) Hibernate native query returns duplicate column values with addScalar() call

by Puhong You (JIRA)

Puhong You ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTRiODFmMTkz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16489?atlOrigin=eyJpIjoiNTRiOD... ) HHH-16489 ( https://hibernate.atlassian.net/browse/HHH-16489?atlOrigin=eyJpIjoiNTRiOD... ) Hibernate native query returns duplicate column values with addScalar() call ( https://hibernate.atlassian.net/browse/HHH-16489?atlOrigin=eyJpIjoiNTRiOD... ) Issue Type: Bug Affects Versions: 6.2.1 Assignee: Unassigned Components: query-sql Created: 18/Apr/2023 11:05 AM Priority: Major Reporter: Puhong You ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) **Setup Create a User table – USER_ID integer not null primary key, USER_NAME varchar(256) not null, Insert a row into this table – (1, ‘Joe Doe’) **Junit test code {{ String sql = "SELECT user_id FROM SCHEMA.USER WHERE user_name = 'Joe Doe'; }} {{ // obtain a hibernate session here}} {{ NativeQuery<Integer> query = session.createNativeQuery(sql, Integer.class);}} {{ query.addScalar("user_id", StandardBasicTypes.INTEGER);}} {{ List<Integer> rsList = query.list();}} {{ assertNotNull(rsList);}} {{ assertEquals(1, rsList.size());}} {{ assertEquals(Integer.valueOf(1), rsList.get(0));}} **Error org.opentest4j.AssertionFailedError: expected: <1> but was: < [1, 1] > Expected :1 Actual :[Ljava.lang.Object;@71b6ccab **Observation if I remove the query.addScalar() line, the test works. ( https://hibernate.atlassian.net/browse/HHH-16489#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16489#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#100222- sha1:c08beee )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16475) Migration from hibernate 5 to 6 and metamodels not being generated

by arquadrado (JIRA)

arquadrado ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16475 ( https://hibernate.atlassian.net/browse/HHH-16475?atlOrigin=eyJpIjoiNjc1ND... ) Re: Migration from hibernate 5 to 6 and metamodels not being generated ( https://hibernate.atlassian.net/browse/HHH-16475?atlOrigin=eyJpIjoiNjc1ND... ) In the end, after two days after this thing, the issue was due to the replace of javax by jakarta. Apparently DataSource still needs to come from javax and this was causing errors during the compilation that were buried under the missing meta models, that weren’t generated because of them. Fun life. Thank you ( https://hibernate.atlassian.net/browse/HHH-16475#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16475#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#100222- sha1:c08beee )

2 years, 12 months

1
0
0 / 0

[JIRA] (HHH-16475) Migration from hibernate 5 to 6 and metamodels not being generated

by arquadrado (JIRA)

arquadrado ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16475 ( https://hibernate.atlassian.net/browse/HHH-16475?atlOrigin=eyJpIjoiMDY5N2... ) Re: Migration from hibernate 5 to 6 and metamodels not being generated ( https://hibernate.atlassian.net/browse/HHH-16475?atlOrigin=eyJpIjoiMDY5N2... ) The error I am getting is that the meta models cannot be found in the task :compileJava Here’s the exact message: FacetField.java:7: error: cannot find symbol import my.package.domain.Customer_; symbol: class Customer_ location: my.package.domain This is expected because I don’t have any generated class in my build folder. Since this project is too big and was something that inherited I cannot post here every configuration but I’ll describe what I tried. Here it goes: 1. created a new springboot project with the version before the upgrade, 2.7.5 and 5.6.8 for spring boot and hibernate respectively. 2. Ran the application and everything was fine. Metamodels generated and app runs without any problem. 3. I upgrade the versions for the last available version, 3.0.0 and 6.2.1.Final, for spring boot and hibernate respectively. 4. Ran the application and everything was fine. Metamodels generated and app runs without any problem. At this point I noticed some differences in my `build.gradle` for both application and did the adaptation in the original app. It looks like this at this point: dependencies { implementation 'org.springframework.boot:spring-boot-starter-web' implementation 'org.springframework.boot:spring-boot-starter-data-jpa' implementation group: 'org.liquibase' , name: 'liquibase-core' , version: '4.21.1' implementation group: 'org.liquibase.ext' , name: 'liquibase-hibernate6' , version: '4.21.1' implementation group: 'org.postgresql' , name: 'postgresql' , version: '42.3.4' implementation group: 'org.hibernate.orm' , name: 'hibernate-core' , version: '6.2.1.Final' implementation group: 'org.hibernate.validator' , name: 'hibernate-validator' , version: '8.0.0.Final' compileOnly 'org.projectlombok:lombok' compileOnly 'org.hibernate.orm:hibernate-jpamodelgen' annotationProcessor 'org.projectlombok:lombok' annotationProcessor 'org.hibernate.orm:hibernate-jpamodelgen' testImplementation 'org.springframework.boot:spring-boot-starter-test' } I tried to build the original application again and the problem remained so I thought that maybe the original build.gradle had something there that was messing things up. Following this line of thought I decided to copy this whole file to the my test application and try to run the build there. It worked with no problem, so now I know that the problem is not in build.gradle but I am without a clue of what might be the problem. I tried to check the application.yaml s to see if there is something related to the metamodel generation there but without a find, I tried to look for some java configuration but with same result. The build logs don’t point to any error regarding jpamodel, missing dependency or any problem. It complains right away because of the missing classes as I first described. I honestly don’t know where to turn to at this point. Any guidance on what I should try next would be much appreciated. ( https://hibernate.atlassian.net/browse/HHH-16475#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16475#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#100222- sha1:c08beee )

2 years, 12 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)

2 years, 12 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 Automation for Jira (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HBX-2127) Resolve test errors/failures for MySQL

by Koen Aers (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HBX-2073) Investigate and reenable failing test 'org.hibernate.tool.hbm2x.hbm2hbmxml.FormulaTest.TestCase#testReadable()'

by Koen Aers (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HBX-2064) Investigate class 'org.hibernate.tool.ide.completion.HQLAnalyzer' to fix the failing test 'org.hibernate.tool.ide.completion.HqlAnalyzer.TestCase. testShouldShowTables()'

by Koen Aers (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HBX-1413) Fix the identity detection in SQLServerMetaDataDialect

by Koen Aers (JIRA)

2 years, 12 months

1
0
0 / 0

[JIRA] (HBX-1412) Implement identity detection in the OracleMetaDataDialect

by Koen Aers (JIRA)

2 years, 12 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 April 2023