db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Benoist (JIRA)" <j...@apache.org>
Subject [jira] Commented: (TORQUE-104) Sybase DBMS DDL errors
Date Fri, 26 Oct 2007 13:59:50 GMT

    [ https://issues.apache.org/jira/browse/TORQUE-104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12537964

Sylvain Benoist commented on TORQUE-104:

The templates *do* work when submitted via SqlExec, thx.

given that there is a <delimiter> option that is available for configuration, I was
wondering if the solution
would be to parameterize the templates so that instead of having in a template like index.vm,
showing an explicit ';' delimiter

#foreach ($index in $table.Indices)
CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);

we could replace the ';' with ($delimiter) ( assuming that $delimiter is made accessible to
the velocity template engine)  ?

This way the loop would be closed - otherwise having a delimiter option that only works on
the way out is limited.

> Sybase DBMS DDL errors
> ----------------------
>                 Key: TORQUE-104
>                 URL: https://issues.apache.org/jira/browse/TORQUE-104
>             Project: Torque
>          Issue Type: Bug
>          Components: Generator
>    Affects Versions: 3.3-RC2
>         Environment: machine on Windows XP - used Sybase 15.0.2 Developer Edition, Maven
2.07 and plugin 3.3-RC2
>            Reporter: Sylvain Benoist
>            Priority: Blocker
>         Attachments: createdb.vm, sybase.zip
> used goals torque:sql ; torque:sqlExec
> When the *-schema.xml file contains descriptions on tables and/or columns, the torque:sql
goal generates a DDL that contains instructions like
> 'COMMENT ON TABLE blahblahblah IS 'some description' or 'COMMENT ON COLUMN blahblah IS...
> Sybase does not support these, so they should be suppressed from the output when Sybase
is the target database.
> Another issue - Sybase does not like ';' in the DDL -- all it wants to see is LF/CR,
and 'go' statements

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

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

View raw message