May 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16732) HQL id() function does not work for @Any mappings

by Gavin King (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16732) HQL id() function does not work for @Any mappings

by Gavin King (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16731) lots of unhelpful error messages for incomplete @Any mappings

by Gavin King (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16731) lots of unhelpful error messages for incomplete `@Any` mappings

by Gavin King (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16730) joining @Any mappings

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZWUxMGVjODU5... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16730?atlOrigin=eyJpIjoiZWUxMG... ) HHH-16730 ( https://hibernate.atlassian.net/browse/HHH-16730?atlOrigin=eyJpIjoiZWUxMG... ) joining @Any mappings ( https://hibernate.atlassian.net/browse/HHH-16730?atlOrigin=eyJpIjoiZWUxMG... ) Issue Type: Improvement Assignee: Unassigned Created: 31/May/2023 15:20 PM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) So I’ve just woken up to how hard it really is to do something like join fetch an @Any mapping. I got some distance with this by mapping the association @Any(fetch=LAZY) , and then using a query like this: select n, p from N n join P p on n.thing.id = p.id And then as long as I remember to force-initialize n.thing before the tx ends, it essentially works. There’s three things wrong with this: * it’s pretty verbose, * I have to explicitly force-initialize the proxies, and * if I switch to @Any(fetch=EAGER) (which is the default, ugh) then I start getting n+1 selects. So, damn, it would sure be nice to be able to write things like: select n, t from N n join n.thing t select n from N n join fetch n.thing select n, p from N n join treat (n.thing as P) p select n from N n join fetch treat (n.thing as P) But I would say the highest priority would be to simply fix the problem that fetch=EAGER automatically results in extra unnecessary selects. ( https://hibernate.atlassian.net/browse/HHH-16730#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16730#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16729) Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16729 ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiNDQ3ZW... ) Re: Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiNDQ3ZW... ) Look, the more constraints you pile on, the less likely you are to find a solution. It’s OK to ask for a pony, but hoping for a pony and a unicorn and a friendly dragon all at the same time might just be pushing it. If I were you I would be asking myself which three of those requirements I might be able to relax and still make my program do what it needs to do. ( https://hibernate.atlassian.net/browse/HHH-16729#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16729#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16729) Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy

by Guillaume Toison (JIRA)

Guillaume Toison ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HHH-16729 ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiYWNlOW... ) Re: Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiYWNlOW... ) Thanks for replying, I am aware of Hibernate.isInstance() and Hibernate.unproxy() methods but if possible I’d like to be able to write idiomatic Java code, for instance: if (food instanceof Cheese cheese) { // use the cheese } Instead of: if (Hibernate.isInstance(food, Cheese.class)) { Cheese cheese = Hibernate.unproxy(food, Cheese.class); // use the cheese } One benefit of having the right class is that we wouldn’t need to trigger a load if we just need an instanceof test. I’ve got to admit that I’m not familiar with @Any so I’ll look into that 👍 Some of the associations I have are collections fetched using the new `@SQLSelect` so I’m sure sure if that scenario would be supported. Assuming that item now needs a discriminator, I would need to tell Hibernate where that new column would be, but JPA’s @FieldResult ` does not support it, right? @SqlResultSetMapping(name="OrderResults", entities={ @EntityResult(entityClass=com.acme.Order.class, fields={ @FieldResult(name="id", column="order_id"), @FieldResult(name="quantity", column="order_quantity"), @FieldResult(name="item", column="order_item")}) }) ( https://hibernate.atlassian.net/browse/HHH-16729#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16729#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16729) Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16729 ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiMWZlYm... ) Re: Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiMWZlYm... ) [It’s also unclear from your issue description whether you’re aware of the Hibernate.isInstance() method. ( https://hibernate.atlassian.net/browse/HHH-16729#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16729#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16729) Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16729 ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiNTUwY2... ) Re: Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiNTUwY2... ) What you’re proposing already exists since oooh about HIbernate 2, I guess: the @Any mapping. ( https://hibernate.atlassian.net/browse/HHH-16729#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16729#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16729) Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy

by Guillaume Toison (JIRA)

Guillaume Toison ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjk3YzFiY2M5... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiNjk3Yz... ) HHH-16729 ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiNjk3Yz... ) Instantiate a proxy of the correct class for ManyToOne associated to an inheritance hierarchy ( https://hibernate.atlassian.net/browse/HHH-16729?atlOrigin=eyJpIjoiNjk3Yz... ) Issue Type: Improvement Assignee: Unassigned Created: 31/May/2023 13:15 PM Priority: Major Reporter: Guillaume Toison ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) Consider the following entities (getters, setters and PK omitted): class Container { @ManyToOne(fetch = FetchType.LAZY) @Fetch(FetchMode.SELECT) Food food; } @Inheritance(strategy = InheritanceType.SINGLE_TABLE) class Food { } class Cheese extends Food { } class Fruit extends Food { } When loading a Container object, Hibernate creates an uninitialized proxy for the associated Food. The class of that proxy extends Food So tests like container.getFood() instanceof Cheese will return false, even if the underlying instance might be of that type. Since Hibernate 6.2 @Proxy(lazy = false) is deprecated. This was one way to get the correct java class, with the drawback that it effectively disabled lazy-loading. Assuming that the Container table has a new food_type discriminator column next to the food_id FK column, Hibernate could use that new information to create a proxy of the correct class. This would probably entail modifying the mapping, for instance adding a new @ManyToOneDiscriminatorColumn on the association: class Container { @ManyToOne(fetch = FetchType.LAZY) @Fetch(FetchMode.SELECT) @ManyToOneDiscriminatorColumn(name = "food_type") Food food; } An alternative would be that when the discriminator is part of an embedded id, Hibernate uses it create the correct class. Another solution would be an user-supplied service (injected in the SessionFactory) responsible for locating the correct type, based on the ID. This is a continuation of the discussion started here: https://discourse.hibernate.org/t/proxy-deprecated-in-hibernate-6-2/7707 ( https://hibernate.atlassian.net/browse/HHH-16729#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16729#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 )

2 years, 11 months

1
0
0 / 0

[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 )

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

2 years, 11 months

1
0
0 / 0

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

by Sanne Grinovero (JIRA)

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

2 years, 11 months

1
0
0 / 0

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

by Andrea Boriero (JIRA)

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

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

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

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

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

2 years, 11 months

1
0
0 / 0

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

by Isaac Vásquez (JIRA)

2 years, 11 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=eyJpIjoiOTlkMWQwNzE4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiOTlkMW... ) HHH-16697 ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiOTlkMW... ) CALCULATED FIELDS in createNativeQuery doExtract integer insted of BigDecimals. ( https://hibernate.atlassian.net/browse/HHH-16697?atlOrigin=eyJpIjoiOTlkMW... ) Change By: Isaac Vásquez ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=627d288... ) Suitable for new contributors: Yes, likely ( 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 )

2 years, 11 months

1
0
0 / 0

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

by Isaac Vásquez (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16621) Fix migration guide for one-to-one uniqueness

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16613) @Lazy @ManyToOne @Cacheable association is retrieved as initialized

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16682) Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB

by DongHyeon Kim (JIRA)

DongHyeon Kim ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HHH-16682 ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiNDM1Yj... ) Re: Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiNDM1Yj... ) I'm also experiencing the same issue. When mapping json with JdbcTypeCode, changes are not detected unless the field is reassigned. I'm currently using this with Spring Boot 3.0.7 and Kotlin 1.8.21. The issue occurred in Hibernate 6.1.7, and remains the same even after upgrading to 6.2.3. When declared as val map: MutableMap<String, Any?> and set to json via JdbcTypeCode, updates do not occur even when performing actions such as map.put, remove, etc. However, in the case of var map: MutableMap<String, Any?> , updates occur when changed with map = mutableMapOf(...). ( https://hibernate.atlassian.net/browse/HHH-16682#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16682#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-1182) excludePaths on indexedEmbedded

by Automation for Jira (JIRA)

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

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16727) StatelessSession.upsert()

