March 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16305) A problem occurred in the SQL executor : JDBC parameter value not bound

by David Kronhardt (JIRA)

David Kronhardt ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6410855... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzFmZTQ1YTY3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16305?atlOrigin=eyJpIjoiMzFmZT... ) HHH-16305 ( https://hibernate.atlassian.net/browse/HHH-16305?atlOrigin=eyJpIjoiMzFmZT... ) A problem occurred in the SQL executor : JDBC parameter value not bound ( https://hibernate.atlassian.net/browse/HHH-16305?atlOrigin=eyJpIjoiMzFmZT... ) Issue Type: Bug Affects Versions: 6.1.7, 6.2.0.CR3 Assignee: Unassigned Components: hibernate-core Created: 14/Mar/2023 08:18 AM Priority: Major Reporter: David Kronhardt ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6410855... ) Using a parameter in select inside a function and in where clause results in an exception: JDBC parameter value not bound A similar issue was already reported and fixed. But it is still happening if the parameter is itself a parameter of a function. Minimal Spring Boot project reproducing the problem: https://github.com/dakr0013/hibernate-issue ( https://github.com/dakr0013/hibernate-issue ) , same example with hibernate 5.6.15 where it was working: https://github.com/dakr0013/hibernate-issue/tree/old ( https://github.com/dakr0013/hibernate-issue/tree/old ) A small example query which causes the exception: select DATEDIFF(e.date, :date) from SomeEntity e where :date < e.date Those queries work fine: select DATEDIFF(e.date, :date) from SomeEntity e select :date from SomeEntity e where :date < e.date Related issue: https://hibernate.atlassian.net/browse/HHH-16137 ( https://hibernate.atlassian.net/browse/HHH-16137 ) ( https://hibernate.atlassian.net/browse/HHH-16305#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16305#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#100217- sha1:7167dc8 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiODViOT... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiODViOT... ) Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) FYI when the default DDL type is used the problem is similar to https://hibernate.atlassian.net/browse/HHH-16166 ( https://hibernate.atlassian.net/browse/HHH-16166 ) , since the two subclasses have the same attribute name ( property ) but different types we try to read the JSON with the first of the two types when querying using the superclass. ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100217- sha1:7167dc8 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HSEARCH-4810) Fix flaky test with MSSQL

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4810 ( https://hibernate.atlassian.net/browse/HSEARCH-4810?atlOrigin=eyJpIjoiZDF... ) Re: Fix flaky test with MSSQL ( https://hibernate.atlassian.net/browse/HSEARCH-4810?atlOrigin=eyJpIjoiZDF... ) Reproduced rather easily, for once. Deadlock report: <deadlock> <victim-list> <victimProcess id="process21c64494108" /> </victim-list> <process-list> <process id="process21c64494108" taskpriority="0" logused="0" waitresource="PAGE: 5:1:833 " waittime="2494" ownerId="134881" transactionname="implicit_transaction" lasttranstarted="2023-03-14T08:06:08.063" XDES="0x21c6b9dc428" lockMode="S" schedulerid="2" kpid="856" status="suspended" spid="66" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2023-03-14T08:06:08.063" lastbatchcompleted="2023-03-14T08:06:08.063" lastattention="1900-01-01T00:00:00.063" clientapp="Microsoft JDBC Driver for SQL Server" hostname="yrodiere.redhat" hostpid="68718" loginname="sa" isolationlevel="read committed (2)" xactid="134881" currentdb="5" currentdbname="testdb" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058"> <executionStack> <frame procname="adhoc" line="1" stmtend="158" sqlhandle="0x02000000a7beca34b34c9166a637b2ed0afcfdac78b782870000000000000000000000000000000000000000"> unknown </frame> <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"> unknown </frame> </executionStack> <inputbuf> select count(outboxeven0_.id) as col_0_0_ from HSEARCH_OUTBOX_EVENT outboxeven0_ </inputbuf> </process> <process id="process21c5ec0e4e8" taskpriority="0" logused="10960" waitresource="PAGE: 5:1:832 " waittime="2491" ownerId="134851" transactionname="implicit_transaction" lasttranstarted="2023-03-14T08:06:08.060" XDES="0x21c6df10428" lockMode="IX" schedulerid="3" kpid="9788" status="suspended" spid="63" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2023-03-14T08:06:08.063" lastbatchcompleted="2023-03-14T08:06:08.063" lastattention="1900-01-01T00:00:00.063" clientapp="Microsoft JDBC Driver for SQL Server" hostname="yrodiere.redhat" hostpid="68718" loginname="sa" isolationlevel="read committed (2)" xactid="134851" currentdb="5" currentdbname="testdb" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058"> <executionStack> <frame procname="adhoc" line="1" stmtstart="42" stmtend="130" sqlhandle="0x0200000066e46c36decc042a72978b306c1239da133500ed0000000000000000000000000000000000000000"> unknown </frame> <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"> unknown </frame> </executionStack> <inputbuf> (@P0 varbinary(8000))delete from HSEARCH_OUTBOX_EVENT where id=@P0 </inputbuf> </process> </process-list> <resource-list> <pagelock fileid="1" pageid="833" dbid="5" subresource="FULL" objectname="testdb.dbo.HSEARCH_OUTBOX_EVENT" id="lock21c5ef0da00" mode="IX" associatedObjectId="72057594055360512"> <owner-list> <owner id="process21c5ec0e4e8" mode="IX" /> </owner-list> <waiter-list> <waiter id="process21c64494108" mode="S" requestType="wait" /> </waiter-list> </pagelock> <pagelock fileid="1" pageid="832" dbid="5" subresource="FULL" objectname="testdb.dbo.HSEARCH_OUTBOX_EVENT" id="lock21c5d0a6400" mode="S" associatedObjectId="72057594055360512"> <owner-list> <owner id="process21c64494108" mode="S" /> </owner-list> <waiter-list> <waiter id="process21c5ec0e4e8" mode="IX" requestType="wait" /> </waiter-list> </pagelock> </resource-list> </deadlock> ( https://hibernate.atlassian.net/browse/HSEARCH-4810#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4810#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#100217- sha1:7167dc8 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Marco Belladelli (JIRA)

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiODNhNT... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiODNhNT... ) Ok thanks. We’ll check it out then. ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100217- sha1:7167dc8 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-15929) Mapping jsonb of different types in a class inheritance hierarchy does not work.

