db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marc Lustig" <m...@marclustig.com>
Subject AW: torque-created sql not accepted
Date Thu, 12 Dec 2002 17:53:05 GMT
Thanks Heiko, I was suspicious about that already...



> -----Urspr√ľngliche Nachricht-----
> Von: Heiko Stehli [mailto:heiko.stehli@hm-informatik.de]
> Gesendet: Donnerstag, 12. Dezember 2002 18:28
> An: Turbine Torque Users List
> Betreff: AW: torque-created sql not accepted
>
>
> 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>
>
>
> --
> 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