by Gavin King (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16727) StatelessSession.upsert()

by Gavin King (JIRA)

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

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

2 years, 11 months

1
0
0 / 0

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

by Jan Schatteman (JIRA)

2 years, 11 months

1
0
0 / 0

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

by Jan Schatteman (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16726) Relax readability condition for strict read-write cache items.

by Guenther Demetz (JIRA)

Guenther Demetz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiM2ViNDA1OTlm... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16726?atlOrigin=eyJpIjoiM2ViND... ) HHH-16726 ( https://hibernate.atlassian.net/browse/HHH-16726?atlOrigin=eyJpIjoiM2ViND... ) Relax readability condition for strict read-write cache items. ( https://hibernate.atlassian.net/browse/HHH-16726?atlOrigin=eyJpIjoiM2ViND... ) Issue Type: Improvement Affects Versions: 5.6.15, 6.2.3 Assignee: Unassigned Components: hibernate-ehcache, hibernate-jcache Created: 31/May/2023 05:02 AM Environment: Hibernate 5.6, 6.2, Java 17, Windows 11, SQLServer Labels: CacheConcurrencyStrategy.READ_WRITE Priority: Minor Reporter: Guenther Demetz ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Original estimate: 0.33h Remaining Estimate: 0.33h Doing some heavy load-tests using Locust we discovered that performance goes down when multiple threads are filling 2ndLevel cache simultaneously with the same persistent objects. Although all threads have more or less the same transaction start timestamp, when it comes to checking the readability of a read-write cache item, the current logic makes following comparison: public boolean isReadable(long txTimestamp) { return txTimestamp > timestamp; } This implementation considers items unReadable also when the timestamp of current transaction *equals* to the timestamp of the cached item. My proposal is to change the condition to {{ return txTimestamp >= timestamp;}} so that a transaction which started simultaneously with the one that cached the item, can consider valid the puts of other transactions of same age. This has to be modified in: Hibernate 5.6: class org.hibernate.cache.spi.support.AbstractReadWriteAccess.java Hibernate 6: classes org.hibernate.cache.ehcache.internal.strategy.AbstractReadWriteEhcacheAccessStrategy.java & org.hibernate.testing.cache.AbstractReadWriteAccessStrategy.java) By overriding the used region factory the user can choose which granularity he wants for the timestamp comparison, for instance in our use-case we don’t want to go beyond fractions of seconds. public class MyJCacheRegionFactory extends JCacheRegionFactory { // UNIT SECONDS public long nextTimestamp() { return System.currentTimeMillis() / 1000; } ... } Applying these 2 tweaks on hibernate5.6.15 I was able to enhance the performance in remarkable way: 100 threads accessing fresh (empty 2ndLevelCache) persistence at same time. With <property name="hibernate.cache.region.factory_class" value="JCacheRegionFactory"/> Threads ran for 14.231 ms with over 247.000 isReadable calls returning false. <property name="hibernate.cache.region.factory_class" value="MyJCacheRegionFactory"/> Threads ran for 7.365 ms with 0 isReadable calls returning false. ( https://hibernate.atlassian.net/browse/HHH-16726#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16726#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16559) Batch fetch does not initialize bi-directional entity in HQL

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16559) Batch fetch does not initialize bi-directional entity in HQL

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16715) accept value() or element() in place of elements() and key() or index() in place of indices()

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16379) @DynamicUpdate and 'enableDirtyTracking=true' leads to wrong update statement

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16612) NPE on @JdbcTypeCode(SqlTypes.JSON) in combination with explicit @Table name&owner

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16665) False positive HibernateException: Found shared references to a collection with 6.2.2

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16665) False positive HibernateException: Found shared references to a collection with 6.2.2

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16665 ( https://hibernate.atlassian.net/browse/HHH-16665?atlOrigin=eyJpIjoiNzg5Nm... ) Re: False positive HibernateException: Found shared references to a collection with 6.2.2 ( https://hibernate.atlassian.net/browse/HHH-16665?atlOrigin=eyJpIjoiNzg5Nm... ) Thanks Oleksii Miroshnyk ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a157d9... ) for the test and for double-checking. ( https://hibernate.atlassian.net/browse/HHH-16665#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16665#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4859) Add a "type" parameter to APIs that retrieve a parameter of arbitrary type

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiNTkyNzdm... ) / Improvement ( https://hibernate.atlassian.net/browse/HSEARCH-4859?atlOrigin=eyJpIjoiNTk... ) HSEARCH-4859 ( https://hibernate.atlassian.net/browse/HSEARCH-4859?atlOrigin=eyJpIjoiNTk... ) Add a "type" parameter to APIs that retrieve a parameter of arbitrary type ( https://hibernate.atlassian.net/browse/HSEARCH-4859?atlOrigin=eyJpIjoiNTk... ) Issue Type: Improvement Assignee: Unassigned Components: mapper-pojo-base Created: 31/May/2023 02:04 AM Fix Versions: 7.0-backlog Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) See https://github.com/hibernate/hibernate-search/pull/3503#discussion_r11963... We have the same problem in multiple places, e.g.: * org.hibernate.search.mapper.pojo.search.definition.binding.ProjectionBindingContext * org.hibernate.search.mapper.pojo.bridge.binding.BindingContext * org.hibernate.search.engine.search.predicate.definition.PredicateDefinitionContext We should probably deprecate the variants that don’t have a “type” parameter, since people will most likely always need a cast. ( https://hibernate.atlassian.net/browse/HSEARCH-4859#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4859#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#100225- sha1:a994ca2 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16665) False positive HibernateException: Found shared references to a collection with 6.2.2

by Oleksii Miroshnyk (JIRA)

Oleksii Miroshnyk ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a157d9... ) *commented* on HHH-16665 ( https://hibernate.atlassian.net/browse/HHH-16665?atlOrigin=eyJpIjoiYTJkMW... ) Re: False positive HibernateException: Found shared references to a collection with 6.2.2 ( https://hibernate.atlassian.net/browse/HHH-16665?atlOrigin=eyJpIjoiYTJkMW... ) Yeah, seems works better. Please close ( https://hibernate.atlassian.net/browse/HHH-16665#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16665#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16678) AssertionError in QueryLiteral.<init> when using "update versioned Entity ..." if @Version is a long

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16465) CTE query cycle attribute evaluated incorrectly on MSSQL

by Christian Beikov (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16613) @Lazy @ManyToOne @Cacheable association is retrieved as initialized

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16613) @Lazy @ManyToOne @Cacheable association is retrieved as initialized

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16613) @Lazy @ManyToOne @Cacheable association is retrieved as initialized

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16613) @Lazy @ManyToOne @Cacheable association is retrieved as initialized

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16613 ( https://hibernate.atlassian.net/browse/HHH-16613?atlOrigin=eyJpIjoiZDBiNW... ) Re: @Lazy @ManyToOne @Cacheable association is retrieved as initialized ( https://hibernate.atlassian.net/browse/HHH-16613?atlOrigin=eyJpIjoiZDBiNW... ) Reproducer: https://github.com/hibernate/hibernate-orm/pull/6575 ( https://hibernate.atlassian.net/browse/HHH-16613#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16613#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16661) Filters causes NPE when default schema is set

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16664) NPE in MappingMetamodelImpl if inheritance is used in IdClass

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16628) Two transactions within the same session cause unsaved transient instance error

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16639) Cannot load entity with EnumType identifier and batch size > 1

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16682) Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB

