I have a custom util class called LessonView.  It looks like this:

public class LessonView{
  | private String subject;
  | private int year, count;
  | 
  | public LessonView(){}
  | 
  | public LessonView(String subject, int year, int count){
  |   sets the variables via setters
  | }
  | 
  | public getters and setters
  | }

Then I have a query:
"select new LessonView(l.subject, l.year, count(*)) from Lesson l group by 
l.lesson, l.year order by l.lesson, l.year";

This throws exceptions telling me there is no suitable constructor.  When the 
count(*) is removed everything works fine.  I have used custom classes before 
with sum(whatever.k) and it worked fine.  I have also tried count(l.id), same 
results.

Any idea how to fix this?  The database is MySQL.  

Thanks,

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4021964#4021964

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4021964
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to