If there is an issue, it's with the sql-reading portion of this task. The jdbc2xml task works flawlessly with our rather complex schema involving almost 100 tables, some with columns just under 90. If you already have this table in a database, or are able to create it -- you might want to try the jdbc connection approach.
Best of luck. Justin Campbell Project Technical Lead Profile Systems, Inc. -----Original Message----- From: un papier [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 9:34 AM To: Torque Users List Subject: 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) ) ; --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
