hibernate.jpa.criteria.BasicPathUsageException: Cannot join to attribute of basic type

Question

I have two tables: Tax and TaxRule. There is one column same in both table i.e TAX_RULE_ID. But don't have any Hibernate mapping like OneToOne or OneToMany. Both table looks like-

TAX

@Id
@Column(name = "TAX_RATE_ID")
private Long taxRateId;

@Column(name = "TAX_RULE_ID")
private Long taxRuleId;

@Column(name = "TAX_TYPE")
private String taxType;

TAX_RULE

@Id
@Column(name = "TAX_RULE_ID")
private Long taxRuleId;

@Column(name = "TAX_CD")
private String TaxCode;

@Column(name = "STATE")
private String state;

I am trying to fetch data on the key i.e TAX_RULE_ID. This column is common in both table. I have following Hibernate code in which I am joining both table on the TAX_RULE_ID column as follows:

CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<String[]> cQuery =        criteriaBuilder.createQuery(String[].class);
Root<Tax> taxRoot = cQuery.from(Tax.class);

cQuery.multiselect(taxRateRoot.get("taxType"), taxRateRoot.get("taxRate"));
List<Predicate> predicates = new ArrayList<>();
Join<Tax, TaxRule> join = taxRoot.join("taxRuleId"); 
.....rest of the code.

I am getting following Exception on the join point:

org.hibernate.jpa.criteria.BasicPathUsageException: Cannot join to attribute of basic type
at   org.hibernate.jpa.criteria.path.AbstractFromImpl.constructJoin(AbstractFromImpl.java:270)
at org.hibernate.jpa.criteria.path.AbstractFromImpl.join(AbstractFromImpl.java:263)
at org.hibernate.jpa.criteria.path.AbstractFromImpl.join(AbstractFromImpl.java:436)
at com.iclsystems.base.dao.TaxRateDAOImpl.getTaxTypeForApplicableWorkOrderTax(TaxRateDAOImpl.java:31)
at com.iclsystems.base.businessObjects.TaxLookupBOImpl.getTaxTypeForApplicableWorkOrderTax(TaxLookupBOImpl.java:53)
at com.iclsystems.base.businessObjects.TaxLookupBOImpl.getWorkOrderTaxLookup(TaxLookupBOImpl.java:29)
at com.iclsystems.test.eventhandler.base.TaxLookupBOTest.testTaxLookupBO(TaxLookupBOTest.java:52)

as the message says, you cannot join on a non-relation field. There is no relation in "taxRuleId". — Neil Stockton
– Neil Stockton, Commented May 11, 2015 at 12:29
@Avinash did you find a solution for joining basic property using criteria? — kio21
– kio21, Commented May 2, 2024 at 13:10

Vlad Mihalcea · Accepted Answer · 2020-11-28 12:35:30Z

22

You cannot use the @Join annotation for a basic property (e.g., an attribute with a simple @Column mapping). @Join is for associations:

one-to-one
one-to-many
many-to-one
many-to-many

You need to remove this line, as the taxRuleId is already fetched from the database:

Join<Tax, TaxRule> join = taxRoot.join("taxRuleId");

If you want to join the TaxRule table, you need to replace the:

@Column(name = "TAX_RULE_ID")
private Long taxRuleId;

with a many-to-one association:

@ManyToOne
@JoinColumn(name = "TAX_RULE_ID")
private TaxRule raxRule;

edited Nov 28, 2020 at 12:35

answered May 11, 2015 at 12:32

Vlad Mihalcea

156k85 gold badges599 silver badges984 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Georgios Stathis Over a year ago

And what if you cannot alter TAX by adding the many-to-one association? Is it possible to do the join? I only ask because my entities are already fixed.

Sumit Over a year ago

is it possible to filter out rows from the child table but fetch using the parent table this way?

Vlad Mihalcea Over a year ago

If you fetch the child entities using a query, anything is possible. If you try to filter the collection while join fetching it, it will not be possible.

Collectives™ on Stack Overflow

hibernate.jpa.criteria.BasicPathUsageException: Cannot join to attribute of basic type

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related