by Thomas Bosch (JIRA)

Thomas Bosch ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c19f84... ) *commented* on HHH-15929 ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiNDM2Yz... ) Re: Mapping jsonb of different types in a class inheritance hierarchy does not work. ( https://hibernate.atlassian.net/browse/HHH-15929?atlOrigin=eyJpIjoiNDM2Yz... ) Sorry, but no change in behaviour. Property currently looks like @JdbcTypeCode(SqlTypes.JSON) @Type(JsonType.class) private PropertyTypeA property = new PropertyTypeA(); With this the deserialisation gets in trouble … look into my GitHub repo. When I remove @Type(JsonType.class) the exception from some comments ago occurs again. ( https://hibernate.atlassian.net/browse/HHH-15929#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15929#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#100217- sha1:7167dc8 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16304) unquotedCaseStrategy defaults to UPPER with Sybase

by Martin Simka (JIRA)

Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTMzYTFmMGY5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16304?atlOrigin=eyJpIjoiZTMzYT... ) HHH-16304 ( https://hibernate.atlassian.net/browse/HHH-16304?atlOrigin=eyJpIjoiZTMzYT... ) unquotedCaseStrategy defaults to UPPER with Sybase ( https://hibernate.atlassian.net/browse/HHH-16304?atlOrigin=eyJpIjoiZTMzYT... ) Issue Type: Bug Affects Versions: 6.2.0.CR3 Assignee: Unassigned Components: hibernate-core Created: 14/Mar/2023 07:51 AM Environment: Hibernate ORM 6.2.0.CR3 + Sybase 16.0 + Sybase JDBC driver (jConnect (TM) for JDBC(TM)/16.0 SP04 PL03 (Build 27544) + extra connection parameters: `SQLINITSTRING=set quoted_identifier on&SQLINITSTRING=set ansinull on` Priority: Critical Reporter: Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) unquotedCaseStrategy defaults to UPPER and it is causing test failures in schema validation tests, an example from EnumValidationTest : org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [TestEntity] at app//org.hibernate.tool.schema.internal.AbstractSchemaValidator.validateTable(AbstractSchemaValidator.java:134) at app//org.hibernate.tool.schema.internal.GroupedSchemaValidatorImpl.validateTables(GroupedSchemaValidatorImpl.java:46) at app//org.hibernate.tool.schema.internal.AbstractSchemaValidator.performValidation(AbstractSchemaValidator.java:97) at app//org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:75) at app//org.hibernate.orm.test.schemavalidation.EnumValidationTest.doValidation(EnumValidationTest.java:116) at app//org.hibernate.orm.test.schemavalidation.EnumValidationTest.testValidation(EnumValidationTest.java:111) 09:46:25,413 DEBUG IdentifierHelperBuilder:89 - JDBC driver metadata reported database stores unquoted identifiers in neither upper, lower nor mixed case 09:46:25,414 DEBUG IdentifierHelperBuilder:116 - JDBC driver metadata reported database stores quoted identifiers in neither upper, lower nor mixed case it then defaults to https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/m... ( https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/m... ) private IdentifierCaseStrategy unquotedCaseStrategy = IdentifierCaseStrategy.UPPER; private IdentifierCaseStrategy quotedCaseStrategy = IdentifierCaseStrategy.MIXED; and then it fails to find a table in [ https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/m... ( https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/m... ) because "TestEntity != "TESTENTITY". List of affected tests: org.hibernate.orm.test.tool.schema.SchemaToolTransactionHandlingTest.testValidateInExistingJtaTransaction org.hibernate.orm.test.schemaupdate.ColumnNamesTest.testSchemaUpdateWithQuotedColumnNames org.hibernate.orm.test.schemavalidation.EnumValidationTest.testValidation org.hibernate.orm.test.schemavalidation.InstantValidationTest.testValidation org.hibernate.orm.test.schemavalidation.LongVarcharValidationTest.testValidation org.hibernate.orm.test.schemavalidation.NumericValidationTest.testValidation org.hibernate.orm.test.version.db.DbVersionTest.testCollectionNoVersion ( https://hibernate.atlassian.net/browse/HHH-16304#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16304#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#100217- sha1:7167dc8 )

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16237) versionUpdateGroup is null for Enity extending another Entity when only ElementCollection is updated.

by Marco Belladelli (JIRA)

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-13627) Updated items do not get invalidated when cachemode is set to CacheMode.GET

by Marco Belladelli (JIRA)

3 years, 1 month

1
0
0 / 0

[JIRA] (HHH-16280) Fix Jackson XML mapper support for Oracle Array data types

by Marco Belladelli (JIRA)

3 years, 1 month

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