torque-created sql not accepted

[Marc Lustig]

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