[
https://issues.apache.org/jira/browse/TORQUE-104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12534792
]
Sylvain Benoist commented on TORQUE-104:
----------------------------------------
I have attached the templates as I have modified them - the sqlExec command
still does not work ( I get a sqlexception for some obscure reason) but at
least the generated sql can be passed on to Sybase via iSQL and it works
outside of the maven2 plugin
'go' is the command delimiter for Sybase, so yes, it acts as a replacement for
';'.
I have seen that there was a delimiter param on the list of params that the
maven 2 plugin takes, so I tried it
but did not succeed. I also looked at the template override feature which is
advertised in the maven1 plugin but the maven2 plugin apparently does not -
Tried using templatePath with no luck.
if there is any ';' in the SQL, Sybase complains and says <<Incorrect syntax
near ';'>>
You can download Sybase 15.0.2 on your machine, install and use it - the
developer edition is absolutely free for dev and test purposes. There are
downloads for Windows, Linux and many others.
> 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
>
> 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]
