DataSpell 2023.1 Help

Services tool window

The Services tool window includes various services that help you during software development: run/debug configurations, application servers, database sessions, Docker connections, and so on. Plugin developers can add other services through the IntelliJ platform API.

Main toolbar

The main toolbar contains the following buttons and menus that are common for all service types:

The Expand All button Expand All NumPad-NumPad-+

Expand all items in the list.

The Collapse All button Collapse All NumPad-NumPad--

Collapse all items in the list.

The Group By menu Group By

Choose how you want to organize the list of services.

The Filter menu Filter

Choose how you want to filter the list of services.

The Open in New Tab button Open in New Tab

Move the selected items to a separate tab.

The Add Service menu Add Service Alt+Insert

Choose a service type to add.

Run/debug configurations

Run/debug configurations are not listed in the Services tool window by default. You need to explicitly specify the types of configurations you want to be available and create the corresponding configurations.

Add Run/Debug configurations to the Services window

  1. Select View | Tool Windows | Services from the main menu or press Alt+8.

  2. In the Services tool window, click Add service, then select Run Configuration Type.

    Services tool window: Add run configuration
  3. Select a run/debug configuration type from the list to add all configurations of this type to the window.

    Note that the tool window will only display the configuration types for which you have created one or more configurations.

Buttons on the toolbar depend on the selected type of the run/debug configuration.

Icon

Action

Description

The Run button

Run Control+Shift+F10

Run the selected configuration.

The Debug button

Debug Control Shift D

Debug the selected configuration.

The Stop button

Stop Control+F2

Stop the selected configuration.

Application servers

All types of application server run/debug configurations are available in the Services tool window by default. Create an application server configuration and it will be available in the list of services.

Icon

Action

Description

The Run button

Run Control+Shift+F10

Run the selected application server configuration.

The Rerun button

Rerun Control+Shift+F10

Restart the selected application server configuration.

The Debug button

Debug Control Shift D

Debug the selected application server configuration.

The Stop button

Stop Control+F2

Stop the selected application server configuration.

The Deploy All button

Deploy All

Deploy all artifacts of the selected application server configuration.

The Artifacts button

Artifacts

Configure which artifacts to deploy for the selected application server configuration.

The Update Running Application button

Update Running Application Control+F10

Update a running application after modifying the source code.

Database service

In the database service, you can manage your sessions and connections. Connection is a physical communication channel and session is a state of information exchange. For example, if you surf a social network, your connection log might have thousands of connection entries between a client and a server while a session log might show you only a single log entry with the number of bytes transferred.

For more information about managing database sessions, see Manage connection sessions.

Left toolbar

Item

Tooltip and shortcut

Description

Tx

Transaction Mode

and

Transaction Isolation

Select the isolation level for database transactions and the way the transactions are committed.

  • Auto: the current transaction is committed automatically when you submit your local changes to the database server.

  • Manual: the changes submitted to the database server are accumulated in a transaction that can either be committed or rolled back explicitly by means of the Commit (Commit button) or Rollback (Rollback button) buttons on the toolbar.

For more information about database transaction modes and isolation, refer to Submit changes to a database.

Commit

Commit Control+Alt+Shift+Enter

Commit the current transaction. See also, transaction modes and isolation.

Rollback button

Roll Back

Roll back changes. This button is available only for the manual transaction mode. See also, transaction modes and isolation.

The Cancel Running Statements button

Cancel Running Statements Control+F2

Terminate the execution of the current statement.

The Restore Default Layout button

Restore Default Layout Control+F2

Restore default positions of visual elements in the Service view.

The Jump to Console button

Jump to Console Control+Shift+F10

Open the Consoles popup. In the Consoles popup, you can select a query console that you want to open in the editor.

The Disconnect button

Disconnect Control+F2

(For data sources) Close a connection to the selected data source.

The Disconnect button

Cancel Running Statements Control+F2

(For sessions and attached files) Close a connection to the selected data source.

Data sources

Icon

Action

Description

The Jump to Console button

Jump to Console Control+Shift+F10

Open the Consoles popup. In the Consoles popup, you can select a query console that you want to open in the editor.

The Deactivate button

Deactivate Control+F2

Close a connection to the selected data source.

Close All Sessions

Close all opened sessions to a data source.

The Show in New Tab button

Show in New Tab

Move the selected items to a separate tab.

Open Each in New Tab

Split the selected items into separate tabs.

Open Each Tab in New Tab

Create separate tabs for each type of service.

Delete Delete

Close all opened sessions to a data source. Identical to Close All Sessions.

Sessions

Icon

Action

Description

Tx

Tx Mode and Tx Isolation

Choose the isolation level for database transactions and the way transactions are committed.

  • Auto: each statement is executed in its own transaction that is implicitly committed.

  • Manual: transactions are committed and rolled back manually.

The Commit button

Commit Control+Alt+Shift+Enter

Commit the current transaction.

The Rollback button

Rollback

Roll back the last transaction.

The Disconnect button

Cancel Running Statements Control+F2

Stop execution of running statements.

The Restore Default Layout button

Restore Default Layout Control+F2

Restore visual elements of are arranged.

Rename Session

Display the Rename dialog where you can specify a name for a session.

Close Session

Close the selected session.

The Show in New Tab button

Show in New Tab

Move the selected items to a separate tab.

Open Each in New Tab

Split the selected items into separate tabs.

Open Each Tab in New Tab

Create separate tabs for each type of service.

Delete Delete

Close all opened sessions to a data source. Identical to Close All Sessions.

SQL files

Icon

Action

Description

Tx

Tx Mode and Tx Isolation

Choose the isolation level for database transactions and the way transactions are committed.

  • Auto: each statement is executed in its own transaction that is implicitly committed.

  • Manual: transactions are committed and rolled back manually.

The Commit button

Commit Control+Alt+Shift+Enter

Commit the current transaction.

The Rollback button

Rollback

Roll back the last transaction.

The Disconnect button

Cancel Running Statements Control+F2

Stop execution of running statements.

The Restore Default Layout button

Restore Default Layout Control+F2

Restore visual elements of are arranged.

Switch Session

Display the Sessions popup where you can select or create a new session and connect to it.

Detach Session

Detach the selected file from the current session. To attach the file to a session, open the file in the editor, and select the session in the sessions list.

Detach a session

The Show in New Tab button

Show in New Tab

Move the selected items to a separate tab.

Open Each in New Tab

Split the selected items into separate tabs.

Open Each Tab in New Tab

Create separate tabs for each type of service.

Delete Delete

Close all opened sessions to a data source. Identical to Close All Sessions.

the Jump to Source button

Jump to Source F4

Open the file in the editor.

Productivity tips

Use tabs

The Services tool window can include a lot of services, which you can group according to their type or create separate tabs for your own custom grouping. For example, you can create a tab that will include the following: the run configuration for the application that you are developing, the Docker container that runs the database used as a backend for your application, and a console for accessing the database.

Hide the services tree

Click The Show Options Menu button in the right part of the Services tool window toolbar and then click Show Services Tree to remove the checkbox. You can also press Control+Shift+T to toggle the services tree.

If you hide the services tree, it is replaced by a services navigation bar. Press Alt+Home to focus the services navigation bar.

Hide, remove, and delete services

Right-click any service and select Delete Delete to completely remove the corresponding run configuration, cloud provider, Docker connection, and so on.

If you don't want to show run/debug configurations of a certain type in the Services tool window, right-click the corresponding configuration and select Remove Configuration Type from Services. This will not remove the actual configuration.

To hide a specific run configuration from the Services tool window, right-click the corresponding configuration and select Hide Configuration. To see all hidden run configurations, click the Add Service menu and select Restore Hidden Configurations.

Last modified: 21 June 2023