October 2022 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-15553) Not possible to fetch content from mapping tables, that only have <composite-id> attributes.

by Patrick Lübbecke (JIRA)

Patrick Lübbecke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61a7428... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNWVmZWY4YzE3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15553?atlOrigin=eyJpIjoiNWVmZW... ) HHH-15553 ( https://hibernate.atlassian.net/browse/HHH-15553?atlOrigin=eyJpIjoiNWVmZW... ) Not possible to fetch content from mapping tables, that only have <composite-id> attributes. ( https://hibernate.atlassian.net/browse/HHH-15553?atlOrigin=eyJpIjoiNWVmZW... ) Change By: Patrick Lübbecke ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=61a7428... ) +*Short summary:*+ it is not possible to fetch content from mapping tables, that only have {{<composite-id>}} attributes. I have 3 tables: * User * Role * User_Role We configure our entities using .hbm.xml files. The mapping file for User_Role has just a composite keys based on the IDs of User and Role. When fetching a tuple of the mapping table, I get this error in Hibernate 5.6.11: {{java.lang.IllegalArgumentException: Unable to locate Attribute with the the given name [userName] on this ManagedType [com.myapp.ums.business.impl.UmsUserRoleVOImpl]}} The reason for this is that the attributes that are set as key-properties could not be found in {{AbstractManagedType#getAttribute(String name)}}: !image-20220926-131848.png|width=1310,height=241! Here is the code I use to prepare the DB queries: {code:java}CriteriaBuilder cb = this.getSession().getCriteriaBuilder(); CriteriaQuery cq = cb.createQuery(aliasToBeanClass); Root root = cq.from(aliasToBeanClass); // aliasToBeanClass is set to UmsUserRoleVOImpl List<Predicate> predicates = new ArrayList<>(); predicates.add(cb.equal(root.get(key), value)); // key is set to "userName" - this line is causing the exception {code} *My mapping file* {{<?xml version="1.0"?>}} {{<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"}} {{ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">}} {{<hibernate-mapping>}} {{ <class name="com.myapp.ums.business.impl.UmsUserRoleVOImpl" table="ums_t_user_role"}} {{ proxy="com.myapp.ums.common.business.UmsUserRoleVO">}} {{ <composite-id>}} {{ <key-property name="userName" type="java.lang.String" column="fk_user_id"/>}} {{ <key-property name="roleName" type="java.lang.String" column="fk_role_id"/>}} {{ </composite-id>}} {{ </class>}} {{</hibernate-mapping>}} *The interface:* {code:java}public interface UmsUserRoleVO extends AbstractBaseProperties { String ROLE_NAME = "roleName"; String USER_NAME = "userName"; String PROPERTIES = "properties"; String getUserName(); void setUserName(final String userName); String getRoleName(); void setRoleName(final String roleName); List<PmPropertyVO> getProperties(); void setProperties(List<PmPropertyVO> properties); }{code} *The entity:* {code:java}package com.myapp.ums.business.impl; public class UmsUserRoleVOImpl extends AbstractBasePropertiesImpl implements UmsUserRoleVO { private static final long serialVersionUID = 6390635151578885216L; private String roleName; private String userName; private List<PmPropertyVO> properties; public UmsUserRoleVOImpl() { } @Override public Long getRowguid() { return super.getRowguid(); } @Override public void setRowguid(final Long rowguid) { super.setRowguid(rowguid); } public String getRoleName() { return roleName; } public void setRoleName(String roleName) { this.roleName = roleName; } public List<PmPropertyVO> getProperties() { return properties; } public void setProperties(List<PmPropertyVO> properties) { this.properties = properties; } public boolean equals(Object o) { ... } public int hashCode() { ... } public String toString() { return roleName + " " + userName; } @Get(UmsUserRoleVO.USER_NAME) public String getUserName() { return this.userName; } @Set(UmsUserRoleVO.USER_NAME) public void setUserName(String userName) { this.userName = userName; } }{code} I think it has something to do with the mapping file not correctly processed. *Here is a test case for the problem:* [^CompositeId.zip] ( https://hibernate.atlassian.net/browse/HHH-15553#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15553#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#100209- sha1:392b984 )

2 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4107) Session cast fails when creating a FullTextSession with Spring 2.4.0

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiOGI0Yjky... ) / Bug ( https://hibernate.atlassian.net/browse/HSEARCH-4107?atlOrigin=eyJpIjoiOGI... ) HSEARCH-4107 ( https://hibernate.atlassian.net/browse/HSEARCH-4107?atlOrigin=eyJpIjoiOGI... ) Session cast fails when creating a FullTextSession with Spring 2.4.0 ( https://hibernate.atlassian.net/browse/HSEARCH-4107?atlOrigin=eyJpIjoiOGI... ) Change By: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Fix versions: 5.10.13.Final ( https://hibernate.atlassian.net/browse/HSEARCH-4107#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4107#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#100209- sha1:392b984 )

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15615) Add EDB PostgreSQL Advanced to test matrix and fix issues

