Hello,
I've found probably unknown bug in the generation of sql statements from
xml description.
Following schema
<database>
<table name="ABC">
<column name="ID" primaryKey="true" required="true"
type="INTEGER"/>
<column name="CMD" type="BLOB"/>
<column name="SIG" size="1024" type="BINARY"/>
</table>
</database>
is translated by Torque into:
drop table ABC cascade ;
CREATE TABLE ABC
(
ID INTEGER NOT NULL,
CMD LONG BYTE,
SIG CHAR(254) BYTE (1024)
);
ALTER TABLE ABC
ADD PRIMARY KEY (ID) ;
which has obviously two length identifiers for column SIG.
With best regards,
Julius Siska