项目中一个搜索功能出现了BUG,点击搜索后无反应,到后台一看,原来报了以下异常
一眼便看出这出数据库查询语句语法有错,于是跟踪到出错的代码,发现是用Hibernate的HQL查询执行语句的,于是在执行语句前打印出来Domain.finAll(sql, params)的参数
其中searchQuery与queryParams为两个参数,InventoryItem是对应查询的domain,至于两个参数是怎么形成的这里不是重点,打印的结果如下:
searchQuery:
from InventoryItem as inventoryItem where inventoryItem.isClinicDrugList=true and (inventoryItem.registrationNo like :searchStr or inventoryItem.clinicDrugNo like :searchStr or inventoryItem.productName like :searchStr or inventoryItem.dangerousSign like :searchStr or inventoryItem.alias like :searchStr or inventoryItem.stockQty like :searchStr or inventoryItem.reorderLevel like :searchStr or inventoryItem.unit like :searchStr or inventoryItem.expectedQty like :searchStr or inventoryItem.reorderStatus like :searchStr or inventoryItem