cast(stringvalue AS decimal)

bowa · **Posted:** Mon Jan 07, 2008 8:21 am

'stringvalue' comes from a varchar mysql column, in sql i can use things like

Code:

... where cast(extra as decimal) > 100

when it try this in HQL it gives me a nullpointer.

Code:

java.lang.NullPointerException
   at org.hibernate.dialect.function.CastFunction.render(CastFunction.java:36)
   at org.hibernate.hql.ast.SqlGenerator.endFunctionTemplate(SqlGenerator.java:127)

using Hibernate 2.3.10 and Mysql 5.0.37

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

bowa,

I never used cast(), but the documentation says that

1) cast must be supported by the underlying database (not a problem in this case)

2) the second argument has to be a Hibernate type. I believe "decimal" is not a Hibernate type.

Maybe try another type?

kingArthur · **Joined:** Tue Oct 11, 2011 1:14 am **Posts:** 1

try

Code:

cast(stringvalue as big_decimal)