java - How to test HQL queries?

Question

I'm searching for a fast (really fast) way to test changes to hibernate queries. I have a huge application with thousands of different HQL queries (in XML files) and 100+ mapped classes and i dont want to redeploy the whole application to just test one tiny change to a query.

How would a good setup look like to free me from redeployment and enable a fast query check?

question from:https://stackoverflow.com/questions/1043554/how-to-test-hql-queries

Answer 1

With Intellij IDEA 8.1.3 the mechnism of choice is called 'Facet'. To instantly test HQL queries:

1. create a data source Tools -> Data Source, Add Data Source, define driver, username and password of yor development db
2. in case you dont have already a hibernate.cfg or you configure your session factory in a different way than via xml: create a hibernate.cfg file referencing all XML mapping's (define a name for the session factory, just for easier handling)
3. in 'Project Structure' add Facet to your module of choice and assign the recently defined data source to the new facet
4. switch to Java EE View
5. Open Hibernate Facets - Node
6. Right click Session factory and choose "Open HQL Console"
7. enter HQL query in console ...and your're done.

sorry for this RTFM question.