[
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
