Intellij Idea JPA console cannot run due '[3D000] No database selected'

Question

I have a project with JPA module that correctly recognizes all entities.

Datasource is correctly set and it work well with autocomplete. I have not persistence.xml because I am using annotations.

I'm working a lot with @Query (native=false) on the repositories (extends CrudRepository) so using the JPA console it a really fast way to test queries. But when I try to run queries there I am getting:

[3D000] No database selected

I cannot use the USE reserved word there. So I am wondering what may be missing on my configuration.

Answer 1

I also struggled with this and found the solution.

When creating a datasource in IDEA, you can choose to which database you want to connect within that source. When left empty, no database is selected and you'll get the "[3D000] No database selected" error in the JPQL-console.

Instead, create a datasource with default database:

Now, assign this datasource in the Persistence tool window (e.g. View | Tool Windows | Persistence) to your persistence unit:

And:

Now, you should be ready to go!