Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get more than 500 rows per page with ORDS 3.0 Feed

Charly_ZMay 25 2016 — edited Jun 15 2016

Hi all!

We have ORDS 3.0.3 up and running but can't get a feed to give more than 500 records per page from a query.

I've set

jdbc.maxRows

to 10000 in the config file

and have set the "Pagination Size" on the GET-resource to 600

The source-type is feed and the sql query gives a lot more records.

But when i call the request I get exactly 500 records:

On the first-link of the response I see an ?limit Parameter, which I didn't put in the request:

Request:

http://localhost:8080/ords/xxx/v1/yyy/

Response:

...<500 items>...

"first": {"$ref": "http://localhost:8080/ords/xxx/v1/yyy/?limit=500"},

"next": {"$ref": "http://localhost:8080/ords/xxx/v1/yyy/?page=1"

...

What am I missing?

How can I get more than 500 records per page?

BTW I can iterate trough the pages.

Charly

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2016
Added on May 25 2016
3 comments
2,036 views