Some features described here are available in Ultimate edition only.
IntelliJ IDEA provides HQL support and enables creating queries in a JPA
Console dedicated tool window.
The console is started using the run configuration of the type Query Language Console.
You can have several instances of the JPA console running simultaneously. Each console is opened in a
separate tab of the tool window. Each tab shows
the name of the persistence unit from which the console is launched.
On the context menu, choose Open Query console or click .
In the Choose Console pop-up window, do one of the following:
To launch a console, choose choose JPA Console from the
Open New list.
To open an already running JPA console, choose the name of the desired console from the
To execute queries from the JPA console, perform the
following general steps
Type the desired commands in the upper section of the console. Note syntax and error
highlighting, code completion, intention actions, and quick fixes.
To start a new line, press EnterEnterEnterEnterEnterEnterEnterEnterEnterEnterEnterEnter.
Use the basic and advanced
In particular, you can jump to declaration of a table or its column
in the corresponding
Java class, if you place the caret at the table or column name, and press Ctrl+B, Ctrl+Button1 Click or Button2 ClickCtrl+B, Ctrl+Button1 Click or Button2 ClickCtrl+B, Ctrl+Button1 Click or Button2 ClickCtrl+B, Ctrl+Button1 Click or Button2 ClickCtrl+Alt+G, Escape, Period, Alt+Period or Ctrl+Button1 ClickCtrl+B, Ctrl+Button1 Click or Button2 ClickF12, Shift+F2, Ctrl+B, Ctrl+Button1 Click or Button2 ClickCtrl+B, Ctrl+Button1 Click or Button2 ClickF3 or Ctrl+Button1 ClickMeta B, Meta Button1 Click or Button2 ClickMeta B, Meta Button1 Click or Button2 ClickF3 or Control Button1 Click.
Alternatively, keep the Ctrl key pressed, and hover your
over the reference to a table or column. So doing, the reference turns to a hyperlink, which
allows you to jump
to the declaration in the source code:
To run the commands, click the button on the toolbar or
Ctrl+EnterCtrl+EnterCtrl+EnterCtrl+EnterCtrl+EnterCtrl+EnterCtrl+EnterCtrl+EnterCtrl+EnterMeta EnterMeta EnterMeta Enter.
View the query execution result in the Result tab.
View and analyze information messages and query execution details in the Output