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]>
