JPA Console Tool Window

IntelliJ IDEA 12.1.0 Web Help

Some features described here are available in Ultimate edition only.

Persistence tool window - context menu of a persistence unit - Open Query Console - JPA Console

Persistence tool window - context menu of a persistence unit - Open Query Console - <the name of a running console>

Use this tool window to run HQL queries on the data sources configured in your workspace.

You can run the console for several persistence units simultaneously. Each of them is displayed in a separate tab. The tab header shows the name of the persistence unit from which the console is launched.

The console consists of three panes:

The Input pane for entering HQL queries.
The Result pane shows results of executing queries.
The Output pane shows information messages and query execution details.

Common toolbar options

Item	Tooltip and Shortcut	Description
	Execute Query Ctrl+EnterCtrl+Enter	Click this button to execute the query at caret.
	Properties Ctrl+Alt+EnterCtrl+Alt+Enter	Click this button to open the JPA Console Properties dialog box where you can configure the console properties and specify the layout to export query execution results.
	Layout	Click this button to choose the desired layout of the toolbars from the pop-up menu. The available options are: Horizontal Toolbars Restore Layout
	Close Ctrl+Shift+F4Ctrl+Shift+F4	Click this button to terminate the query execution in the current tab of the tool window and close the tab.
	Stop Console.Hibernate.TerminateConsole.Hibernate.Terminate	Click this button to terminate the query execution in the current tab without closing the tab itself.

Output pane

This pane displays information on SQL command execution. Use the items on the context menu to handle the contents of the pane.

Item	Description
Clear All	Choose this option to have all the messages removed from the pane.
Copy Content	Choose this option to have IntelliJ IDEA copy all the displayed messages to the clipboard.
Copy Selected Content	Choose this option to have IntelliJ IDEA copy the selected messages to the clipboard.
Fold lines like this	Choose this option to open the Console Folding dialog box and add the current line to the list of patterns that determine lines to be folded in console output.
Compare with Clipboard	Choose this option to open the Differences Viewer an compare the contents of the clipboard with the entire contents of the Output pane or with a specific selected message.

See Also

Procedures:

Web Resources:

Knowledge Base