Query by @MapsId property fails with missing parameter exception

Description

See also: http://stackoverflow.com/questions/11698488/unable-to-query-with-mapsid-and-id-but-works-just-with-id

I have two entities, one of which uses the other's PK as its own:

@Entity
public class Firm {
...
@Id
@Column(...)
public Long getId() {...}
...
}

@Entity
public class FirmContactInfo {
...
@Id
public Long getId() {...}

@OneToOne
@MapsId
@JoinColumn(...)
public Firm getFirm() {...}
}

Attempting a query such as the following results in "Missing IN or OUT parameter at index:: 1"

Firm f = em.find(Firm.class, 1461L);
assertNotNull(f);
TypedQuery<FirmContactInfo> q = em.createQuery(
"SELECT fci "
+ "FROM FirmContactInfo fci "
+ "WHERE fci.firm IN (:firms)", FirmContactInfo.class);
q.setParameter("firms", f);
FirmContactInfo fci = q.getSingleResult();
assertNotNull(fci);

Pulling out Firm ids and searching based on FirmContactInfo.id does work, but that's not always convenient.

Environment

Hibernate 4.3.5 in WildFly 8.1.0

Activity

Show:
Steve Ebersole
October 27, 2015, 7:16 PM

This bug report does not indicate that the reported issue affects version 5.x. Versions prior to 5.x are no longer maintained. It would be a great help to the Hibernate team and community for someone to verify that the reported issue still affects version 5.x. If so, please add the 5.x version that you verified with to the list of affected-versions and attach the (preferably SSCCE) test case you used to do the verification to the report; from there the issues will be looked at during our triage meetings.

For details, see http://in.relation.to/2015/10/27/great-jira-cleanup-2015/

Steve Ebersole
October 28, 2015, 3:25 AM

As part of verifying that this issue affects 5.0, please just set the "Affects version". Leave the "verify-affects-5.0" label and leave the issue in "Awaiting Response" status; these are critical for us to be able to track these verifications and triage them. Thanks.

Cody Lerum
January 24, 2018, 7:37 PM

I've run into this as well in 5.1.10 (Wildfly 11.0.0.Final)

I've created a PR with a test against the 5.1 branch - https://github.com/hibernate/hibernate-orm/pull/2131

Cody Lerum
January 24, 2018, 7:46 PM
Edited

The error in 5.x looks like the below for anyone else running into this.

Vlad Mihalcea
February 21, 2018, 3:47 PM

I pushed upstream the test case we received in a PR and the issue does not replicate on master.

Assignee

Unassigned

Reporter

Harold Campbell

Fix versions

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Minor
Configure