db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Heiko Stehli" <heiko.ste...@hm-informatik.de>
Subject AW: torque-created sql not accepted
Date Thu, 12 Dec 2002 17:28:29 GMT
Hello,

the problem is the column name "DESC". This is a SQL key word and can't be
used as column name.

Regards

Heiko



-----Urspr√ľngliche Nachricht-----
Von: Marc Lustig [mailto:mail@marclustig.com]
Gesendet: Donnerstag, 12. Dezember 2002 17:59
An: torque-user
Betreff: torque-created sql not accepted


Hi,
I have this xml:

	<table name="ARTIKELBESCHREIBUNG">
		<column name="ARTIKELBESCHREIBUNG_ID" primaryKey="true" required="true"
type="INTEGER"/>
		<column name="DESC" required="true" type="VARCHAR" size="255"/>
	</table>

and get that error when executing torque:insert-sql

    [torque-sql-exec] [ERROR] Failed to execute: CREATE TABLE
ARTIKELBESCHREIBUNG ( ARTIKELBESCHREIB
UNG_ID INTEGER NOT NULL, DESC VARCHAR (255) NOT NULL, PRIMARY
KEY(ARTIKELBESCHREIBUNG_ID) )
    [torque-sql-exec] [ERROR] java.sql.SQLException: Syntax error or access
violation: You have an e
rror in your SQL syntax near 'DESC VARCHAR (255) NOT NULL, PRIMARY
KEY(ARTIKELBESCHREIBUNG_ID) )' at
 line 1



What's wrong here? Any idea?

Greetings,
Marc


--
To unsubscribe, e-mail:
<mailto:turbine-torque-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:turbine-torque-user-help@jakarta.apache.org>


Mime
View raw message