I am trying a hql like this

Select avg((totalScore/maxScore)*100) from XBean
When I am getting its result. Result is having 7 digits as precision. I want to set its width and precision. How can I do the same ?

Thanks,
Gopal

Hi

try this

Select CONVERT(decimal(10,5), avg((totalScore/maxScore)*100)) from XBean



Amila

(Don't forget to rate if helps)

Thnx Amila,

I already tried the same thing. java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.MethodNode and java.lang.NullPointerException Exceptions are coming. I am applying the same thing suggested by you. But This is not working.


Thnx,
Gopal

Hi

ok Gopal , Actually I didn't test it.

You can do it like this.

in your mapping file you can define a property for a formula



Select formulaField from XBean


Amila

(Don't forget to rate if helps)

[quote="amila733"]Hi

ok Gopal , Actually I didn't test it.

You can do it like this.

in your mapping file you can define a property for a formula



Select formulaField from XBean


Hi Amila,


Sorry for late reply. I tried the same suggested by you. i am not getting precision set. I also tried with length attribute. but This is not working. Is There not a way to set this in the query itself ?

Thanks,
Gopal