Message Title

Thomas Rauner created an issue

HHH-10024

Issue Type:	Bug
Affects Versions:	5.0.0.CR4, 5.0.0.CR3, 4.3.10
Assignee:	Unassigned
Attachments:	TestCase.zip
Components:	hibernate-entitymanager
Created:	07/Aug/2015 00:34 AM
Environment:	Database H2 1.3.176
Priority:	Major
Reporter:	Thomas Rauner

In short :

Two JPA-entites A and B are mapped via @OneToMany.
B contains an enum field named 'size'.
When querying (JPA-Criteria-API) on 'A join B' using where on the field 'size', java.lang.IllegalArgumentException (Parameter value [...] did not match expected type [java.lang.Integer]) is thrown.
Renaming the field to anything other than 'size' fixes the issue.

More detailed:

 
                                                    @Entity
public class A {
	@OneToMany(cascade={CascadeType.ALL}) 
	private List<B> bs;
...
}
 
                                                

 
                                                    @Entity
public class B {
	@Enumerated(EnumType.STRING)
	private AnyEnumType size;
...
}
 
                                                

 
                                                    //Method fails with exception
public List<A> findBySize(AnyEnumType size)
{
	CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
	CriteriaQuery<A> query = criteriaBuilder.createQuery(A.class);
	Root<A> root = query.from(A.class);
	Path<AnyEnumType> path = root.<A,B>join("bs").<AnyEnumType>get("size"); 
	query.where(criteriaBuilder.equal(path, size));
		
	//Throws here
	return entityManager.createQuery(query).getResultList();
}
 
                                                

The following exception is thrown:

 
                                                    java.lang.IllegalArgumentException: Parameter value [LARGE] did not match expected type [java.lang.Integer (n/a)]
	at org.hibernate.jpa.spi.BaseQueryImpl.validateBinding(BaseQueryImpl.java:858)
	at org.hibernate.jpa.internal.QueryImpl.access$000(QueryImpl.java:62)
	at org.hibernate.jpa.internal.QueryImpl$ParameterRegistrationImpl.bindValue(QueryImpl.java:235)
	at org.hibernate.jpa.spi.BaseQueryImpl.setParameter(BaseQueryImpl.java:603)
	at org.hibernate.jpa.spi.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:163)
	at org.hibernate.jpa.spi.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:32)
	at org.hibernate.jpa.criteria.compile.CriteriaCompiler$1$1.bind(CriteriaCompiler.java:109)
	at org.hibernate.jpa.criteria.CriteriaQueryImpl$1.buildCompiledQuery(CriteriaQueryImpl.java:369)
	at org.hibernate.jpa.criteria.compile.CriteriaCompiler.compile(CriteriaCompiler.java:130)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:699)
...
 
                                                

Attached you'll find one testcase to reproduce the issue.

Add Comment

This message was sent by Atlassian JIRA