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]
