File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Criteria query select specific columns from several entities

 
orm newbie
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have an entity A, which has entity B and B has entity C : A -> B -> (collection of C)
I want to form a criteria query and select all columns from A, all columns from B and specific columns from C.
I wrote a query using Criteria and Projections, but its querying only the specified columns of entity C and none from A or B.

Here is my query :
Criteria crit = s.createCriteria(A.class, "tableA")
.add(Restrictions.eq("Id", 100))
.createAlias("b", "tableB")
.createAlias("tableB.c", "tableC");

ProjectionList proList = Projections.projectionList();
proList.add(Projections.property("tableC.prop1"));
proList.add(Projections.property("tableC.prop2"));
proList.add(Projections.property("tableC.prop3"));
crit.setProjection(proList);
crit.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);

Can somebody tell me how can I tune this query ?
Thanks much in advance.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic