Hi everybody.

I'm a new user of hibernate and jsp and i have this problem:

I Have this method in my DAOBean class:

public Set listScheda() throws Exception {
try {
Set<Scheda> ret = new HashSet<Scheda>();
ret.addAll(manager.createQuery("from Scheda scheda").getResultList());
return ret;
} catch (Exception e) {
log.error("listScheda() - Failed to find scheda: "+e);
throw e;
}
}

I want a query like this :

select distinct taglia_scheda from scheda.

I try to do :

public Set listScheda() throws Exception {
try {
Set<Scheda> ret = new HashSet<Scheda>();
ret.addAll(manager.createQuery("select distinct scheda.taglia_scheda from Scheda scheda").getResultList());
return ret;
} catch (Exception e) {
log.error("listScheda() - Failed to find scheda: "+e);
throw e;
}
}

But it doesn't works

In particular it sends me an error like this:

java.lang.ClassCastException: java.lang.String
it.yacme.mystiquexml.business.YacmeBean.listTaglie(YacmeBean.java:158)

The method listTaglie is this one:

public Set listTaglie() throws Exception{
Set <Scheda> ret = new HashSet<Scheda>();
try{
Set<Scheda> list = yacmeDAO.listTaglie();
for (Iterator<Scheda> iterator = list.iterator(); iterator.hasNext();) {
Scheda s = iterator.next();
ret.add(s);
}
}catch (Exception e){
log.error("listTaglie() - Failed to list Taglie: "+e);
throw e;
}
return ret;

}

Can you Help me please?

Thanks

http://www.hibernate.org/hib_docs/refer ... ryhql.html

so your query could look like that:

Thanks but this is not what i want.

This HQL query is like SQL query: select distinct * from scheda;

I want: select distinct taglia_scheda from scheda;

i try to do:

public List listScheda() throws Exception {
return manager.createQuery("select distinct s.taglia_scheda from Scheda s").getResultList();
}

but this is the result:

java.lang.ClassCastException: java.lang.String
it.yacme.mystiquexml.business.YacmeBean.listTaglie(YacmeBean.java:174)

The query



only selects the taglia_scheda column, not complete Scheda objects. From the error message you get I assume that taglia_scheda is a string column. Then, your code should be like this:



Another option is to use a TreeSet instead of a HashSet and then use a Comparator that works on the taglia_scheda column. Eg. something like this:

getting java.lang.CastException

for(Iterator it=list.iterator();it.hasNext();){
[color=darkred]//***Getting exception at this line ********[/color] TestPayroll payroll = (TestPayroll) it.next();
}

Method below gets TestPayroll
public List getRecords(te....,....){
List list = (List)this.getHibernateTemplate().executeFind(
new HibernateCallback(){
public Object doInHibernate(Session session) throws
HibernateException, SQLException{
try{
Query query = session.createQuery("select distinct
payrollPK.accountId as accountID , payrollPK.empId as empId," +
"(select sum(e2.amount) from ErsxpPayroll e2 where e2.payrollPK.accountId = e1.payrollPK.accountId) as amount " +
"from TestPayroll e1 " +
"where client_code=:clientCode " +
"and rpcode=:rpCode " +
"and begdate >= :begDate " +
"and enddate <= :endDate " +
"and empid in (:empIdList) " +
"group by e1.payrollPK.accountId, e1.payrollPK.empId,e1.amount "
//,payrollPK.clientCode, begDate, payrollPK.endDate,rpCode,rpType,postDate
)


return query.List

getting java.lang.CastException

for(Iterator it=list.iterator();it.hasNext();){
[color=darkred]//***Getting exception at this line ********[/color] TestPayroll payroll = (TestPayroll) it.next();
}

Method below gets TestPayroll
public List getRecords(te....,....){
List list = (List)this.getHibernateTemplate().executeFind(
new HibernateCallback(){
public Object doInHibernate(Session session) throws
HibernateException, SQLException{
try{
Query query = session.createQuery("select distinct
payrollPK.accountId as accountID , payrollPK.empId as empId," +
"(select sum(e2.amount) from ErsxpPayroll e2 where e2.payrollPK.accountId = e1.payrollPK.accountId) as amount " +
"from TestPayroll e1 " +
"where client_code=:clientCode " +
"and rpcode=:rpCode " +
"and begdate >= :begDate " +
"and enddate <= :endDate " +
"and empid in (:empIdList) " +
"group by e1.payrollPK.accountId, e1.payrollPK.empId,e1.amount "
//,payrollPK.clientCode, begDate, payrollPK.endDate,rpCode,rpType,postDate
)


return query.List