[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6840) to_char function with hsqldb doesn't work

to_char function with hsqldb doesn't work ----------------------------------------- Key: HHH-6840 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6840 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.6.8 Environment: Hibernate 3.6.8.Final and HSQLDB 2.2.4 Reporter: Roozbeh Maadani Priority: Minor Hi, We are developing a project which uses hibernate 3.6.8.final , Oracle 10g database in production and a in-memory Hsqldb for unittests. In our hql queries, we use "to_char" function which should work both for Oracle 10g and Hsqldb version 2.2 and above. There is no problem in production (Oracle10gDialect) but when we run the tests (for tests we use HSQLDialect ) we get the following mystic error: org.hsqldb.HsqlException: user lacks privilege or object not found: TO_CHAR And it is possible to see in the logs that HSQLDialect doesn't generate correct sql. After tracing the code I found out that HSQLDialect doesn't register "to_char" function for hsqldb 2.2.x. The following code solved the problem: public class MyHSQLDialect extends HSQLDialect { public MyHSQLDialect() { super(); registerFunction( "to_char", new StandardSQLFunction( "to_char" ) ); } } I suppose it is possible to move this code to the HSQLDialect constructor and solve this issue. Regards, Roozbeh Maadani -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira