How do I configure the IntelliJ HQL Console to work with Spring Boot

Question

I'm using Spring Boot and IntelliJ. Because Spring Boot auto-configures the database, there is no hibernate.cfg.xml file. Typically, when you want to execute HQL queries on the console, you connect via this configuration file.

https://www.jetbrains.com/idea/help/working-with-the-hibernate-console.html#d951572e120

Unfortunately, I don't have that file as an entry point. How else can I execute HQL queries?

Answer 1

You should have your entityManagerFactory registered and then in persistence tab right-click on entityManagerFactory an choose Console. (I'm using Intellij EAP 2018.1)