[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2322) SchemaExport : for foreign keys columns, it should use the sql-type attribute instead of the type if present

[Baptiste MATHUS (JIRA)]

SchemaExport : for foreign keys columns, it should use the sql-type attribute instead of the type if present
------------------------------------------------------------------------------------------------------------

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

    Versions: 3.2.1    
 Environment: Oracle 10G, Hibernate 3.2.1
    Reporter: Baptiste MATHUS
 Attachments: example.zip, schema.sql

SchemaExport does not seem to be using the sql-type attribute if it is present.

It leads to an error when trying to create constraints between columns that don't share the same type.

Two files are attached :
* the example project that shows this, the interesting part to look at is for example the relation between Client and
* the generated sql file, for example this constraint throws an error :
alter table LIGNEDEFACTURE
        add constraint FKB488EF3A8E50545C
        foreign key (PRODUIT_ID)
        references PRODUIT

Thanks a lot for this wonderful product.

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