Request processing failed; nested exception is org.hibernate.hql.internal.ast.QuerySyntaxException:

@Transactional
public List<SpecialOrder> getSpecialOrder(List<Integer> invoiceList) {

List<SpecialOrder> getspecialorder = new ArrayList<>();

Session session = sessionFactory.getCurrentSession();
String hSql = "Select i.invoicenumber, i.partnumber, i.quantity, p.partdescription from invoicedetials i, Part p where i.invoicenumber in :invoiceList, p.partNo=i.partnumber and quantity <0";

Query query = session.createQuery(hSql);

query.setParameterList("invoiceList", invoiceList);

getspecialorder = query.list();

session.flush();
session.clear();

return getspecialorder;

}

Controller


@RequestMapping("specialorder")
public ModelAndView SpecialOrder(@RequestParam("invoiceno") String invoiceno, Model map, HttpSession session,
ModelAndView mav) {

AppUser user = (AppUser) session.getAttribute("user");
if (user == null) {
throw new OrderNotFoundException();
} else {

List<Integer> invoiceNoList = new ArrayList();

if (invoiceno.contains(",")) {
String[] array = invoiceno.split(",");
for (String s : array) {
invoiceNoList.add(Integer.parseInt(s));
}
} else {
invoiceNoList.add(Integer.parseInt(invoiceno));
}

List<SpecialOrder> invoiceList = ordersService.getSpecialOrder(invoiceNoList);
System.out.println("invoice list  = " + invoiceList);

mav.clear();
// mav.setView(new SpecialOrderExcelView());
mav.setViewName("specialorderpage");
mav.addObject("user", user);
mav.addObject("branch", branch);
mav.addObject("appcss", appcss);
mav.addObject("sysdate", InsightUtils.getNewUSDate());
mav.addObject("invoiceList", invoiceList);
}
return mav;

}

Request processing failed; nested exception is org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: , near line 1, column 136 [Select i.invoicenumber, i.partnumber, i.quantity, p.partdescription from invoicedetials i, Part p where i.invoicenumber in :invoiceList, p.partNo=i.partnumber and quantity <0] .

How to solve this issue. ?

An IN clause is in brackets:
WHERE something IN (:myParameter)

Welcome to the Ranch, Muhammad! Our message editor has a button that inserts Code tags into your message. Code tags wrap around pre-formatted text such as Java code, SQL statements, XML, and so forth. They make it easier for people to read your examples.

Just for information, here's what "org.hibernate.hql.internal.ast.QuerySyntaxException" actually means.

org.hibernate - that's who provided the code that defines that exception (hibernate.org)

hql - stands for Hibernate Query Language

internal - it's an internal component of the HQL processor

ast - stands for Abstract Syntax Tree. An AST is what a compiler uses when breaking down source code into its components. The AST holds the individual components as nodes where they can be referenced by the compiling process. An AST in Graph Theory is a type of Directed Acyclic Graph. For your purposes, it's enough to know that an SQL statement was being compiled.

And last, but not least, QuerySyntaxException tells us that the SQL query statement you tried to use has invalid syntax. And Dave has given you the answer as to what part of the SQL query was invalid!