[hibernate-issues] [Hibernate-JIRA] Moved: (HV-15) @Past validation annotation generates incorrect DDL for Oracle 8.x

[Emmanuel Bernard (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HV-15?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Emmanuel Bernard moved ANN-21 to HV-15:
---------------------------------------

    Affects Version/s:     (was: 3.1beta3)
          Component/s:     (was: validator)
                  Key: HV-15  (was: ANN-21)
              Project: Hibernate Validator  (was: Hibernate Annotations)

> @Past validation annotation generates incorrect DDL for Oracle 8.x
> ------------------------------------------------------------------
>
>                 Key: HV-15
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HV-15
>             Project: Hibernate Validator
>          Issue Type: Bug
>         Environment: Hibernate 3.0.5
> Oracle 8.1.7 (running on Win XP Pro)
>            Reporter: Aye Thu
>            Priority: Minor
>
> The following validation code:
>     @Past
>     public Date getBirthDate()
>     {
>         return birthDate;
>     } 
> produces the following DDL when using the OracleDialect:
> create table Person (party_id number(19,0) not null, birth_date date check (birth_date < current_date), primary key (party_id)) 
> The "current_date" was introduced only in Oracle 9i and is not available in earlier Oracle versions and the following SQL exception is thrown:
> ORA-02438: Column check constraint cannot reference other columns 
> According to Gavin, the current validation framework is not aware of Dialects. (http://forum.hibernate.org/viewtopic.php?t=943378)

-- 
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