Sessions

In GoLand, connections to the database are established in special wrappers – sessions. Each session is a wrapper over a single connection, and it stores the connection's information (for example, whether it is active or not, transaction control mode, and other settings).

Within a session, connections can open and close when required and in accordance with the defined settings.

Sessions can have clients – files, whose queries are sent by using the connection that the session holds. Data editor can also be a client for a session.

note

Before GoLand 2024.1, you had to attach your query consoles to a session manually using the <session> list in the top right corner of the editor.

Starting with GoLand 2024.1, the IDE manages sessions automatically.

You can view data sources, sessions, and session clients in the Services tool window. The green dot in the corner of a session's icon indicates a connected session.

tip

The Services tool window automatically pops up when you run something related to a service (for example, a query or refresh a table state). Alternatively, to open the Services tool window, click View | Tool Windows | Services. For more information about the Services tool window, refer to the Services tool window topic.

In the picture above, the Services tool window displays the following nodes:

1. Data source.

2. Disconnected session.

3. Connected session.

4. Session clients.

For more information about the session managing options and toolbar controls, refer to the Services tool window topic.

If you close GoLand and open it again, all your sessions will be available in the Services tool window, but they will be empty.

Manage sessions

Switch sessions

In case you need to run your queries or SQL file in a different session, you can switch the session to another one.

• To switch the session, in the Services tool window, right-click the file that you want to switch the session for, click Switch Session and select the session that you want to attach the file to.

Work in a single session

You can run queries from multiple SQL files and receive multiple database objects data in a single session. For example, if each new query requires an MFA approval.

To work in a single session, enable the single session mode by doing the following:

1. Open the Data Sources and Drivers dialog (CtrlAltShift0S) and select your data source.

2. On the right pane of the dialog, open the Options tab.

3. In the Connection settings section, select the Single session mode checkbox.

4. Click OK to apply the changes.

5. (Optional) If the Apply Changes dialog appears, select the way you want to proceed.

   

   • No: Leaves the connected sessions intact.

   • Yes: Disconnects all the connected sessions.

6. Run your queries.

All new queries will run in the default session.

The following table includes other basic actions that you can use to work with sessions.

Action	Description
Rename a session	In the Services tool window, right-click a session and select Rename Session.
Move a session or a data source to a separate tab	In the Services tool window, right-click a session or a data source and select Open in New Tab. To revert this action, close the separated tab.
Close a session	In the Services tool window, right-click a session and select Close Session. The session will be detached from its session clients, it will also disappear from the list.
Close all sessions	In the Services tool window, right-click a data source and select Close All Sessions.

Services tool window reference

For more information about tool window controls and tabs, refer to the the Services tool window topic.