db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fischer (JIRA)" <j...@apache.org>
Subject [jira] Commented: (TORQUE-104) Sybase DBMS DDL errors
Date Mon, 15 Oct 2007 11:43:51 GMT

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

Thomas Fischer commented on TORQUE-104:
---------------------------------------

When I have time and energy, I may install Sybase. However, this may take some time.

Sylvain, did you test the templates I checked in on Sunday at all ? They should work via SqlExec
(SqlExec removes the delimiter ";" before executing the sql command).

I'd guess the problem with SqlExec and your templates is that SqlExec does not know when a
statement ends (it expects a ";" if you use default settings). The original ant task has the
setting DelimiterType and Delimiret, which need to be set to line-based and "go" for SqlExec,
but I do not know whether these settings can also be set via thwe maven 2 plugins. I will
check.

> 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


Mime
View raw message