CODEWITHSUNDEEP
vaadinvaadin14
user18818459
user18818459

Reputation: 11

Vaadin Grid - Attempted to fetch more items from server than allowed in one go

~1500 data need to be fetched from DB. The code is pretty simple

List<Item> itemList = getItemsFromDB();
Grid<Item> grid = new Grid<>();
grid.addColumn(Item::getID).setHeader("Id").setAutoWidth(true);
grid.addColumn(Item::getName).setHeader("Name").setAutoWidth(true);       
grid.setAllRowsVisible(true);
grid.setItems(itemList);

And I got this warning, only the first 1000 data are shown in the grid, the rest are just empty rows.

2022-04-15 15:46:52.475  WARN 19642 --- [nio-8080-exec-6] c.v.flow.data.provider.DataCommunicator  : Attempted to fetch more items from server than allowed in one go: number of items requested '1583', maximum items allowed '1000'.

I know I can use lazy loading, but can I do it without it? The size of data will always be around 1500, and I don't actually care that much about how slow it is.

I am using vaadin 14.8.8

Upvotes: 1

Views: 591

Answers (1)

Knoobie
Knoobie

Reputation: 2064

The problem comes from setAllRowsVisible and the DoS protection added inside the data provider. It's currently not easily possible to overwrite this without creating your own data provider.

I'm not really sure why you need all the rows visible; this increases the load time for your end user. If your only reason is to have the grid full height, you can just call setHeight on the grid and the let Vaadin handle the callbacks to the server to only fetch the amount of data needed to show on the client.

Upvotes: 2

Related Questions