[#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:

Repository	Revision	Date	User	Message
ASF	#584519	Sun Oct 14 09:28:40 UTC 2007	tfischer	Remove 'COMMENT ON...' output from generated SQL for Sybase as these commands do not exist in Sybase's sql. Fixes part of TORQUE-104
				Files Changed
				MODIFY /db/torque/site/trunk/xdocs/changes.xml DEL /db/torque/templates/trunk/src/templates/sql/base/sybase/comment.vm MODIFY /db/torque/templates/trunk/src/templates/sql/base/sybase/table.vm