You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by un papier <un...@attbi.com> on 2003/02/21 15:34:19 UTC

sql2xml does not handle big schema

Folks
 I am using Torque3.0. I can use the ant task sql2xml successfully for
small schema (4-8) columns. I had one big table and the task seems
to hang forever. I attached the schema below. Any help appreciated

CREATE TABLE generic_list (
  id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default 0,
  list_descriptor int(11) NOT NULL default 0,
  label varchar(64) NOT NULL default ,
  created_on datetime NOT NULL default 0000-00-00 00:00:00,
  due_on datetime default NULL,
  priority smallint(6) default NULL,
  category int(11) NOT NULL default 0,
  custom1 varchar(64) default NULL,
  custom2 varchar(64) default NULL,
  custom3 varchar(64) default NULL,
  custom4 varchar(64) default NULL,
  note varchar(128),
  custom5 varchar(64) default NULL,
  custom6 varchar(64) default NULL,
  custom7 varchar(64) default NULL,
  custom8 varchar(64) default NULL,
  custom9 varchar(64) default NULL,
  custom10 varchar(64) default NULL,
  custom11 varchar(32) default NULL,
  custom12 varchar(32) default NULL,
  foreign_index1 int(11) default NULL,
  foreign_index2 int(11) default NULL,
  foreign_index3 int(11) default NULL,
  foreign_index4 int(11) default NULL,
  checked char(1) default n,
  PRIMARY KEY  (id)
) ;