db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Campbell, Justin" <jcampb...@profilesys.com>
Subject RE: sql2xml does not handle big schema
Date Fri, 21 Feb 2003 14:50:11 GMT
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:unpapier@attbi.com]
Sent: Friday, February 21, 2003 9:34 AM
To: Torque Users List
Subject: sql2xml does not handle big schema

 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,
) ;

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message