May 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-15125) Create a new SQL Formatter

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15125 ( https://hibernate.atlassian.net/browse/HHH-15125?atlOrigin=eyJpIjoiYzBkZj... ) Re: Create a new SQL Formatter ( https://hibernate.atlassian.net/browse/HHH-15125?atlOrigin=eyJpIjoiYzBkZj... ) 100% agree that we should do this. ( https://hibernate.atlassian.net/browse/HHH-15125#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15125#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:a994ca2 )

1 year, 7 months

1
0
0 / 0

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

by Sanne Grinovero (JIRA)

Sanne Grinovero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16697 ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiOTY5Yj... ) Re: CALCULATED FIELDS in createNativeQuery doExtract integer insted of BigDecimals. ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiOTY5Yj... ) Hi Isaac Vásquez ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=627d288... ) , thanks for the report but please don’t assign issues to specific individuals - anyone chooses were to invest their own time. ( 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:a994ca2 )

1 year, 7 months

1
0
0 / 0

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

by Sanne Grinovero (JIRA)

1 year, 7 months

1
0
0 / 0

[JIRA] (HHH-16725) Persisting multiple entities with one-many association and composite key with ordered updates enabled fails

by Andrea Boriero (JIRA)

1 year, 7 months

1
0
0 / 0

[JIRA] (HHH-16686) LocalTime to java.sql.Time unwrap bug.

by Andrea Boriero (JIRA)

1 year, 7 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... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZmZhZTIwZjlk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiZmZhZT... ) HHH-16697 ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiZmZhZT... ) CALCULATED FIELDS in createNativeQuery doExtract integer insted of BigDecimals. ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiZmZhZT... ) Change By: Isaac Vásquez ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=627d288... ) Having Hi, The Oracle PL/SQL Native SUM function (calcaulated field) is not working as expected, it is converting float to integer values, the next is a following code example : { code:java noformat }@Override public ArrayList<Object[]> getEncMorososNotificados testSUMError ( String pTipo, String pFechaInicio, String pFechaFin, String pNotificador ) { Session session = sessionFactory.getCurrentSession(); StringBuilder consulta Query objQuery = new StringBuilder(); String vNotificador = ""; if (pTipo session. equals createNativeQuery (" 3 " )) { vNotificador = pNotificador; } try { consulta.append( " "" SELECT C 19. NUM_NOTIFICACION 80 COLUMN_OK , 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 39. FNC_NOTIFICACION_COBRO (C.GIS, C.CEDULA, C.NUM_AVISO, TO_NUMBER (C.NUM_NOTIFICACION 74 ) , NULL, 3)) NOTIFICADO, COLUMN_FAIL \ 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)\ DUAL """ ); 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); noformat } }{code} All If we test the calculated fields, ex. SELECT the return object is: {noformat}SUM(SERV_TRIBUTARIOS !imagen-20230531-171622. FNC_NOTIFICACION_COBRO (C.GIS png|width=1254 , C.CEDULA, C.NUM_AVISO, TO_NUMBER (C.NUM_NOTIFICACION), NULL, 1)) PENDIENTE{noformat} height=329! Are returning Integer data, but the expected field have decimals. Debugging a little the excecution, what I as you can see is that , the “doExtract“ 39 is calling the IntegerJdbcType for some reason ({{The trace below was generated with the intention of seeing what was going on not even rounding , it only deletes the actual execution is error free}}) {noformat} at oracle decimals. 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){noformat} ( 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:a994ca2 )

1 year, 7 months

1
0
0 / 0

[JIRA] (HHH-16250) Mapping same column twice and one of them using a custom type leads to "Unknown wrap conversion requested"

by Christian Beikov (JIRA)

1 year, 7 months

1
0
0 / 0

[JIRA] (HHH-16490) The discriminator type mapper overrides any custom type specfied for a field mapped over the same column

by Christian Beikov (JIRA)

1 year, 7 months

1
0
0 / 0

[JIRA] (HHH-16728) Optimise iteration of AssociationType properties within a Persister

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=eyJpIjoiYWExMTA4MTRi... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16728?atlOrigin=eyJpIjoiYWExMT... ) HHH-16728 ( https://hibernate.atlassian.net/browse/HHH-16728?atlOrigin=eyJpIjoiYWExMT... ) Optimise iteration of AssociationType properties within a Persister ( https://hibernate.atlassian.net/browse/HHH-16728?atlOrigin=eyJpIjoiYWExMT... ) Issue Type: Improvement Assignee: Sanne Grinovero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: hibernate-core Created: 31/May/2023 09:57 AM Fix Versions: 6.3.0 Labels: performance Priority: Minor Reporter: Sanne Grinovero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) AbstractEntityInitializer apparently needs to go through all properties in a hot loop to find if there’s any unique key that needs processing. This is unusually costly, we can avoid it by precomputing the set of unique keys at cost of exposing a new getter on EntityPersister. ( https://hibernate.atlassian.net/browse/HHH-16728#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16728#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:a994ca2 )

1 year, 7 months

1
0
0 / 0

[JIRA] (HHH-16721) HQL with subquery with entity path at least two levels deep produces wrong SQL

by Nemanja Jovanovic (JIRA)

1 year, 7 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues May 2023