May 2023 - hibernate-issues - Jboss List Archives

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *deleted* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzUyNWY3NGJk... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-16689?atlOrigin=eyJpIjoiMzUyNW... ) HHH-16689 ( https://hibernate.atlassian.net/browse/HHH-16689?atlOrigin=eyJpIjoiMzUyNW... ) 支持tongweb应用服务器事务管理 ( https://hibernate.atlassian.net/browse/HHH-16689?atlOrigin=eyJpIjoiMzUyNW... ) 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#100225- sha1:0428b75 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16590) Schema update: PostgreSQL byte array does not accept length as parameter

by Christian Beikov (JIRA)

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16512) Bidirectional OneToOne association produces wrong isNull predicate in criteria query

by Christian Beikov (JIRA)

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16698) @Any Polymorphic Association Ignores @Column Insertable/Updatable Attributes

by Chris Cobham (JIRA)

Chris Cobham ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMmRmMWViNDIz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16698?atlOrigin=eyJpIjoiMmRmMW... ) HHH-16698 ( https://hibernate.atlassian.net/browse/HHH-16698?atlOrigin=eyJpIjoiMmRmMW... ) @Any Polymorphic Association Ignores @Column Insertable/Updatable Attributes ( https://hibernate.atlassian.net/browse/HHH-16698?atlOrigin=eyJpIjoiMmRmMW... ) Issue Type: Bug Affects Versions: 6.2.0, 6.2.1, 6.2.2, 6.2.3 Assignee: Unassigned Components: hibernate-core Created: 25/May/2023 11:18 AM Priority: Major Reporter: Chris Cobham ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) Starting in Hibernate ORM 6.2, polymorphic associations using @Any raise MappingException}}s if either the key or discriminator column is mapped to another (mutable) attribute in the owning entity. This prevents read-only {{@Any associations in which the duplicated column mappings cannot be defined with @Column(insertable=false, updatable=false) *Solution* package org.hibernate.mapping; ... public class Any extends SimpleValue { ... public void setDiscriminator(BasicValue discriminatorDescriptor) { this.discriminatorDescriptor = discriminatorDescriptor; if ( discriminatorDescriptor.getColumn() instanceof Column ) { // Current: justAddColumn( (Column) discriminatorDescriptor.getColumn() ); justAddColumn( (Column) discriminatorDescriptor.getColumn(), // Pass insertable/updatable from discriminatorDescriptor discriminatorDescriptor.isColumnInsertable(0), discriminatorDescriptor.isColumnUpdateable(0) ); } else { justAddFormula( (Formula) discriminatorDescriptor.getColumn() ); } } ... public void setKey(BasicValue keyDescriptor) { this.keyDescriptor = keyDescriptor; if ( keyDescriptor.getColumn() instanceof Column ) { // Current: justAddColumn( (Column) keyDescriptor.getColumn() ); justAddColumn( (Column) keyDescriptor.getColumn(), // Pass insertable/updatable from keyDescriptor keyDescriptor.isColumnInsertable(0), keyDescriptor.isColumnUpdateable(0) ); } else { justAddFormula( (Formula) keyDescriptor.getColumn() ); } } } ( https://hibernate.atlassian.net/browse/HHH-16698#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16698#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#100225- sha1:0428b75 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16697) CALCULATED FIELDS in createNativeQuery doExtract integer insted of BigDecimals.

by Isaac Vásquez (JIRA)

Isaac Vásquez ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=627d288... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMmMwMDNjMDg2... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiMmMwMD... ) HHH-16697 ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiMmMwMD... ) CALCULATED FIELDS in createNativeQuery doExtract integer insted of BigDecimals. ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiMmMwMD... ) Issue Type: Bug Affects Versions: 6.2.0, 6.2.1, 6.2.2, 6.2.3 Assignee: Unassigned Components: hibernate-core Created: 25/May/2023 10:19 AM Environment: Hibernate-core 6.2.2.Final Java 17 Jakarta 10 Spring Boot 3.1.0 Priority: Major Reporter: Isaac Vásquez ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=627d288... ) Having the following code: @Override public ArrayList< Object []> getEncMorososNotificados( String pTipo, String pFechaInicio, String pFechaFin, String pNotificador) { Session session = sessionFactory.getCurrentSession(); StringBuilder consulta = new StringBuilder(); String vNotificador = ""; if (pTipo.equals( "3" )) { vNotificador = pNotificador; } try { consulta.append(""" SELECT C.NUM_NOTIFICACION, C.NUM_AVISO, C.GIS, C.CEDULA, C.RAZON_SOCIAL, C.TELEFONO, C.FEC_NOTIFICACION, C.ENTREGADO, C.FEC_ENTREGA, C.COD_NOTIFICADOR, C.OBSERVACION, C.USUA_REGIST, C.NO_ENTREGADO, C.FEC_NO_ENTREGADO, \ C.FEC_DESBLOQUEO, SUM(SERV_TRIBUTARIOS.FNC_NOTIFICACION_COBRO (C.GIS, C.CEDULA, C.NUM_AVISO, TO_NUMBER (C.NUM_NOTIFICACION), NULL, 3)) NOTIFICADO, \ SUM(SERV_TRIBUTARIOS.FNC_NOTIFICACION_COBRO (C.GIS, C.CEDULA, C.NUM_AVISO, TO_NUMBER (C.NUM_NOTIFICACION), NULL, 1)) PENDIENTE, \ SUM(SERV_TRIBUTARIOS.FNC_NOTIFICACION_COBRO (C.GIS, C.CEDULA, C.NUM_AVISO, TO_NUMBER (C.NUM_NOTIFICACION), C.NUM_PAGO, 4)) CANCELADO, \ SUM(SERV_TRIBUTARIOS.FNC_NOTIFICACION_COBRO (C.GIS, C.CEDULA, C.NUM_AVISO, TO_NUMBER (C.NUM_NOTIFICACION), C.NUM_PAGO, 5)) ELIMINADO \ FROM (SELECT DISTINCT A.NUM_NOTIFICACION, A.NUM_AVISO, D.GIS, D.CEDULA, A.RAZON_SOCIAL, A.TELEFONO, TO_CHAR (A.FEC_NOTIFICACION, 'YYYY-MM-DD' ) FEC_NOTIFICACION, A.ENTREGADO, TO_CHAR (A.FEC_ENTREGA, 'YYYY-MM-DD' ) FEC_ENTREGA, \ A.COD_NOTIFICADOR, A.OBSERVACION, A.USUA_REGIST, A.NO_ENTREGADO, TO_CHAR (A.FEC_NO_ENTREGADO, 'YYYY-MM-DD' ) FEC_NO_ENTREGADO, TO_CHAR (A.FEC_DESBLOQUEO, 'YYYY-MM-DD' ) FEC_DESBLOQUEO, D.NUM_PAGO \ FROM SERV_TRIBUTARIOS.NOTIF_AVISO_COBRO_ENC A, SERV_TRIBUTARIOS.NOTIF_AVISO_COBRO_DET D \ WHERE A.COD_CIA = '01' \ AND D.CEDULA = A.CEDULA \ AND A.NUM_NOTIFICACION = D.NUM_NOTIFICACION \ AND A.NUM_AVISO = D.NUM_AVISO \ AND D.CEDULA NOT IN (SELECT DISTINCT CEDULA FROM MUNI.EXCLU_CED_LISTADOS WHERE TIPO_PROCESO = '01' ) \ AND A.COD_NOTIFICADOR = NVL(:pNotificador, A.COD_NOTIFICADOR)\ """); switch (pTipo) { case "1" : consulta.append(""" AND A.FEC_ENTREGA BETWEEN TO_DATE(:pFechaInicio, 'YYYY-MM-DD' ) AND TO_DATE(:pFechaFin, 'YYYY-MM-DD' ) \ AND NVL(A.ENTREGADO, 'N' ) = 'S' \ ORDER BY A.NUM_NOTIFICACION) C \ """); break ; case "2" : consulta.append(""" AND A.FEC_NOTIFICACION BETWEEN TO_DATE(:pFechaInicio, 'YYYY-MM-DD' ) AND TO_DATE(:pFechaFin, 'YYYY-MM-DD' ) \ AND NVL(A.NO_ENTREGADO, 'N' ) = 'S' \ ORDER BY A.NUM_NOTIFICACION) C \ """); break ; case "3" : consulta.append(""" AND A.FEC_NOTIFICACION BETWEEN TO_DATE(:pFechaInicio, 'YYYY-MM-DD' ) AND TO_DATE(:pFechaFin, 'YYYY-MM-DD' ) \ ORDER BY D.CEDULA, A.NUM_AVISO) C \ """); break ; default : break ; } consulta.append(""" GROUP BY C.NUM_NOTIFICACION, C.NUM_AVISO, C.GIS, C.CEDULA, C.RAZON_SOCIAL, C.TELEFONO, C.FEC_NOTIFICACION, C.ENTREGADO, C.FEC_ENTREGA, C.COD_NOTIFICADOR, C.OBSERVACION, C.USUA_REGIST, \ C.NO_ENTREGADO, C.FEC_NO_ENTREGADO, C.FEC_DESBLOQUEO\ """); Query objQuery = session.createNativeQuery(consulta.toString(), Object.class); objQuery.setParameter( "pFechaInicio" , pFechaInicio); objQuery.setParameter( "pFechaFin" , pFechaFin); objQuery.setParameter( "pNotificador" , vNotificador); objQuery.setCacheable( true ); return (ArrayList< Object []>) objQuery.list(); } catch (HibernateException ex) { throw LoggerManager.throwException(ex); } } All the calculated fields, ex. SUM(SERV_TRIBUTARIOS.FNC_NOTIFICACION_COBRO (C.GIS, C.CEDULA, C.NUM_AVISO, TO_NUMBER (C.NUM_NOTIFICACION), NULL, 1)) PENDIENTE Are returning Integer data, but the expected field have decimals. Debugging a little the excecution, what I can see is that the “doExtract“ is calling the IntegerJdbcType for some reason ( The trace below was generated with the intention of seeing what was going on, the actual execution is error free ) at oracle.jdbc.driver.GeneratedScrollableResultSet.getInt(GeneratedScrollableResultSet.java:246) at org.hibernate.type.descriptor.jdbc.IntegerJdbcType$2.doExtract(IntegerJdbcType.java:88) at org.hibernate.type.descriptor.jdbc.BasicExtractor.extract(BasicExtractor.java:44) at org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.readCurrentRowValues(JdbcValuesResultSetImpl.java:262) ( https://hibernate.atlassian.net/browse/HHH-16697#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16697#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#100225- sha1:0428b75 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16696) hibernate-core >= 6.2.0 stopped invoking PostgreSQLDialect.initializeFunctionRegistry(QueryEngine)

by Suhhoruki Mihhail (JIRA)

Suhhoruki Mihhail ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ca46c8... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDBkZTY1OTQz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiMDBkZT... ) HHH-16696 ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiMDBkZT... ) hibernate-core >= 6.2.0 stopped invoking PostgreSQLDialect.initializeFunctionRegistry(QueryEngine) ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiMDBkZT... ) Issue Type: Bug Affects Versions: 6.2.0 Assignee: Unassigned Components: hibernate-core Created: 25/May/2023 08:32 AM Priority: Major Reporter: Suhhoruki Mihhail ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ca46c8... ) Using custom dialect extending PostgreSQLDialect and configured with hibernate.dialect: com.xyz.repository.CustomPostgresqlDialect hibernate-core starting with 6.2.0 stopped invoking initializeFunctionRegistry: custom dialect: public class CustomPostgresqlDialect extends PostgreSQLDialect { public CustomPostgresqlDialect() { super(DatabaseVersion.make(14, 4)); } public CustomPostgresqlDialect(DialectResolutionInfo info) { super(info); } public CustomPostgresqlDialect(DatabaseVersion version) { super(version); } public CustomPostgresqlDialect(DatabaseVersion version, PostgreSQLDriverKind driverKind) { super(version); } @Override public void initializeFunctionRegistry(QueryEngine queryEngine) { super.initializeFunctionRegistry(queryEngine); queryEngine.getSqmFunctionRegistry().register(PostgresqlJsonArrayFunction.NAME, new PostgresqlJsonArrayFunction()); } } ( https://hibernate.atlassian.net/browse/HHH-16696#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16696#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#100225- sha1:0428b75 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16668) ConcurrentModificationException when using a criteria with window functions in hibernate 6

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16668 ( https://hibernate.atlassian.net/browse/HHH-16668?atlOrigin=eyJpIjoiNjZlZD... ) Re: ConcurrentModificationException when using a criteria with window functions in hibernate 6 ( https://hibernate.atlassian.net/browse/HHH-16668?atlOrigin=eyJpIjoiNjZlZD... ) Thank you for spotting this! ( https://hibernate.atlassian.net/browse/HHH-16668#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16668#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#100225- sha1:0428b75 )

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16668) ConcurrentModificationException when using a criteria with window functions in hibernate 6

by Marco Belladelli (JIRA)

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16668) ConcurrentModificationException when using a criteria with window functions in hibernate 6

by Marco Belladelli (JIRA)

1 year, 3 months

1
0
0 / 0

[JIRA] (HHH-16668) ConcurrentModificationException when using a criteria with window functions in hibernate 6

by Marco Belladelli (JIRA)

1 year, 3 months

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