Hibernate version: 3.1

Hi all,

I am using Criteria API to run a qry. Is there any way to restrict the fields in the select stmt(say only 4 fields out of 10 fields)? I don't want to have all the fields in the select statement.


Thanks

If you mean fields in the where clause, that already happens.

If you mean fields in the select clause, then no. Criteria query for objects, not result sets: to build an object, hibernate needs all of its values. You can't build an object from some of the fields: that's just a partial object.

The exception to this are projection Criteria: count, max, group by, etc.
The best ways to get just a few fields from a few rows is to use SQL or HQL. Criteria aren't suited to this task.

ok

I am trying to restrict the field selection using data-transfer JavaBean objects (http://www.javalobby.org/articles/hiber ... /#advanced). But getting error. Below are the details.

Thanks
gajini
--------------------------------$-----------Hibernate version: 3.1 -------

TblEvent
-------
id
title
date

titleDTO.java : temp Java Bean
-----------
title : String


Between Trans:
------------------
String qry1 = "select new titleDTO(evt.title) from Event evt";
List result = session.createQuery("qry1").list();
Object evt = (Object)result.get(1);
S.o.p( evt.toString() );

Error
-------
Initial SessionFactory creation failed.org.hibernate.HibernateException: Errors in named queries: eventQry
java.lang.ExceptionInInitializerError
at util.HibernateUtil.<clinit>(HibernateUtil.java:17)
at events.EventManager.main(EventManager.java:22)
Caused by: org.hibernate.HibernateException: Errors in named queries: eventQry
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:339)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
at util.HibernateUtil.<clinit>(HibernateUtil.java:13)
... 1 more
Exception in thread "main"
--------------------------------$------------------------------------

titleDTO.java
-----------------------

public class titleDTO implements Serializable{

private String title;

public titleDTO(){}

public titleDTO(String title){
this.title=title;
}

public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
}[/b]

hey

got it


thanks