db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joerg Friedrich (JIRA)" <j...@apache.org>
Subject [jira] Kommentiert: (TORQUE-6) Generator does not generate foreign key constraints for Interbase/Firebird
Date Wed, 26 Apr 2006 15:30:03 GMT
    [ http://issues.apache.org/jira/browse/TORQUE-6?page=comments#action_12376498 ] 

Joerg Friedrich commented on TORQUE-6:

I have made the following changes and tested with Firebird 1.5 (directory ...\templates\src\templates\sql\base\interbase:

1. remove the only active line from drop.vm since it creates exceptions if the table does
not exist
2. modified file tablefk.vm (took the one from Oracle)
3. modified file foreignkey.vm (took the one from Oracle as suggested above)

Then it looks okay in my tests.

> Generator does not generate foreign key constraints for Interbase/Firebird
> --------------------------------------------------------------------------
>          Key: TORQUE-6
>          URL: http://issues.apache.org/jira/browse/TORQUE-6
>      Project: Torque
>         Type: Bug

>   Components: Generator
>     Versions: 3.2
>     Reporter: Joerg Friedrich

> The generator does not generate foreign key constraints for Interbase/Firebird. This
could probably be easily fixed by adding a file foreignkey.vm to the sql/base/interbase directory
in the templates jar (torque-gen-templates-3.2.jar) containing this:
> #foreach ($fk in $table.ForeignKeys)
>     FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames),
> #end

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message