[hibernate-issues] [Hibernate-JIRA] Created: (HHH-5023) Tuple selection with JPA 2.0 Criteria API fails (java.lang.ClassCastException: org.hibernate.ejb.criteria.expression.CompoundSelectionImpl cannot be cast to org.hibernate.ejb.criteria.expression.ExpressionImplementor)

[atomicknight (JIRA)]

Tuple selection with JPA 2.0 Criteria API fails (java.lang.ClassCastException: org.hibernate.ejb.criteria.expression.CompoundSelectionImpl cannot be cast to org.hibernate.ejb.criteria.expression.ExpressionImplementor)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: HHH-5023
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5023
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.5.0-CR-2
         Environment: Hibernate 3.5.0-CR-2
PostgreSQL 8.4.1
Glassfish v3 (build 74.2)
JDK 1.6.0_18
            Reporter: atomicknight
         Attachments: jpa-test-eclipselink.war, jpa-test-hibernate.war, test.sql

Attempting to select a Tuple using the JPA 2.0 Criteria API throws a ClassCastException.

Example Java code:
{noformat}
public List<Tuple> selectTuple1( ) {
	CriteriaBuilder cb = em.getCriteriaBuilder( );
	CriteriaQuery<Tuple> cq = cb.createTupleQuery( );
	
	Root<TestEntity2> e2 = cq.from( TestEntity2.class );
	cq.multiselect( e2.get( "id" ), e2.get( "value" ) );
	
	TypedQuery<Tuple> query = em.createQuery( cq );
	return query.getResultList( );
}
{noformat} 

Example stack trace:
{noformat}
javax.ejb.EJBException
	at com.sun.ejb.containers.BaseContainer.processSystemException(BaseContainer.java:5070)
	at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:4968)
	at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4756)
	at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1955)
	at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1906)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:198)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:84)
	at $Proxy297.selectTuple1(Unknown Source)
	at com.example.__EJB31_Generated__JPABean__Intf____Bean__.selectTuple1(Unknown Source)
	at com.example.JPAServlet.doGet(JPAServlet.java:35)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
	at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641)
...
Caused by: java.lang.ClassCastException: org.hibernate.ejb.criteria.expression.CompoundSelectionImpl cannot be cast to org.hibernate.ejb.criteria.expression.ExpressionImplementor
	at org.hibernate.ejb.criteria.QueryStructure.render(QueryStructure.java:220)
	at org.hibernate.ejb.criteria.CriteriaQueryImpl.render(CriteriaQueryImpl.java:338)
	at org.hibernate.ejb.criteria.CriteriaQueryCompiler.compile(CriteriaQueryCompiler.java:102)
	at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:158)
	at com.sun.enterprise.container.common.impl.EntityManagerWrapper.createQuery(EntityManagerWrapper.java:489)
	at com.example.JPABean.selectTuple1(JPABean.java:39)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
...
{noformat} 

Other variations such as the following also throw the same exception:
{noformat}
cq.select( cb.tuple( e2.get( "id" ), e2.get( "value" ) ) );
{noformat} 

The same code works without issue using the EclipseLink persistence provider bundled with Glassfish v3.

The test code is included in the attached WAR files. The two WAR files are identical except for the persistence provider configuration in persistence.xml. A dump of the PostgreSQL database is also included.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira