Test JPQL queries

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

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

2 Likes

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.

3 Likes

Thanks to both of you !