Casting values in an HQL Query

Question

I'm running the following as part of the where clause of an HQL query:

:timeToTopOfList = ((CAST((j.displayed_position - 1) AS FLOAT) / jp.openings_per_month) * 30)

When I run it in SQL Management studio it works just fine, but when I run it through eclipse I get the following error:

Caused by: java.lang.NullPointerException org.hibernate.dialect.function.CastFunction.render(CastFunction.java:55)

I'm also using JPA, and according to this answer you cannot convert types if you're using JPA. Is that true?

I really need to divide two int value columns as a float.

Is it part of the select clause or of the where clause? – JB Nizet Aug 07 '12 at 21:11 — JB Nizet, Aug 07 '12 at 21:11
As I mentioned, it's part of the where clause. – Hanna Aug 07 '12 at 22:28 — Hanna, Aug 07 '12 at 22:28

score 1 · Answer 1 · answered May 23 '18 at 14:04

1

I faced a similar issue when casting to string.

It was resolved by typing in 'string' in lower case.

Try with lower case 'float'

Check out the below link for an explanation:

answered May 23 '18 at 14:04

Prafful Nagpal

1 Answers1