Test JPQL queries

[arapoport (Alejandro Rapoport)]

I’m not familiar enough with JPQL queries and syntax. Is there any way/tool to test JPQL queries against the datamodel ?

[ronaldsr (Ronald Raatz)]

you can try it within cuba studio, for example, when setting a query to a datasource

[krivopustov (Konstantin Krivopustov)]

You can also test JPQL queries in the running CUBA application. Open Administration > JMX Console, find the app-core.cuba:type=PersistenceManager MBean and open it. Find jpqlLoadList() operation and enter as a parameter:

select u from sec$User u

Then click Invoke.

[arapoport (Alejandro Rapoport)]

Thanks to both of you !