[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5056) Criteria API with ProjectionList and Unique result
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5056?page=c...
]
Ahmed Ali Elsayed Ali Soliman commented on HHH-5056:
----------------------------------------------------
First i use java property not a DB table.
Second: it doesn't work for hql either
when using (select id, name from bean) then using
query.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
it returns one dimensional array with the last column [name] only not two dimensional
array with [id, name]
Criteria API with ProjectionList and Unique result
--------------------------------------------------
Key: HHH-5056
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5056
Project: Hibernate Core
Issue Type: Bug
Components: query-criteria
Affects Versions: 3.5.0-CR-2
Environment: Hibernate 3.3.2, Oracel 11g
Reporter: Ahmed Ali Elsayed Ali Soliman
Assignee: Gail Badner
Priority: Critical
when you make a select statement with Criteria API & use ProjectionList to retrieve
some columns then use the unique result
make at least 2 projection list (2 columns or more)
ProjectionList projectionList =
Projections.projectionList() .add(Projections.property("ColumnA")) .add(Projections.property("ColumnB"));
criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
the result must be retrieved in 2 dimensional array of Object(Object[][])
but the result are one dimensional array with one column only.
Note:- when you remove the unique result it works fine but when you add it, it make this
behavior.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira