ClassicQueryTranslatorFactory & Custom Functions Doesn't work? -------------------------------------------------------------- Key: HHH-3956 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3956 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.3.1 Reporter: Sandeep Vaid I am using hibernate 3.2.1-ga version. I have extended the DB2Dialect and defined my own function: registerFunction("svminus1", new SQLFunctionTemplate( Hibernate.TIME, "current time") ); It is working fine with ASTQueryTranslatorFactory HQL: select svminus1() from Temp c where c.id=1 SQL: select current time as col_0_0_ from TEMP c0_ where c0_.ID=1 But when i use ClassicQueryTranslatorFactory, it gives me errors: HQL: select svminus1() from Temp c where c.id=1 SQL: select svminus1() as col_0_0_ from LIS.TBCONTROL controldat0_ where (controldat0_.CONTROLID=1000001221 ) COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named "SVMINUS1" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884 Why am i getting this error? Also when converting HQL to SQL, it hasn;t replaced my custom function with it's definition. -- 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