Important Notice - Forums is archived
To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.
SQLContainer and concurrent users
Hi there,
I've got a problem with the SQLContainer add-on when running the application with concurrent users. When an user applies a filter on SQLContainer, data change for other users too. Any idea about how to solve this?
I hope you can help me. Thank you very much in advance
Do you have enableCacheFlushNotifications() turned on? I think the job of that is to 'Refresh' other SQLContainers of other users when ever there is a change.
Need to disable that if you don't want automatic 'Refreshes' for other users.
https://vaadin.com/book/-/page/sqlcontainer.caching.html
Hopefully that's it.
Dana
Hi,
thank you for your answer. I never called enableCacheFlushNotifications() so I don't think it's enabled. Is it enabled by default? If yes, how could I disable it?
Here is the code I used for declaring containers:
FreeformQuery ordiniArrivoQuery = new FreeformQuery("SELECT DISTINCT code,company FROM orders",connectionPool);
ordiniArrivoQuery.setDelegate(new MyFreeformQueryDelegate());
ordiniInArrivoContainer = new SQLContainer(ordiniArrivoQuery);
TableQuery qOrdini = new TableQuery("ordini", connectionPool);
qOrdini.setVersionColumn("VERSION");
ordiniContainer = new SQLContainer(qOrdini);
TableQuery qOrdiniDett = new TableQuery("ordini_dett", connectionPool);
qOrdiniDett.setVersionColumn("VERSION");
ordiniDettContainer = new SQLContainer(qOrdiniDett);