by Christian Thiel (JIRA)

Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16682 ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiNjQ0MG... ) Re: Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiNjQ0MG... ) @beikov Do you think it could be a quarkus transaction-hanling issue? ( https://hibernate.atlassian.net/browse/HHH-16682#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16682#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 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16612) NPE on @JdbcTypeCode(SqlTypes.JSON) in combination with explicit @Table name&owner

by Christian Thiel (JIRA)

Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16612 ( https://hibernate.atlassian.net/browse/HHH-16612?atlOrigin=eyJpIjoiODhiMD... ) Re: NPE on @JdbcTypeCode(SqlTypes.JSON) in combination with explicit @Table name&owner ( https://hibernate.atlassian.net/browse/HHH-16612?atlOrigin=eyJpIjoiODhiMD... ) @beikov Do you think it could be a quarkus transaction-hanling issue? ( https://hibernate.atlassian.net/browse/HHH-16612#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16612#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16682) Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16682 ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiMWU0NT... ) Re: Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiMWU0NT... ) Hello! I’ve tried to make just minimal changes to original test case, only to make it similar to other test cases. I can only guess that original problem is in a way how Quarkus is handling transactions. But that is only my guess, I do not know anything about Quarkus. ( https://hibernate.atlassian.net/browse/HHH-16682#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16682#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16682) Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB

by Christian Thiel (JIRA)

Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMmY1Y2ZhZjBk... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiMmY1Y2... ) HHH-16682 ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiMmY1Y2... ) Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiMmY1Y2... ) Change By: Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) I have a JSON-Mapping in my entity {code:java}@Entity public class MyEntity { @Id private Long id; @JdbcTypeCode(SqlTypes.JSON) private MyJson jsonProperty; private String info; }{code} MyJson is a simple POJO: {code:java}@Embeddable public class MyJson { private String stringProp; private Long longProp; }{code} If i change only the jsonProperty, it seems the entity is _not marked dirty_ → changes are not written to the DB. If i change any other field-value, too (in my test-case the String-field _info_), the entity is marked dirty and all changes are written to DB, even the JSON-changes. (see _MyEntityTest.java_ in attached Test-project): {code:java}@QuarkusTest @Transactional(Transactional.TxType.REQUIRES_NEW) class MyEntityTest { @Inject EntityManager em; static final long PK = 123L; static final String CHANGED = "CHANGED"; @Test void shouldCreateUpdateAndSelectMyEntity() throws Exception { insert(); findAndUpdate(); selectFiltered(); } void insert() { MyEntity myEntity = new MyEntity(); myEntity.setId(PK); MyJson myJson = new MyJson(); myJson.setLongProp(100L); myJson.setStringProp("Hello"); myEntity.setJsonProperty(myJson); em.persist(myEntity); } void findAndUpdate() { MyEntity found = em.find(MyEntity.class, PK); found.getJsonProperty().setStringProp(CHANGED); // found.setInfo(CHANGED); // by changing any other property of the entity, it will be marked as dirty and EVERY change will be written to the DB } void selectFiltered() { List<MyEntity> result = em .createQuery("SELECT e FROM MyEntity e WHERE e.jsonProperty.longProp = :x", MyEntity.class) .setParameter("x", 100L) .getResultList(); assertEquals(1, result.size()); assertEquals(CHANGED, result.get(0).getJsonProperty().getStringProp(), "json property not changed"); // assertEquals(CHANGED, result.get(0).getInfo(), "plain property not changed"); //see commented code in method 'findAndUpdate' } }{code} see [https://discourse.hibernate.org/t/changes-in-jsonb-field-do-not-mark-enti...] ( https://hibernate.atlassian.net/browse/HHH-16682#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16682#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16675) Reenable native query OffsetDateTime test after Oracle JDBC update

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16675 ( https://hibernate.atlassian.net/browse/HHH-16675?atlOrigin=eyJpIjoiMjBmMG... ) Re: Reenable native query OffsetDateTime test after Oracle JDBC update ( https://hibernate.atlassian.net/browse/HHH-16675?atlOrigin=eyJpIjoiMjBmMG... ) After some discussions with Oracle JDBC folks, we figured that the JDBC driver should not try to convert between TIMESTAMP_WITHOUT_TIMEZONE and OffsetDateTime. This means that users can’t bind these types to native queries currently, because there we don’t know what JDBC type to use for binding/extraction. We can try to create a special JdbcType that tries to figure out details based on the PreparedStatement and ResultSet , but not sure yet how reliable that could work. ( https://hibernate.atlassian.net/browse/HHH-16675#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16675#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16675) Reenable native query OffsetDateTime test after Oracle JDBC update

by Jean de Lavarene (JIRA)

Jean de Lavarene ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5d13abf... ) *commented* on HHH-16675 ( https://hibernate.atlassian.net/browse/HHH-16675?atlOrigin=eyJpIjoiMTE0Nz... ) Re: Reenable native query OffsetDateTime test after Oracle JDBC update ( https://hibernate.atlassian.net/browse/HHH-16675?atlOrigin=eyJpIjoiMTE0Nz... ) A TIMESTAMP column doesn't include any timezone and hence can't be converted to an OffsetDateTime. This is why the latest driver throws an exception. The previous versions of the driver were assuming a timezone (UTC) for the TIMESTAMP. This was wrong and corrected through a bug fix. So the Hibernate test that is failing should be considered as a negative test and should expect the driver to throw an error. ( https://hibernate.atlassian.net/browse/HHH-16675#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16675#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:d82e018 )

2 years, 11 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... ) *commented* on HHH-16696 ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiNDE4OT... ) Re: hibernate-core >= 6.2.0 stopped invoking PostgreSQLDialect.initializeFunctionRegistry(QueryEngine) ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiNDE4OT... ) It seems that Eclipse was linking to older hibernate-core source when I looked up PostgreSQLDialect hierarchy (hence why it did not complain about the @Override on the old initializeFunctionRegistry ) But as I wrote - your answer led me to find org.hibernate.boot.model.FunctionContributor interface, which can be used to register custom functions without relying on Dialect. ( 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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16722) LocalDateTime values are wrong in START and END Daylight saving (non UTC timezone)

by humbertosales NA (JIRA)

