Exception: cast() requires two arguments ---------------------------------------- Key: HHH-3834 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3834 Project: Hibernate Core Issue Type: Bug Environment: hibernate3, postgresql 8.3 Reporter: Paulo Angelo Got exaclty the same as in HHH-3285 .: cast() requires two arguments [select f from MenuItem f where ( ( UPPER( TO_ASCII(CAST(convert(f.Menu.Idme, 'UTF8', 'LATIN1') , TEXT),'LATIN1')) LIKE UPPER( TO_ASCII(CAST(convert('M10', 'UTF8', 'LATIN1') , TEXT),'LATIN1')) ) ) order by f.Orde ASC ] But there is not a extra ")" (I think, :) ) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira