[#TORQUE-104] Sybase DBMS DDL errors

Torque

Sybase DBMS DDL errors

Created: 10/Oct/07 01:23 PM Updated: 26/Oct/07 01:58 PM

Return to search

Component/s:

Generator

Affects Version/s:

3.3-RC2

Fix Version/s:

None

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
createdb.vm	2007-10-15 10:22 AM	Sylvain Benoist	0.9 kB
sybase.zip	2007-10-15 10:20 AM	Sylvain Benoist	6 kB

Environment:

machine on Windows XP - used Sybase 15.0.2 Developer Edition, Maven 2.07 and plugin 3.3-RC2

Description

« Hide

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

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

No work has yet been logged on this issue.