[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2424) InformixDialect uses wrong date methods mapping

[Giltal Tzabar (JIRA)]

InformixDialect uses wrong date methods mapping
-----------------------------------------------

         Key: HHH-2424
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2424
     Project: Hibernate3
        Type: Bug

  Components: query-hql  
    Versions: 3.2.2    
 Environment: Informix
    Reporter: Giltal Tzabar
 Attachments: Informix10Dialect.java

The InformixDialect extends the Dialect class but does not replace the 
date methods mappings.

To correct this bug you need to write the following lines in the dialect default constructor:

// Map second/minute/hour/day/month/year, override on subclasses
registerFunction("second", new SQLFunctionTemplate(Hibernate.INTEGER, "second(?1)"));
registerFunction("minute", new SQLFunctionTemplate(Hibernate.INTEGER, "minute(?1)"));
registerFunction("hour", new SQLFunctionTemplate(Hibernate.INTEGER, "hour(?1)"));
registerFunction("day", new SQLFunctionTemplate(Hibernate.INTEGER, "day(?1)"));
registerFunction("month", new SQLFunctionTemplate(Hibernate.INTEGER, "month(?1)"));
registerFunction("year", new SQLFunctionTemplate(Hibernate.INTEGER, "year(?1)"));


-- 
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.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira