java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: null near line 1,

Question

java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: null near line 1, column 226 [SELECT COUNT(*) FROM com.pmp.vupadhi.model.EmpLeave WHERE ((start_date >=:startdate AND start_date <=:enddate) OR (end_date >=:startdate AND end_date <=:enddate)) AND em_id =:id AND (leave_status !=103 AND leave_status !=104]

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community
– Community Bot, Commented Sep 10, 2021 at 11:49

Christian Beikov · Accepted Answer · 2021-09-13 11:53:36Z

1

You are missing a closing parenthesis ) at the end.

answered Sep 13, 2021 at 11:53

Christian Beikov

16.6k2 gold badges36 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alien · Accepted Answer · 2021-09-06 08:59:11Z

0

Can you try <> operator for not equal to.

leave_status <> 104

Also give an alias and then do COUNT(alias) instead of a *.

edited Sep 6, 2021 at 8:59

answered Sep 6, 2021 at 8:01

Alien

16k8 gold badges43 silver badges64 bronze badges

1 Comment

Srinivasulu Ch Over a year ago

still getting the same error but in column 235......thanks for u r effort

Kirinya · Accepted Answer · 2021-09-06 10:50:46Z

0

You might have a null parameter even when you do not expect that. Try logging the parameters like described in https://www.baeldung.com/hibernate-logging-levels and check for null values.

answered Sep 6, 2021 at 10:50

Kirinya

2453 silver badges12 bronze badges

Collectives™ on Stack Overflow

java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: null near line 1,

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related