pl help for the foollowing query it throws exception
_____________________
query
_______
String HQL="from HelpdeskArticles n where lower(n.title) like :searchText or lower(n.description) like :searchText and
newsList=session.createQuery(HQL).setParameter("searchText","%"+searchFilter.getSearchText().toLowerCase()+"%").
_____________________________
exception
________
org.hibernate.exception.SQLGrammarException: could not execute query
com.ibm.db2.jcc.b.SqlException: No authorized routine named "UPPER" of type "FUNCTION" having compatible arguments was found.
The DB column data type for description is CLOB , can't we apply lower() function for CLOB type column
|