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 Mon, 15 Oct 2007 10:19:50 GMT

    [ 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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message