August 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16990) Add support for @Type @JdbcTypeCode @UuidGenerator to XML mapping

by Christian Beikov (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17054) The existence of curly braces in the native query impact the eager fetch

by Eka (JIRA)

Eka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGM0OWNiNjNk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-17054?atlOrigin=eyJpIjoiNGM0OW... ) HHH-17054 ( https://hibernate.atlassian.net/browse/HHH-17054?atlOrigin=eyJpIjoiNGM0OW... ) The existence of curly braces in the native query impact the eager fetch ( https://hibernate.atlassian.net/browse/HHH-17054?atlOrigin=eyJpIjoiNGM0OW... ) Issue Type: Bug Affects Versions: 6.2.1 Assignee: Unassigned Components: hibernate-core Created: 09/Aug/2023 01:48 AM Environment: OS: Ubuntu 20.04.6 LTS JDK: openjdk version "17.0.5" 2022-10-18 LTS Priority: Minor Reporter: Eka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) Hi guys, our team tries to upgrade Hibernate from 5.3.3 to 6.2.1, I have a question now. Do the curly braces in the native query impact the eager fetch? I have a PortfolioRuleCheck entity that has a bag setting using lazy="false" for the PortfolioRuleCheckComment entity. Due to the lazy="false" setting, the native query for PORTFOLIO_RULE_CHECK should also retrieve associated PORTFOLIO_RULE_CHECK_COMMENT entries. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd" > <hibernate-mapping> <class name= "abc.core.model.PortfolioRuleCheck" table= "PORTFOLIO_RULE_CHECK" > ... ... <bag name= "comments" cascade= "all" order-by= "createDate asc" lazy= "false" > <key column= "ruleCheckId" not-null= "true" foreign-key= "RULE_CHECK_COMMENT_UFK" /> <one-to-many class= "abc.core.model.PortfolioRuleCheckComment" /> </bag> ... ... </class> </hibernate-mapping> It works in Hibernate 5.3.3 but doesn't work in Hibernate 6.2.1. // Execute the native query with {} public List<PortfolioRuleCheck> getPortfolioRuleChecksWithParentheses() { final String sql = "select {p.*} from PORTFOLIO_RULE_CHECK p" ; final NativeQuery query = getSession().createNativeQuery(sql); query.addRoot( "p" , PortfolioRuleCheck.class); return query.list(); } -- The script when executing getPortfolioRuleChecksWithParentheses in Hibernate 5.3.3, it tries to query PORTFOLIO_RULE_CHECK & PORTFOLIO_RULE_CHECK_COMMENT 2023-08-07 09:57:48 [61993] [main] DEBUG [ SQL ] select p.ID as ID1_131_0_, p. Rule as Rule2_131_0_, p.Portfolio as Portfoli3_131_0_, p.Client as Client4_131_0_, p.Depot as Depot5_131_0_, p. Security as Security6_131_0_, p.Currency as Currency7_131_0_, p.FxOutright as FxOutrig8_131_0_, p.Visibility as Visibili9_131_0_, p.ValuationDate as Valuati10_131_0_, p.MaxLossInPeriod as MaxLoss11_131_0_, p.Priority as Priorit12_131_0_, p.Erroneous as Erroneo13_131_0_, p.Compliant as Complia14_131_0_, p.OverRuled as OverRul15_131_0_, p.Subject as Subject16_131_0_, p. Object as Object17_131_0_, p.Predicate as Predica18_131_0_, p.BreachDate as BreachD19_131_0_, p.acknowledged as acknowl20_131_0_, p.notified as notifie21_131_0_, p.AcknowledgedDate as Acknowl22_131_0_, p.CreateDate as CreateD23_131_0_, p.ModifyDate as ModifyD24_131_0_, p. Process as Process25_131_0_, p.issue as issue26_131_0_, p.DESCRIPTION as DESCRIP27_131_0_ from PORTFOLIO_RULE_CHECK p 2023-08-07 09:57:48 [61993] [main] DEBUG [ SQL ] select comments0_.ruleCheckId as ruleChec5_132_0_, comments0_.ID as ID1_132_0_, comments0_.ID as ID1_132_1_, comments0_.author as author2_132_1_, comments0_.content as content3_132_1_, comments0_.createDate as createDa4_132_1_ from PORTFOLIO_RULE_CHECK_COMMENT comments0_ where comments0_.ruleCheckId=? order by comments0_.createDate asc 2023-08-07 09:57:48 [61993] [main] DEBUG [ SQL ] select comments0_.ruleCheckId as ruleChec5_132_0_, comments0_.ID as ID1_132_0_, comments0_.ID as ID1_132_1_, comments0_.author as author2_132_1_, comments0_.content as content3_132_1_, comments0_.createDate as createDa4_132_1_ from PORTFOLIO_RULE_CHECK_COMMENT comments0_ where comments0_.ruleCheckId=? order by comments0_.createDate asc --The script when executing getPortfolioRuleChecksWithParentheses in Hibernate 6.2.1, only fetches PORTFOLIO_RULE_CHECK 2023-08-07 10:03:24 [63363] [main] DEBUG [ SQL ] select p.ID id1_131_0_,p.acknowledged acknowl20_131_0_,p.AcknowledgedDate acknowl22_131_0_,p.BreachDate breachd19_131_0_,p.Client client4_131_0_,p.Compliant complia14_131_0_,p.CreateDate created23_131_0_,p.Currency currency7_131_0_,p.Depot depot5_131_0_,p.DESCRIPTION descrip27_131_0_,p.Erroneous erroneo13_131_0_,p.FxOutright fxoutrig8_131_0_,p.issue issue26_131_0_,p.MaxLossInPeriod maxloss11_131_0_,p.ModifyDate modifyd24_131_0_,p.notified notifie21_131_0_,p. Object object17_131_0_,p.OverRuled overrul15_131_0_,p.Portfolio portfoli3_131_0_,p.Predicate predica18_131_0_,p.Priority priorit12_131_0_,p. Process process25_131_0_,p. Rule rule2_131_0_,p. Security security6_131_0_,p.Subject subject16_131_0_,p.ValuationDate valuati10_131_0_,p.Visibility visibili9_131_0_ from PORTFOLIO_RULE_CHECK p ( https://hibernate.atlassian.net/browse/HHH-17054#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17054#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#100234- sha1:9e2db29 )

1 year, 1 month

1
0
0 / 0

[JIRA] (HHH-17051) Default behavior for datatype Instant with a Oracle database does not behave as expected.

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-17051 ( https://hibernate.atlassian.net/browse/HHH-17051?atlOrigin=eyJpIjoiZWE0ZG... ) Re: Default behavior for datatype Instant with a Oracle database does not behave as expected. ( https://hibernate.atlassian.net/browse/HHH-17051?atlOrigin=eyJpIjoiZWE0ZG... ) > > > > Have read the migration guide, and kind of read this “if possible, and > falls back to timestamp " = will work. > > The “if possible” part refers to dialect capability. > > > > This config-change, will it work in the long run (incubating)? > > We might change the way how this is configured to have a uniform configuration for all non-trivial Java types, but yes, you will always have an option to configure the default. I’d recommend you to change the datatype on the database side though and avoid the configuration, because this will avoid possible confusions about “what time zone is that timestamp in?”. > > > > I can understand the asking for trouble, problem here is our database is > already there, and it worked in hibernate 5.x > > You’re doing a major version upgrade from Hibernate 5 to 6, so these sorts of behavior changes should be expected. That’s what major versions are for. If Hibernate 6 we were fully backwards compatible, we would have called it Hibernate 5.7. > > > > So what do you suggest we should do in this case, to be future proof? > > You can use the config for the meantime until you finish your migration, but long term, I’d suggest you get rid off the columnDefinition in your entity model and change the database type to timestamp with time zone. ( https://hibernate.atlassian.net/browse/HHH-17051#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17051#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#100234- sha1:9e2db29 )

1 year, 1 month

1
0
0 / 0

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

by Koen Aers (JIRA)

1 year, 1 month

1
0
0 / 0

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

by Koen Aers (JIRA)

1 year, 1 month

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)

1 year, 1 month

1
0
0 / 0

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

by Koen Aers (JIRA)

1 year, 1 month

1
0
0 / 0

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

by Koen Aers (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HBX-2134) Resolve test errors/failures for Oracle

by Koen Aers (JIRA)

1 year, 1 month

1
0
0 / 0

[JIRA] (HBX-1404) Guard against connection leaks

by Koen Aers (JIRA)

1 year, 1 month

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