humbertosales NA ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16722 ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiNTU4M2... ) Re: LocalDateTime values are wrong in START and END Daylight saving (non UTC timezone) ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiNTU4M2... ) Workaround with Converters import java.sql.Timestamp; import java.time.LocalDateTime; import java.time.ZoneId; import java.time.ZonedDateTime; import javax.persistence.AttributeConverter; import javax.persistence.Converter; @Converter(autoApply = true ) public class LocalDateTimeToTimestampConverter implements AttributeConverter<LocalDateTime, Timestamp> { @Override public Timestamp convertToDatabaseColumn(LocalDateTime attribute) { ZonedDateTime zonedDateTime = attribute.atZone(ZoneId.of( "UTC" )); return Timestamp.from(zonedDateTime.toInstant()); } @Override public LocalDateTime convertToEntityAttribute(Timestamp dbData) { return dbData.toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime(); } } ( https://hibernate.atlassian.net/browse/HHH-16722#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16722#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:d82e018 )

2 years, 11 months

1
0
0 / 0

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

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTgyZmI5MTU1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNTgyZm... ) HHH-16725 ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNTgyZm... ) Persisting multiple entities with one-many association and composite key with ordered updates enabled fails ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNTgyZm... ) Change By: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Having a model: {code:java}@Entity @IdClass(IdClass.class) class EntityClass { @Id private String string; @Id private int integer; @ManyToOne private EntityClass parent; @OneToMany(mappedBy = "parent") private List<EntityClass> children = new ArrayList<>(); } class IdClass { private String string; private int integer; }{code} and setting {{hibernate.order_updates}} set to {{true}} leads to an exception when multiple entities of such type are persisted within the same transaction. The problem is caused by {{ExecutableList#add()}}. Since the setting requires sorting, adding a new action tries to call compare method to see if sorting is required. But since the entity is using a composite ID the {{VirtualIdEmbeddable#compare()}} is called with {{IdClass}} instances passed into it, while {{getAttributeMappings()}} returns the attributes of {{EntityClass}} as a result: {noformat}PropertyAccessException: Error accessing field [EntityClass.integer] by reflection for persistent property [EntityClass#integer] : IdClass{..}{noformat} is thrown. I will submit a PR with the test case for this ([https://github. com/hibernate/hibernate-orm/pull/6695|https://github.com/hibernate/hibern...] ). ( https://hibernate.atlassian.net/browse/HHH-16725#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16725#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:d82e018 )

2 years, 11 months

1
0
0 / 0

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

by Marko Bekhta (JIRA)

Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmE3NjE0ODMz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNmE3Nj... ) HHH-16725 ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNmE3Nj... ) Persisting multiple entities with one-many association and composite key with ordered updates enabled fails ( https://hibernate.atlassian.net/browse/HHH-16725?atlOrigin=eyJpIjoiNmE3Nj... ) Issue Type: Bug Affects Versions: 6.2.3 Assignee: Unassigned Created: 30/May/2023 10:39 AM Priority: Major Reporter: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Having a model: @Entity @IdClass(IdClass.class) class EntityClass { @Id private String string; @Id private int integer; @ManyToOne private EntityClass parent; @OneToMany(mappedBy = "parent" ) private List<EntityClass> children = new ArrayList<>(); } class IdClass { private String string; private int integer; } and setting hibernate.order_updates set to true leads to an exception when multiple entities of such type are persisted within the same transaction. The problem is caused by ExecutableList#add(). Since the setting requires sorting, adding a new action tries to call compare method to see if sorting is required. But since the entity is using a composite ID the VirtualIdEmbeddable#compare() is called with IdClass instances passed into it, while getAttributeMappings() returns the attributes of EntityClass as a result: PropertyAccessException: Error accessing field [EntityClass.integer] by reflection for persistent property [EntityClass#integer] : IdClass{..} is thrown. I will submit a PR with the test case for this. ( https://hibernate.atlassian.net/browse/HHH-16725#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16725#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16682) Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB

by Christian Thiel (JIRA)

Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16682 ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiMDU0Mj... ) Re: Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiMDU0Mj... ) Hello Cedomir, the assertion assertEquals(CHANGED, result.get(0).getInfo(), "plain property not changed"); was only part of the code by accident. I tried to ‘force’ the entity to be dirty by changing the info-value (see commented line) and that was the assertion for this. Ignore/remove this… What did you change exactly? As far as i can see just adding the name-property to the @Entity-annotation? But that can solve be the problem 🤔 I have the impression that the transaction-handling in your test-code is slightly different compared with my test. In my test adding @Transactional(Transactional.TxType.REQUIRES_NEW) means, every method of the test-class will have it’s own new transaction. So insert, update and select run in different transactions. If i change my test-case and let all methods use the same transaction (by using @Transactional without any value, what defaults to REQUIRED), the assertion is green. So within the transaction, the persistence-context holds&returns the correct value. ( https://hibernate.atlassian.net/browse/HHH-16682#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16682#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16724) Add new type for Oracle timestamp with local time zone

by Nemanja Jovanovic (JIRA)

Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGQ2M2NjODQx... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16724?atlOrigin=eyJpIjoiNGQ2M2... ) HHH-16724 ( https://hibernate.atlassian.net/browse/HHH-16724?atlOrigin=eyJpIjoiNGQ2M2... ) Add new type for Oracle timestamp with local time zone ( https://hibernate.atlassian.net/browse/HHH-16724?atlOrigin=eyJpIjoiNGQ2M2... ) Issue Type: Improvement Assignee: Unassigned Created: 30/May/2023 09:34 AM Environment: Hibernate 6.2.3.Final, Adoptium 17 JDK, Oracle 19.3 Priority: Minor Reporter: Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Oracle timestamp with local time zone is currently not supported, and since version 6 introduced many type changes it would be nice if hibernate would support timestamp with local time zone out of the box. And at the moment as mentioned in issue https://hibernate.atlassian.net/browse/HHH-16723 there is no easy way to create custom type that can be treated as temporal. ( https://hibernate.atlassian.net/browse/HHH-16724#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16724#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16723) Add a way to make custom type sql code to be treated as temporal

by Nemanja Jovanovic (JIRA)

Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2I4N2M1ODg3... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16723?atlOrigin=eyJpIjoiN2I4N2... ) HHH-16723 ( https://hibernate.atlassian.net/browse/HHH-16723?atlOrigin=eyJpIjoiN2I4N2... ) Add a way to make custom type sql code to be treated as temporal ( https://hibernate.atlassian.net/browse/HHH-16723?atlOrigin=eyJpIjoiN2I4N2... ) Issue Type: Improvement Assignee: Unassigned Created: 30/May/2023 09:23 AM Environment: Hibernate 6.2.3.Final, Adoptium 17 JDK, Oracle 19.3 Priority: Major Reporter: Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) It is not possible at the moment to create custom temporal type (see org.hibernate.type.SqlTypes.isTemporalType ) . Some hook should be added to allow custom type code to be treated as temporal. This is important as arguments in HQL functions are now validated and this prevents proper validation for custom types that should be temporal . Concretely oracle has timestamp with local time zone type that currently needs this. ( https://hibernate.atlassian.net/browse/HHH-16723#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16723#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16722) LocalDateTime values are wrong in START and END Daylight saving (non UTC timezone)

by humbertosales NA (JIRA)

humbertosales NA ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDk0OGY0MjUz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiZDk0OG... ) HHH-16722 ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiZDk0OG... ) LocalDateTime values are wrong in START and END Daylight saving (non UTC timezone) ( https://hibernate.atlassian.net/browse/HHH-16722?atlOrigin=eyJpIjoiZDk0OG... ) Issue Type: Bug Affects Versions: 5.6.15 Assignee: Unassigned Components: hibernate-core Created: 30/May/2023 09:08 AM Environment: hibernate-core 5.6.15.Final quarkus 2.16.6.FINAL openjdk 17.0.7 2023-04-18 Windows 10 64 bits SQL Server 2019 or H2 Memory DB (both) Local timezone is WET Priority: Major Reporter: humbertosales NA ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *********** The problem *********** The date 2023-03-26 is DAYLIGTH SAVING START in WET (Europe/Lisbon). The 01:00 at 2023-03-26 in timezone WET not exists. When persist this date in java.time.LocalDateTime (withou timezone) the hibernate convert it to java.sql.Timestamp (with timezone) before persist and lost the time because local timezone (JVM) is Europe/Lisbon. The JVM by convetion shift time to upper when it not exists in date time local (OS timezone). When get it data from DB, the Hibernate try re-converter timestamp to LocaDateTime, but the time is wrong and re-converter is impossible. *Atention* : the timezone JDBC properties not work here. It is used after the lost time describe. *UTC* *WET* *Description* 2023-03-26T00:00 2023-03-26T00:00 No problem 2023-03-26T01:00 2023-03-26T02:00 Problem! The time was converted to 02:00. *Not is possible determined* the original time is 01:00 or 02:00. 2023-03-26T02:00 2023-03-26T02:00 Problem. It was 01:00?! 2023-03-26T03:00 2023-03-26T03:00 No problem. ****************** The hibernate code ****************** //org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor public class LocalDateTimeJavaDescriptor extends AbstractTypeDescriptor<LocalDateTime> { //... public <X> X unwrap(LocalDateTime value, Class <X> type, WrapperOptions options) { if ( value == null ) { return null ; } if ( LocalDateTime. class. isAssignableFrom( type ) ) { return (X) value; } if ( java.sql.Timestamp. class. isAssignableFrom( type ) ) { /* * Workaround for HHH-13266 (JDK-8061577). * We used to do Timestamp.from( value.atZone( ZoneId.systemDefault() ).toInstant() ), * but on top of being more complex than the line below, it won't always work. * Timestamp.from() assumes the number of milliseconds since the epoch * means the same thing in Timestamp and Instant, but it doesn't, in particular before 1900. */ return (X) Timestamp.valueOf( value ); //THE BIG PROBLEM <<<<<<<<<< } //... } ************ The Evidence ************ ------ Entity ------ import java.time.LocalDate; import java.time.LocalDateTime; import java.util.UUID; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.Table; import org.hibernate.annotations.GenericGenerator; import lombok.Data; @Entity @Table(name = "DT_ENTITY_WITH_DATETIME" ) @Data public class EntityWithDatetime { private static final long serialVersionUID = 1L; @Id @GeneratedValue(generator = "UUID" ) @GenericGenerator(name = "UUID" , strategy= "org.hibernate.id.UUIDGenerator" ) @Column(name= "ID" ) private UUID id; @Column(name = "CREATED_DATE" ) // @Column(name = "CREATED_DATE" , columnDefinition = "DATETIME2" ) same error // @Column(name = "CREATED_DATE" , columnDefinition = "DATETIME" ) same error private LocalDateTime createdDate; @Column(name = "DATETIME_KEY_UTC" ) private Long datetimeKeyUTC; @Column(name = "MARKET_DATE" ) private LocalDate marketDate; @Column(name = "MARKET_HOUR" ) private Integer marketHour; } ---------- Repository ---------- import javax.enterprise.context.ApplicationScoped; @ApplicationScoped public class EntityWithDatetimeRepository implements PanacheRepository<EntityWithDatetime> { } Unit tests import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertNotEquals; import java.sql.Timestamp; import java.time.LocalDateTime; import java.time.ZoneId; import java.time.ZonedDateTime; import org.junit.jupiter.api.Test; import org.junit.jupiter.api.extension.ExtendWith; import org.mockito.junit.jupiter.MockitoExtension; @ExtendWith(MockitoExtension.class) public class LocaldatetimeTimestampTest { //Test issue in org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor @Test public void testLocalDateTimeTOTimeStamp() { LocalDateTime localdatetime = LocalDateTime.parse( "2023-03-26T01:00" ); Timestamp timestamp = Timestamp.valueOf(localdatetime); assertNotEquals( "2023-03-26 01:00:00.0" , timestamp.toString()); } //Test issue in org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor //work? https://stackoverflow.com/questions/72909759/adding-minutes-to-localdatet... @Test public void testLocalDateTimeTOTimeStampTry1() { LocalDateTime localdatetime = LocalDateTime.parse( "2023-03-26T01:00" ); ZonedDateTime zonedDateTime = localdatetime.atZone(ZoneId.of( "UTC" )); Timestamp timestamp = Timestamp.from(zonedDateTime.toInstant()); LocalDateTime localDateTimeReturned = timestamp.toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime(); assertEquals( "2023-03-26T01:00" , localDateTimeReturned.toString()); } } ---------------- Integration Test ---------------- import static org.junit.jupiter.api.Assertions.assertEquals; import java.io.IOException; import java.sql.Timestamp; import java.time.LocalDateTime; import java.time.ZoneId; import java.util.Arrays; import java.util.List; import java.util.TimeZone; import javax.inject.Inject; import javax.persistence.EntityManager; import javax.persistence.Tuple; import javax.transaction.Transactional; import org.junit.jupiter.api.Test; import io.quarkus.panache.common.Sort; import io.quarkus.test.common.QuarkusTestResource; import io.quarkus.test.junit.QuarkusTest; @QuarkusTest public class DateTimeIntegrationTest { private static final String QuerySelectMarketDateAndHour = "Select CREATED_DATE, MARKET_HOUR, DATETIME_KEY_UTC from DT_ENTITY_WITH_DATETIME A " + "where MARKET_HOUR in (0, 1, 2, 3, 22, 23, 24) order by market_hour" ; @Inject EntityWithDatetimeRepository repository; @Inject EntityManager em; @Test //@DataSet(value = "datasets/FunctionalTest.yaml" , strategy = SeedStrategy.IDENTITY_INSERT, cleanBefore = true , fillIdentityColumns = true ) @Transactional public void test() throws IOException { EntityWithDatetime entity00 = createEntityWithDateTime( "2023-03-26T00:00" ); EntityWithDatetime entity01 = createEntityWithDateTime( "2023-03-26T01:00" ); EntityWithDatetime entity02 = createEntityWithDateTime( "2023-03-26T02:00" ); EntityWithDatetime entity03 = createEntityWithDateTime( "2023-03-26T03:00" ); repository.persist(Arrays.asList(entity00, entity01, entity02, entity03)); assertEquals(4, repository.findAll().count()); //lastversion List<Tuple> resultList = em.createNativeQuery(QuerySelectMarketDateAndHour, Tuple.class).getResultList(); System.out.println(QuerySelectMarketDateAndHour); for (Tuple tuple : resultList) { Object [] cols = tuple.toArray(); for ( Object col : cols) { if (col instanceof Timestamp) { System.out.print( String.format( "%s (%s) (%s %s) \t" , col, ((Timestamp) col).toGMTString(), ((Timestamp) col).toLocaleString(), TimeZone.getDefault().toZoneId().toString())); } else { System.out.print( String.format( "%s \t" , col)); } } System.out.println(""); } assertEquals( "2023-03-26T00:00" , ((Timestamp)resultList.get(0).get( "CREATED_DATE" )).toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime().toString()); assertEquals( "2023-03-26T01:00" , ((Timestamp)resultList.get(1).get( "CREATED_DATE" )).toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime().toString()); assertEquals( "2023-03-26T02:00" , ((Timestamp)resultList.get(2).get( "CREATED_DATE" )).toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime().toString()); assertEquals( "2023-03-26T03:00" , ((Timestamp)resultList.get(3).get( "CREATED_DATE" )).toInstant().atZone(ZoneId.of( "UTC" )).toLocalDateTime().toString()); System.out.println( "ENTITIES PRINTS" ); List<EntityWithDatetime> listAll = repository.findAll(Sort.by( "marketHour" )).list(); for (EntityWithDatetime entity : listAll) { System.out.println(entity); } assertEquals( "2023-03-26T00:00" , listAll.get(0).getCreatedDate().toString()); assertEquals( "2023-03-26T01:00" , listAll.get(1).getCreatedDate().toString()); assertEquals( "2023-03-26T02:00" , listAll.get(2).getCreatedDate().toString()); assertEquals( "2023-03-26T03:00" , listAll.get(3).getCreatedDate().toString()); } private EntityWithDatetime createEntityWithDateTime( String datetimeCET) { EntityWithDatetime entity = new EntityWithDatetime(); entity.setCreatedDate(LocalDateTime.parse(datetimeCET)); entity.setMarketHour(entity.getCreatedDate().getHour()); //MyDateBusinessToUTC calculate it in UTC.... irrelevant business code!! MyDateBusinessToUTC dateBUTC = new MyDateBusinessToUTC(entity.getCreatedDate(), ZoneId.of( "Europe/Lisbon" )); entity.setMarketDate(dateBUTC.getMarketDate()); entity.setDatetimeKeyUTC(dateBUTC.getDatetimeKeyUtcHour()); return entity; } } ---------- The return ---------- Hibernate: insert into ODS.DT_ENTITY_WITH_DATETIME (CREATED_DATE, DATETIME_KEY_UTC, MARKET_DATE, MARKET_HOUR, ID) values (?, ?, ?, ?, ?) 2023-05-30 17:00:55,839 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [1] as [TIMESTAMP] - [2023-03-26T00:00] 2023-05-30 17:00:55,845 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [2] as [BIGINT] - [2023032600] 2023-05-30 17:00:55,846 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [3] as [DATE] - [2023-03-26] 2023-05-30 17:00:55,846 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [4] as [INTEGER] - [0] 2023-05-30 17:00:55,847 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [5] as [BINARY] - [1d29f0d8-7f5a-4b58-b6c9-c22d0b4a1d61] Hibernate: insert into ODS.DT_ENTITY_WITH_DATETIME (CREATED_DATE, DATETIME_KEY_UTC, MARKET_DATE, MARKET_HOUR, ID) values (?, ?, ?, ?, ?) 2023-05-30 17:00:55,849 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [1] as [TIMESTAMP] - [2023-03-26T01:00] 2023-05-30 17:00:55,850 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [2] as [BIGINT] - [2023032601] 2023-05-30 17:00:55,850 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [3] as [DATE] - [2023-03-26] 2023-05-30 17:00:55,850 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [4] as [INTEGER] - [1] 2023-05-30 17:00:55,850 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [5] as [BINARY] - [e6084c0c-efbe-4ffa-a5f7-76e9ddfd1d48] Hibernate: insert into ODS.DT_ENTITY_WITH_DATETIME (CREATED_DATE, DATETIME_KEY_UTC, MARKET_DATE, MARKET_HOUR, ID) values (?, ?, ?, ?, ?) 2023-05-30 17:00:55,851 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [1] as [TIMESTAMP] - [2023-03-26T02:00] 2023-05-30 17:00:55,851 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [2] as [BIGINT] - [2023032601] 2023-05-30 17:00:55,852 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [3] as [DATE] - [2023-03-26] 2023-05-30 17:00:55,852 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [4] as [INTEGER] - [2] 2023-05-30 17:00:55,852 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [5] as [BINARY] - [b3318092-94e4-4d83-bc16-c0ec65c95e14] Hibernate: insert into ODS.DT_ENTITY_WITH_DATETIME (CREATED_DATE, DATETIME_KEY_UTC, MARKET_DATE, MARKET_HOUR, ID) values (?, ?, ?, ?, ?) 2023-05-30 17:00:55,853 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [1] as [TIMESTAMP] - [2023-03-26T03:00] 2023-05-30 17:00:55,853 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [2] as [BIGINT] - [2023032602] 2023-05-30 17:00:55,853 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [3] as [DATE] - [2023-03-26] 2023-05-30 17:00:55,854 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [4] as [INTEGER] - [3] 2023-05-30 17:00:55,854 TRACE [org.hib.typ.des.sql.BasicBinder] (main) binding parameter [5] as [BINARY] - [b2b0dc24-0f5e-403d-8d45-a806f4e33b7f] Hibernate: select count(*) as col_0_0_ from DT_ENTITY_WITH_DATETIME entitywith0_ Hibernate: Select CREATED_DATE, MARKET_HOUR, DATETIME_KEY_UTC from ODS.DT_ENTITY_WITH_DATETIME A where MARKET_HOUR in ( 0, 1, 2, 3, 22, 23, 24 ) order by market_hour Select CREATED_DATE, MARKET_HOUR, DATETIME_KEY_UTC from ODS.DT_ENTITY_WITH_DATETIME A where MARKET_HOUR in (0, 1, 2, 3, 22, 23, 24) order by market_hour 2023-03-26 00:00:00.0 (26 Mar 2023 00:00:00 GMT) (26 de mar de 2023 00:00:00 Europe/London) 0 2023032600 2023-03-26 02:00:00.0 (26 Mar 2023 01:00:00 GMT) (26 de mar de 2023 02:00:00 Europe/London) 1 2023032601 2023-03-26 02:00:00.0 (26 Mar 2023 01:00:00 GMT) (26 de mar de 2023 02:00:00 Europe/London) 2 2023032601 2023-03-26 03:00:00.0 (26 Mar 2023 02:00:00 GMT) (26 de mar de 2023 03:00:00 Europe/London) 3 2023032602 ************** The Reference: ************** See org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor. See https://savvytime.com/converter/utc-to-wet/mar-26-2023/1-15am *********** Workaround: *********** Create Types overwrites, forcing ALWAYS timezone UTC. //org.hibernate.type.descriptor.java.LocalDateTimeJavaDescriptor if ( java.sql.Timestamp. class. isAssignableFrom( type ) ) { ZonedDateTime zonedDateTime = value.atZone(zoneUTC); return (X) Timestamp.from(zonedDateTime.toInstant()); } ( https://hibernate.atlassian.net/browse/HHH-16722#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16722#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:d82e018 )

2 years, 11 months

1
0
0 / 0

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

by Nemanja Jovanovic (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16540) UnknownTableReferenceException for entity with Embeddable key-value in map

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

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

by Nemanja Jovanovic (JIRA)

2 years, 11 months

1
0
0 / 0

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

by Nemanja Jovanovic (JIRA)

Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmM3YjhlY2Y3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16721?atlOrigin=eyJpIjoiNmM3Yj... ) HHH-16721 ( https://hibernate.atlassian.net/browse/HHH-16721?atlOrigin=eyJpIjoiNmM3Yj... ) HQL with subquery with entity path at least two deep produces wrong SQL ( https://hibernate.atlassian.net/browse/HHH-16721?atlOrigin=eyJpIjoiNmM3Yj... ) Issue Type: Bug Affects Versions: 6.2.2, 6.2.3 Assignee: Unassigned Created: 30/May/2023 08:46 AM Environment: If we have for example these entities: Priority: Major Reporter: Nemanja Jovanovic ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) If we have for example these entities: @Entity class A implements Serializable { private static final long serialVersionUID = -5412503864464287451L; @Id @GeneratedValue long id; @ManyToOne B b; } @Entity class B implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue long id; @ManyToOne C c; } @Entity class C implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue long id; } HQL like this: select a.id from A a where exists (select b.id from B b where a.b.c.id = 5) will produce SQL: select a1_0.id from A a1_0 where exists(select b1_0.id from B b1_0,B b2_0 where b2_0.c_id=5) This is obviously wrong as b2_0 should be in correlation with a1_0 . Exists is not a factor here as this does not work with in either. Attached test contains more examples, see console output. ( https://hibernate.atlassian.net/browse/HHH-16721#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16721#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16720) Fix for HHH-15759 broke our code

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16720) Fix for HHH-15759 broke our code

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16720 ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiNmE3NG... ) Re: Fix for HHH-15759 broke our code ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiNmE3NG... ) Hi Armen Chouldjian ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) , please provide a test case so I can investigate the issue and work an a solution. Thanks ( https://hibernate.atlassian.net/browse/HHH-16720#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16720#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16701) "persister" is null during validation with lazy collections

by Jan Schatteman (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16720) Fix for HHH-15759 broke our code

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

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

by Jan Schatteman (JIRA)

Jan Schatteman ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16696 ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiZDAwZG... ) Re: hibernate-core >= 6.2.0 stopped invoking PostgreSQLDialect.initializeFunctionRegistry(QueryEngine) ( https://hibernate.atlassian.net/browse/HHH-16696?atlOrigin=eyJpIjoiZDAwZG... ) I’m not sure I understand your difficulty; you shouldn’t have to do anything other than change the implementation you already have, that is, change @Override public void initializeFunctionRegistry(QueryEngine queryEngine) { super.initializeFunctionRegistry(queryEngine); queryEngine.getSqmFunctionRegistry().register(PostgresqlJsonArrayFunction.NAME, new PostgresqlJsonArrayFunction()); } to @Override public void initializeFunctionRegistry(FunctionContributions functionContributions) { super.initializeFunctionRegistry(functionContributions); functionContributions.getFunctionRegistry().register(PostgresqlJsonArrayFunction.NAME, new PostgresqlJsonArrayFunction()); } Let me know if this helps. ( 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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16720) Fix for HHH-15759 broke our code

by Armen Chouldjian (JIRA)

Armen Chouldjian ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMGUzMGMwNWUz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiMGUzMG... ) HHH-16720 ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiMGUzMG... ) Fix for HHH-15759 broke our code ( https://hibernate.atlassian.net/browse/HHH-16720?atlOrigin=eyJpIjoiMGUzMG... ) Issue Type: Bug Affects Versions: 6.1.7, 6.2.3 Assignee: Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Created: 30/May/2023 08:37 AM Priority: Major Reporter: Armen Chouldjian ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Hello Hibernate Team, My team and I have tried updating one of our main software projects from Hibernate 6.1.6 to 6.2.3 and we are unable to perform this upgrade due to an issue. I have dug around enough, and have figured out the particular commit which is causing the issue. The following code (hibernate-core/src/main/java/org/hibernate/mapping/Set.java:createPrimaryKey) needs to be looked at again and re-evaluated. I can provide a test-case in time, but as of right now, I do not have the test-case for you. Here is a link to the particular commit which prevents us from upgrading to 6.2.3: https://github.com/hibernate/hibernate-orm/commit/9341df0b8b5c1eee2a54efd... Old (working) code from 6.1.6 tag: void createPrimaryKey() { if ( !isOneToMany() ) { PrimaryKey pk = new PrimaryKey( getCollectionTable() ); pk.addColumns( getKey() ); New (broken) code from 6.2.3 tag: void createPrimaryKey() { if ( !isOneToMany() ) { final Table collectionTable = getCollectionTable(); PrimaryKey pk = collectionTable.getPrimaryKey(); if ( pk == null ) { pk = new PrimaryKey( getCollectionTable() ); } pk.addColumns( getKey() ); It looks like dreab8 ( *Andrea Boriero* ) was trying to solve this particular Jira ID: https://hibernate.atlassian.net/browse/HHH-15759 Now I am not sure what the final fix should be, as reverting this commit may cause the original issue to break as well, however I am certain that current state the code is in is not the correct solution, as it causes major breakage in our (very) large project. I would suggest playing around with a debugger to understand what is going on here. Here’s my annotation: @ElementCollection(fetch=FetchType.EAGER) @CollectionTable(name="interlocking",joinColumns=@JoinColumn(name="ctl_interlocking")) @Column(name="idn") private Set<Integer> ctlInterlockingInterlockingIdns = new HashSet<Integer>(); Here is the original exception I got: Exception in thread "main" org.hibernate.MappingException: Foreign key (FKntc3fe3p6srhxyr5cbmvtcq40:contact_rail_at_location [interlocking])) must have same number of columns as the referenced primary key (interlocking [idn,ctl_interlocking]) at org.hibernate.mapping.ForeignKey.alignColumns(ForeignKey.java:138) at org.hibernate.mapping.ForeignKey.alignColumns(ForeignKey.java:119) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.secondPassCompileForeignKeys(InFlightMetadataCollectorImpl.java:2010) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.secondPassCompileForeignKeys(InFlightMetadataCollectorImpl.java:1974) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.processSecondPasses(InFlightMetadataCollectorImpl.java:1818) at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:328) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1380) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1451) at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:55) at jakarta.persistence.Persistence.createEntityManagerFactory(Persistence.java:80) at g.b.c.p.JpaManager.<init>(JpaManager.java:122) at g.b.i.r.c.SvgLoad.<init>(SvgLoad.java:47) at g.b.i.r.c.SvgLoad.main(SvgLoad.java:65) In our particular situation, we believe “idn” in this case should not be part of the referenced primary key (interlocking [idn,ctl_interlocking] ). That is the mistake that is breaking the code. ( https://hibernate.atlassian.net/browse/HHH-16720#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16720#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16693) MappedSuperClass with generic collections not mapped correctly

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16693) MappedSuperClass with generic collections not mapped correctly

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16574) Treat Querys throws SemanticException if InheritanceType=Joined

