Hibernate Hibernate Avg

Change the query as

String SQL_QUERY = "select avg
(insurance.investementAmount) from Insurance insurance";

So that the above example will be executed.

Posted by Elay on Monday, 09.22.08 @ 15:49pm | #80598

Dear sir,

I m trying to run the above example but it is going into the exeption after the line


List list = query.list();

giving me the following err

No data type for node: org.hibernate.hql.ast.AggregateNode
[AGGREGATE] AggregateNode: 'min'
[ALIAS_REF] IdentNode: 'investementAmount' {alias=investementAmount, no from element}

Kinldy help me

Regards,
Abhishek

Posted by abhishek on Monday, 09.8.08 @ 16:06pm | #78009

Dear RoseIndia,

I m getting error in running the above sample

while debugging I m getting error on line

List list = query.list();

Kindly let me know is it the issue of compatibility of any installation.

Abhishek

Posted by abhishek on Monday, 09.8.08 @ 15:11pm | #77997

I want to retrieve max values of one column for all unique values of another column.Can any one help me to write the HQl query?

Posted by kisor on Tuesday, 02.26.08 @ 18:32pm | #50145

I want to learn how to display data in PDF from java program.

Posted by Manoj on Monday, 02.11.08 @ 17:23pm | #47904

Hi,

Could you please give me the mapping and config files for select query.


thanks
Revathi

Posted by revathi on Thursday, 12.27.07 @ 13:38pm | #43940

RoseIndian,

I want to learn how to retrieve data from xls sheet to the java program

Posted by praveena on Thursday, 12.6.07 @ 14:43pm | #41429