Thanks Heiko, I was suspicious about that already...
> -----Urspr�ngliche Nachricht----- > Von: Heiko Stehli [mailto:[EMAIL PROTECTED]] > 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:[EMAIL PROTECTED]] > 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:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
