Getting QuerySyntaxException: unexpected token

Question

Yes I know there are a few posts of this error, but none of em helped me. I get this error for my hql query:

@SuppressWarnings("unchecked")
@Override
public List<StaffRequest> getStaffLeaveRequest(String userID, Date startDate, Date endDate) 
{
    Session currentSession = sessionFactory.getCurrentSession();        

    List<StaffRequest> results = 
    currentSession.createQuery("select new com.timesheet_Webservice.CustomEnity.StaffRequest(lr.leave_ID, lr.leave_Employee, concat(s.staff_First_Name, ' ', s.staff_Last_Name), "
            + "(lr.leave_Days*8.5), lr.leave_Comments, '1805', concat(pro.project_Pastel_Prefix, ' - ', pro.project_Description), lr.leave_Start, lr.leave_End, lr.leave_IsApproved, "
            + "(select lt.leaveType_Description from LeaveType lt where lt.leaveType_ID = lr.leave_Type)) "
            + "from Staff s, Leave lr, Project pro "
            + "where lr.leave_Employee, = s.staff_Code and pro.project_Code = 1805 and lr.leave_Approved = :userID, and lr.leave_IsApproved = 0 and s.staff_IsEmployee <> 0 "
            + "and lr.leave_Start between :startDate and :endDate "
            + "order by concat(s.staff_First_Name, ' ', s.staff_Last_Name)")
                                .setParameter("userID",userID).setParameter("startDate", startDate).setParameter("endDate", endDate).getResultList();   

    return results;
}

I can't figure out what the problem is. I tried carefully retyping the query, I tried following the format of some of my similar queries that work, but still nothing. Please help

UPDATE: The full error is as follows after the correction from @Joakim Danielson

{"status":400,"message":"org.hibernate.hql.internal.ast.QuerySyntaxException: 
            unexpected token: , near line 1, column 665 [select new com.timesheet_Webservice.CustomEnity.StaffRequest(lr.leave_ID, lr.leave_Employee, concat(s.staff_First_Name, ' ', s.staff_Last_Name),
         (lr.leave_Days*8.5), lr.leave_Comments, '1805', concat(pro.project_Pastel_Prefix, ' - ', pro.project_Description),
    lr.leave_Start, lr.leave_End, lr.leave_IsApproved, (select lt.leaveType_Description from com.timesheet_Webservice.entity.LeaveType lt where lt.leaveType_ID = lr.leave_Type)) from com.timesheet_Webservice.entity.Staff s,
    com.timesheet_Webservice.entity.Leave lr, com.timesheet_Webservice.entity.Project pro where lr.leave_Employee = s.staff_Code and pro.project_Code = 1805 and lr.leave_Approved = :userID, 
and lr.leave_IsApproved = 0 and s.staff_IsEmployee <> 0 and lr.leave_Start between :startDate and :endDate order by concat(s.staff_First_Name, ' ', s.staff_Last_Name)]","timeStamp":1548935385459}

what is the exact error and where in the query does it point to? — Stultuske
– Stultuske, Commented Jan 31, 2019 at 10:50
added the full error. How does one trace the line 1 column thing to where it points? — Dean Strydom
– Dean Strydom, Commented Jan 31, 2019 at 11:56

Joakim Danielson · Accepted Answer · 2019-01-31 12:04:18Z

1

"where lr.leave_Employee, = s.staff_Code", remove the comma

where lr.leave_Employee = s.staff_Code

you have a second comma error in "lr.leave_Approved = :userID,"

lr.leave_Approved = :userID

Note that in your error message you have unexpected token: , near line 1, column 665 so if you paste the query printed in the error message into a text editor and remove the line breaks and extra spaces you will find the error in column (or position if you like) 665.

Off topic but may I suggest you learn about using JOIN in your queries, it improves readability a lot

edited Jan 31, 2019 at 12:04

answered Jan 31, 2019 at 11:35

Joakim Danielson

53.1k5 gold badges36 silver badges79 bronze badges

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

2 Comments

Dean Strydom Over a year ago

Really thought this would be the end of my troubles, but still get the error. Saves me a fix for later though thanks. I will look into it

Joakim Danielson Over a year ago

@DeanStrydom, another comma to much found

Collectives™ on Stack Overflow

Getting QuerySyntaxException: unexpected token

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related