[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2013) While Using DetachedCriteria as subselect if the detached criteria has a subCriteria exception is being thrown

[SourceLabs, Inc. (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2013?page=comments#action_23988 ] 

SourceLabs, Inc. commented on HHH-2013:
---------------------------------------

Would you provide the mapping for Shop and StatusDTO as well as the SQL that gets generated.

It would also help if you check the following to narrow down where the problem might be:

detachedCriteria.setProjection(Projections.id());      // -------------> use Projections.id() instead.
ids = new LinkedHashSet(detachedCriteria .getExecutableCriteria(session).list());

Criteria criteria = session.createCriteria(StatusDTO.class);
criteria.add(Property.forName("transactionID").in(detachedCriteria ));
criteria.list()


> While Using DetachedCriteria as subselect if the detached criteria has a subCriteria exception is being thrown
> --------------------------------------------------------------------------------------------------------------
>
>          Key: HHH-2013
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2013
>      Project: Hibernate3
>         Type: Bug

>     Versions: 3.0.5
>  Environment: HIbernate 3.0.5 Oracle
>     Reporter: Dilip Ranjith

>
>
> While Using DetachedCriteria as subselect if the detached criteria has a subCriteria exception is being thrown
> DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Shop.class);
> detachedCriteria .createCriteria("productDTO").add(Restrictions.eq("ID", productCode.toString()));
> shopSet = new LinkedHashSet(detachedCriteria .getExecutableCriteria(session).list()); ---> Works correctly
> detachedCriteria .setProjection(Projections.property("ID"));----------> projection in DetachedCriteria
> Criteria criteria = session.createCriteria(StatusDTO.class);
> criteria .add(Property.forName("transactionID").in(detachedCriteria )); 
> criteria .list() --------------> (Gives exception)
> Throws an SQLGrammerException 
> java.sql.SQLException: ORA-00904: "PRODUCTMAS1_"."PRODUCTID": invalid identifier

-- 
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