by Christian Beikov (JIRA)

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15615) Add EDB PostgreSQL Advanced to test matrix and fix issues

by Christian Beikov (JIRA)

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15528) Add Cockroach to Jenkins nightly test matrix and fix issues

by Christian Beikov (JIRA)

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15620) HBM transformed model is wrongly marked metadata-complete

by Christian Beikov (JIRA)

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15619) Named query from HBM doesn't apply cacheable configuration

by Christian Beikov (JIRA)

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15612) Bad SQL generation when using entity graph with ON clause on query

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15612 ( https://hibernate.atlassian.net/browse/HHH-15612?atlOrigin=eyJpIjoiMTQ1Mj... ) Re: Bad SQL generation when using entity graph with ON clause on query ( https://hibernate.atlassian.net/browse/HHH-15612?atlOrigin=eyJpIjoiMTQ1Mj... ) Also, please clarify what the “bug” is, because as far as I understand, the additional join doesn’t change the semantics, or does it? If this is about duplicate elements in the collection, this will be fixed as part of https://hibernate.atlassian.net/browse/HHH-15547 ( https://hibernate.atlassian.net/browse/HHH-15547 ) and https://github.com/hibernate/hibernate-orm/pull/5396 ( https://github.com/hibernate/hibernate-orm/pull/5396 ) ( https://hibernate.atlassian.net/browse/HHH-15612#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15612#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#100209- sha1:392b984 )

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15612) Bad SQL generation when using entity graph with ON clause on query

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15612 ( https://hibernate.atlassian.net/browse/HHH-15612?atlOrigin=eyJpIjoiODBjMm... ) Re: Bad SQL generation when using entity graph with ON clause on query ( https://hibernate.atlassian.net/browse/HHH-15612?atlOrigin=eyJpIjoiODBjMm... ) I just closed this issue that you were referring to, as that was fixed in Hibernate 6. I don’t know what to tell you. Filtering a collection that you fetch is not safe, that’s why JPA doesn’t allow assigning an alias to a join fetch. In Hibernate 6, we fixed this unsafety. If you want to fetch a subset of data, what you need is a projection/DTO for which there are tools like e.g. Blaze-Persistence Entity-Views ( https://github.com/Blazebit/blaze-persistence#entity-view-usage ) with which you can select exactly the data that you want. Your use case could be modeled with entity views like this: @EntityView(CustomerOrder.class) public interface CustomerOrderDto { @IdMapping Long getId(); @Mapping( "orderPositionCollection[deleted = false ]" ) List<OrderPositionDto> getOrderPositionCollection(); } @EntityView(OrderPosition.class) public interface OrderPositionDto { @IdMapping Long getId(); Integer getAmount(); ProductDto getProduct(); } @EntityView(Product.class) public interface ProductDto { @IdMapping Long getId(); String getProductName(); } ( https://hibernate.atlassian.net/browse/HHH-15612#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15612#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#100209- sha1:392b984 )

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-13278) Hibernate EAGER loading triggers multiple queries instead of just one

by Christian Beikov (JIRA)

2 years, 3 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues October 2022