cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Schultz, Gary - COMM" <GSchu...@commerce.state.wi.us>
Subject RE: Cocoon-Oracle questions
Date Fri, 22 Oct 2004 15:44:20 GMT
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:mvaterlaus@gmail.com]
Sent: Friday, October 22, 2004 3:25 AM
To: users@cocoon.apache.org
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
<gschultz@commerce.state.wi.us> 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: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message