Return-Path: Delivered-To: apmail-cocoon-users-archive@www.apache.org Received: (qmail 7908 invoked from network); 15 Mar 2005 09:37:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 15 Mar 2005 09:37:49 -0000 Received: (qmail 53497 invoked by uid 500); 15 Mar 2005 09:37:42 -0000 Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org Received: (qmail 53454 invoked by uid 500); 15 Mar 2005 09:37:42 -0000 Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: users@cocoon.apache.org Delivered-To: mailing list users@cocoon.apache.org Received: (qmail 53440 invoked by uid 99); 15 Mar 2005 09:37:42 -0000 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_WHOIS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from ns-3.csir.co.za (HELO wabe.csir.co.za) (146.64.10.166) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 15 Mar 2005 01:37:41 -0800 Received: from cs-emo.csir.co.za (cs-emo.csir.co.za [146.64.10.40]) by wabe.csir.co.za (8.12.11/8.12.11) with ESMTP id j2F9aemN024858 for ; Tue, 15 Mar 2005 11:36:40 +0200 Received: from GW-EMO-MTA by cs-emo.csir.co.za with Novell_GroupWise; Tue, 15 Mar 2005 11:36:39 +0200 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.3 Date: Tue, 15 Mar 2005 11:36:15 +0200 From: "Derek Hohls" To: Subject: Returning large datasets via SQL Transformer? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-CSIR-MailScanner-Information: Please contact sys-admin at csir dot co dot za for more information X-CSIR-MailScanner: Found to be clean X-MailScanner-From: dhohls@csir.co.za X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Using Cocoon 2.1.6 on Linux... I am having a problem attempting to return a large set of data, via the SQL transformer, from a MySQL database, through Cocoon. A query such as : SELECT * FROM mytable LIMIT 100 works fine, but if I remove the limit and attempt to retrieve the entire table - some 25000 rows of 30 floating point data fields - I just get an empty file. Is there a limit built-into either the SQL transformer or Cocoon that needs to be changed to allow a larger volume of data to be downloaded Thanks Derek PS Yes, I do have to have the entire record set... --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org For additional commands, e-mail: users-help@cocoon.apache.org