Java DAO create query please help

[alvin0618]

I am not sure whether i posted this thread at the right place. Anyway my problem at below

public class Student()
      private String name;
      private String id;
      private int marks;
      private Date issueOn;
......
......
}

public class StudentDaoImpl extends HibernateDaoSupport implements StudentnDao{
           public ArrayList<Student> getSumMarkl(String dayStart, String dayEnd)throws DataAccessException{
           Session session = this.getSession();
           ArrayList<Student> stdList = new ArrayList<Student>();
           try{
                             Query query = session.createQuery("select s.name, s.id, SUM(ms.marks) 
                              from Student s 
                              where TO_CHAR(TRUNC(s.issueOn),'YYYYMMDD') 
                              between '"+dayStart+"' AND '"+dayEnd+"' 
                              GROUP BY s.name, s.id 
                              ORDER BY ms.id  ASC");
.....................................................
System.out.println("List size: " + query.list().size());
................................................
// the list contains value
//how do i get the result into my ArrayList?
...................................................
.............................................
}

[r035198x]

Is Student an entity? The usual thing is to use entities and execute the query on an EntityManager that you create or lookup.

[alvin0618]

Is Student an entity? The usual thing is to use entities and execute the query on an EntityManager that you create or lookup.

Yes, it is an entity. Can you more elaborate?

[r035198x]

Elaborate which part? The key thing you are missing in your code is the EntityManager which you use to communicate with the datastore.

[alvin0618]

Elaborate which part? The key thing you are missing in your code is the EntityManager which you use to communicate with the datastore.

Inside my DAO implementation, i got others methods which working fine. Something like this.getHibernateTemplate().find(query);

But for this method, it is varies to others which need to SUM the marks from the db. The connection is connected.

[r035198x]

So check the documentation of your HibernateDaoSupport and HibernateTemplate to find out how to map the returned values to your DAOs. They are non-standard classes that we don't have so only their authors will be able to help you.