Thank you for your help. Are you transforming with XSL or STX? I've tried restrictions with where, limited the results with max-rows, but have had mixed results. Sometimes it works sometimes it doesn't. The problem is that the DOM is becoming so large that too much of the server resources are consumed. I think I could solve problems with STX, but I'm still trying to figure out how to use STX with ESQL.
Gary T. Schultz Web Technical Administrator / GIS Coordinator Wisconsin Department of Commerce 6th Floor P.O. Box 7970 Madison, WI 1-608-266-1283 -----Original Message----- From: Markus Vaterlaus [mailto:[EMAIL PROTECTED] Sent: Friday, October 22, 2004 3:25 AM To: [EMAIL PROTECTED] Subject: Re: Cocoon-Oracle questions Hi there, I'm using ESQL to connect to an Oracle 8i DB. Some tables I'm using have far more than 10000 records in it. Allthough, I don't need all the records; restrictions with WHERE come in very handy. :-) To check your issue I built a logicsheet with the following query <esql:query> select * from tablename order by key </esql:query> The table tablename has about 30000 records. It takes some time to get the result back, transform it and display it in IE or Moz. But it works! My setup: cocoon 2.1.4 on tomcat 4.1.21 on a 2 cpu-linux box with 4 GB RAM. Oracle is running on the same server. BTW: If you use the restriction <esql:max-rows>100000</esql:max-rows> the row-results contains an additional element called <ROWNUM/>. Cheers --mv On Wed, 20 Oct 2004 09:35:48 -0500, Schultz, Gary - COMM <[EMAIL PROTECTED]> wrote: > I need to gain access to an Oracle database with over 11000 records. > > Is there a limit to the number of rows that can be retrieved using ESQL in > an XSP page? My XSP tops out at 2000 records. Can this be increased? Where > should I look for information on this. > > Does Cocoon support rownum >? I have not been able to get it to work. I did > not find anything in the Cocoon Wiki related to rownum. If rownum > is not > supported, what is an easy way to retrieve sets of records from a query. > > Any information that points me in the right direction is greatly > appreciated. > > Gary T. Schultz > Web Technical Administrator / GIS Coordinator > Wisconsin Department of Commerce > 6th Floor > P.O. Box 7970 > Madison, WI > 1-608-266-1283 > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]