db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marc Lustig" <m...@marclustig.com>
Subject torque-created sql not accepted
Date Thu, 12 Dec 2002 16:58:47 GMT
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


Mime
View raw message