by Marco Belladelli (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16665) False positive HibernateException: Found shared references to a collection with 6.2.2

by Andrea Boriero (JIRA)

Andrea Boriero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16665 ( https://hibernate.atlassian.net/browse/HHH-16665?atlOrigin=eyJpIjoiYzBiOD... ) Re: False positive HibernateException: Found shared references to a collection with 6.2.2 ( https://hibernate.atlassian.net/browse/HHH-16665?atlOrigin=eyJpIjoiYzBiOD... ) Hi Oleksii Miroshnyk ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a157d9... ) , can you please check if the issue persists with Hibernate 6.2.3.Final? I tried and it seems fixed! Thanks! ( https://hibernate.atlassian.net/browse/HHH-16665#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16665#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16678) AssertionError in QueryLiteral.<init> when using "update versioned Entity ..." if @Version is a long

by Damien GIBOU (JIRA)

Damien GIBOU ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *commented* on HHH-16678 ( https://hibernate.atlassian.net/browse/HHH-16678?atlOrigin=eyJpIjoiZDMzOD... ) Re: AssertionError in QueryLiteral.<init> when using "update versioned Entity ..." if @Version is a long ( https://hibernate.atlassian.net/browse/HHH-16678?atlOrigin=eyJpIjoiZDMzOD... ) I checked with 6.2.3.Final and the problem persists. Have you enabled assertions (-ea) ? ( https://hibernate.atlassian.net/browse/HHH-16678#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16678#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16673) Fail to get access lazy fetched field ( @ManyToOne ) which is part of a composite Id (using an @IdClass) when stored in L2 cache

by Erwan Moutymbo (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16682) Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB

by Čedomir Igaly (JIRA)

Čedomir Igaly ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16682 ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiZjA3Yj... ) Re: Changes in @JdbcTypeCode(SqlTypes.JSON) are not written to DB ( https://hibernate.atlassian.net/browse/HHH-16682?atlOrigin=eyJpIjoiZjA3Yj... ) MyEntityTest.java ( https://hibernate.atlassian.net/rest/api/3/attachment/content/50425 ) I’ve slightly changed your test case and it is working without problems. Why you still have this last assertion: > > > > assertEquals(CHANGED, result.get(0).getInfo(), "plain property not > changed"); > > when infor property has not been changed? ( https://hibernate.atlassian.net/browse/HHH-16682#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16682#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16719) Upgrading from 6.1.7.Final to 6.2.2.Final breaks Criteria queries for model with inheritance

by Bjørn Hilstad (JIRA)

Bjørn Hilstad ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiN2JiMWQ2ZTU0... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16719?atlOrigin=eyJpIjoiN2JiMW... ) HHH-16719 ( https://hibernate.atlassian.net/browse/HHH-16719?atlOrigin=eyJpIjoiN2JiMW... ) Upgrading from 6.1.7.Final to 6.2.2.Final breaks Criteria queries for model with inheritance ( https://hibernate.atlassian.net/browse/HHH-16719?atlOrigin=eyJpIjoiN2JiMW... ) Issue Type: Bug Affects Versions: 6.2.2, 6.2.3 Assignee: Unassigned Attachments: hibernate-bug2.zip Components: hibernate-core Created: 30/May/2023 07:37 AM Priority: Major Reporter: Bjørn Hilstad ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) Error message: Cannot invoke "org.hibernate.sql.ast.tree.from.TableGroup.findTableGroupJoin(org.hibernate.sql.ast.tree.from.TableGroup)" because "parentParentTableGroup" is null java.lang.NullPointerException: Cannot invoke "org.hibernate.sql.ast.tree.from.TableGroup.findTableGroupJoin(org.hibernate.sql.ast.tree.from.TableGroup)" because "parentParentTableGroup" is null Discovered while upgrading a spring-boot+jpa app from 3.0.7 to 3.1.0, which upgrades Hibernate from 6.1.7 to 6.2.2. See testcase H8BugTest for a reproducer (the project also contains ways to trigger this from a spring-boot app, but the mentioned one should be good enough). The testcase findStreet which uses a CriteriaQuery to fetch a Street works on all versions. The testcase findAddress which uses a CriteriaQuery to fetch an Address breaks on 6.2.2+, but works on 6.1.7. Address has a simple use of inheritance, which seems to be the trigger of the problem. Versions of Hibernate to use can be controlled from gradle.properties. hibernate-bug2.zip ( https://hibernate.atlassian.net/rest/api/3/attachment/content/50424 ) ( https://hibernate.atlassian.net/browse/HHH-16719#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16719#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16713) Bogus warning : "HHH100001: JDBC driver did not return the expected number of row counts...."

by Marcel Wollschläger (JIRA)

Marcel Wollschläger ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=63bfde4... ) *commented* on HHH-16713 ( https://hibernate.atlassian.net/browse/HHH-16713?atlOrigin=eyJpIjoiZmQ3Zj... ) Re: Bogus warning : "HHH100001: JDBC driver did not return the expected number of row counts...." ( https://hibernate.atlassian.net/browse/HHH-16713?atlOrigin=eyJpIjoiZmQ3Zj... ) Building on top of the mentioned issue, here is a working example with a @ManyToOne relationship and Hibernate 6.1.7.Final : HibernateManyToOneIssue.zip ( https://hibernate.atlassian.net/rest/api/3/attachment/content/50423 ) Changing the version to any 6.2.x.Final version will trigger the warning ( https://hibernate.atlassian.net/browse/HHH-16713#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16713#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16591) @org.hibernate.annotations.JdbcTypeCode does not override the `hibernate.type.preferred_duration_jdbc_type` type

by Yoann Rodière (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16700) mappedBy to id, not to Entity

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16664) NPE in MappingMetamodelImpl if inheritance is used in IdClass

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16718) use table inheritance in DDL generation for TABLE_PER_CLASS mappings on PostgreSQL

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMzdmOTRkY2Jm... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-16718?atlOrigin=eyJpIjoiMzdmOT... ) HHH-16718 ( https://hibernate.atlassian.net/browse/HHH-16718?atlOrigin=eyJpIjoiMzdmOT... ) use table inheritance in DDL generation for TABLE_PER_CLASS mappings on PostgreSQL ( https://hibernate.atlassian.net/browse/HHH-16718?atlOrigin=eyJpIjoiMzdmOT... ) Issue Type: New Feature Assignee: Unassigned Components: hibernate-core Created: 30/May/2023 06:55 AM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) I think it would be very slick to use inheritance in the DDL generated for TABLE_PER_CLASS mappings on PostgreSQL. In queries we would still need to use a UNION over SELECT ... FROM ONLY queries, if I understand this feature correctly, but we would at least get streamlined DDL. Eventually we could also use it to simplify the DML for projection queries, where the UNION would not be required. But we would not need that in the very first cut of this. ( https://hibernate.atlassian.net/browse/HHH-16718#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16718#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16671) Unable to query key attribute that uses AttributeConverter

by Julien Ravet (JIRA)

Julien Ravet ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16671 ( https://hibernate.atlassian.net/browse/HHH-16671?atlOrigin=eyJpIjoiY2YzND... ) Re: Unable to query key attribute that uses AttributeConverter ( https://hibernate.atlassian.net/browse/HHH-16671?atlOrigin=eyJpIjoiY2YzND... ) Here is an example using @JavaType annotation Encountering the same issue on both id and non id fields org.hibernate.QueryException: Parameter 1 of function max() has type COMPARABLE, but argument is of type java.time.YearMonth @MarcoBelladelli I understand that this is not exactly the same (same error, but using type insteand of converter) Do you want me to open a distinct issue ? HHH-16671.zip ( https://hibernate.atlassian.net/rest/api/3/attachment/content/50422 ) ( https://hibernate.atlassian.net/browse/HHH-16671#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16671#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16715) accept value() or element() in place of elements() and key() or index() in place of indices()

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16715 ( https://hibernate.atlassian.net/browse/HHH-16715?atlOrigin=eyJpIjoiNWQyN2... ) Re: accept value() or element() in place of elements() and key() or index() in place of indices() ( https://hibernate.atlassian.net/browse/HHH-16715?atlOrigin=eyJpIjoiNWQyN2... ) Conclusion: I did not make the suggested change discussed above, but I did a lot of work to explain this stuff in the documentation, and I hope it’s now clear. I also, for consistency, let you write keys() and values() which it’s a Map. This issue can be closed. ( https://hibernate.atlassian.net/browse/HHH-16715#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16715#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16664) NPE in MappingMetamodelImpl if inheritance is used in IdClass

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16664) NPE in MappingMetamodelImpl if inheritence is used in IdClass

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16664) NPE in MappingMetamodelImpl if inheritence is used in IdClass

by Andrea Boriero (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4858) Upgrade to Hibernate ORM 6.2.3.Final

by Automation for Jira (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HHH-16615) SQL query accesses non-existing alias in update/delete

by Marco Belladelli (JIRA)

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *commented* on HHH-16615 ( https://hibernate.atlassian.net/browse/HHH-16615?atlOrigin=eyJpIjoiYTQ2Mm... ) Re: SQL query accesses non-existing alias in update/delete ( https://hibernate.atlassian.net/browse/HHH-16615?atlOrigin=eyJpIjoiYTQ2Mm... ) Hello Steffen Schäfer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f1ef7e... ) , the unexpected alias is used because your query would need an implicit join ( PrivateSubData with PrivateData ) to use the person_id column. Joins are currently not supported for mutation queries in Hibernate 6. I also tested your example with Hibernate 5.6 since you reported it was working but it did not work for me. One way to work around this would be using a subquery, something like: update PrivateSubData psd set psd.dataName = '...' where psd. data.id in ( select data.id from PrivateData data where data.person.id = ?1) ( https://hibernate.atlassian.net/browse/HHH-16615#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16615#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:d82e018 )

2 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4858) Upgrade to Hibernate ORM 6.2.3.Final

by Yoann Rodière (JIRA)

2 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-4858) Upgrade to Hibernate ORM 6.2.3.Final

by Yoann Rodière (JIRA)

2 years, 11 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 May 2023