Hibernate 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 session factory - Open Query Console - Hibernate Console

Persistence tool window - context menu of a session factory - Open Query Console - <name of a running console>

Use this tool window to run HQL queries on the data sources configured in your workspace and to generate DDL or SQL scripts based on HQL commands.

You can run the console for several session factories simultaneously. Each of them is displayed in a separate tab. The tab header shows the name of the session factory 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 Hibernate 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