Are you having problem constructing your JPQL (JPA Query Language) query? Tired of testing your query by running your whole application on the server and only to find out that your query syntax is incorrect? If that’s your case, JQT (JPA Query Tool) might be the answer for you. It allows you to browse through your entities in the database. You just pass your JPQL query, and it retrieves the entities for you. It also accepts native query if JPQL is not your cup of tea. It is easier and time saving to construct a query this way. You should only pass over the query to your application code once you ascertain that the query is valid.
The tool is available at this link.