[Vaadin 8] Choose the right DataProvider for data on MySql with the possibi

Vaadin 6 / 7 / 8 Framework Data Binding
1

Hi,
I need to represent data fom a backend db (MySql or MariaDB) in my grid.
I’m not interessed in Lazy Loading: data is quantity is very low, all data can be loaded in memory.
I use Hibernate and and as seen in the Vaadin 8 example I use the DataProvider object that extends AbstractDataProvider.
Everything works except the sorting.
The question is: which type of DataProvider should I utilize, and is there any clear example?
I know I cannot use the grid sorting mechanism when the data source is a dataprovider, but it is not clear how to sort data in the dataprovider itself. Moreover, I don’t want to add the
order by
 clause in the sql

I’ve seen AbstractBackEndDataProvider, Is it the right one?
I’m quite confused at the moment.

2

Hi,

If you don’t want lazy load then you can fetch all your data inside a List then use ListProvider (or setItems of Grid).
Sort should work with Listprovider.