Configure database connections

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. In the Data Sources and Drivers dialog, click the Drivers tab, and select a driver entry that you want to modify.

3. Click the Driver link in data source settings.

   Some data sources have a list with drivers for different versions (for example, MySQL). In these cases, select Go to driver from the list.

4. In the Driver files pane, click the version number, and select the driver version that you need.

You can add libraries to the existing driver or replace the driver completely.

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. Click the Driver link in data source settings and select Go to Driver.

3. Click the provided driver entry, and click Remove ().

   To revert changes, click the Roll back Changes icon () that is in the lower-right part of the window.

4. In the Driver Files pane, click the Add icon () and select Custom JARs….

5. In the file browser, navigate to the JAR file of the JDBC driver, select it, and click OK.

6. In the Class field, specify the value that you want to use for the driver .

7. Click Apply.

You can keep the connection to a database alive by running a keep-alive query after the specified period. You can define the custom query in the driver settings for unsupported databases.

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. On the Data Sources tab, select a data source that you want to modify.

3. On the Options tab, select the Run keep-alive query each checkbox and type a number of seconds after which GoLand must run a keep-alive query again.

You can specify a period in seconds after which GoLand terminates the connection.

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. On the Data Sources tab, select a data source that you want to modify.

3. On the Options tab, select the Auto-disconnect after checkbox and type a number of seconds after which GoLand terminates the connection.

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. On the Data Sources tab, select a data source that you want to modify.

3. On the Options tab, in the Startup script field, specify the query that you plan to run on a connection to a database.

   

If someone changed the remote database data or view, the local view of the database might differ from the actual state of the database.

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. On the Data Sources tab, select a data source that you want to modify.

3. On the Options tab, select the Auto sync checkbox.

   If the Auto sync checkbox is cleared, the view of the data source in the Database tool window is synchronized with the actual state of the database only when you click the Refresh icon () in the toolbar or press CtrlF5.

   

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. On the Data Sources tab, select a data source that you want to modify.

3. On the Schemas tab, type filtering options in the Object filter field.

   Use the following pattern when you compose an expression for the Object filter field.

   <type>:[-]<pattern>, where:

   <type> might be an aggregate, collation, event, fdw, ftable, mview, operator, package, role, routine, sequence, synonym, table, user, view, vtable.

   <pattern> is a regular expression. To exclude an item, prepend with - (minus). For more information about regular expressions, see Class Patterns at JavaTM 2 Platform Standard Edition 5.0 API Specification.

   tip

   Also, you can check the following video at youtube.com that describes how to hide objects that you do not need by using the object filter.

   

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. On the Data Sources tab, select a data source that you want to modify.

3. On the Schemas tab, type filtering options in the Schema pattern field.

   • @: the current database or schema.

   • *: every database or schema. You can list schemas after *:.

   Consider the following examples:

   • *:*: all schemas in all databases.

   • @:*: all schemas from the current database

   • @:@: only the current schema

   • *:dbo|@:@|db1:s1,s2,s3: the dbo schema from all databases, the current schema, schemas s1,s2,s3 from the db1 database.

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. On the Data Sources tab, select a data source that you want to modify.

3. On the Options tab, select the Read-only checkbox.

   

Single session mode means that the data source and all consoles use one and the same connection. This mode allows you to see the temporary objects in the database tree, or use the same transaction in different query consoles. For more information about query consoles, read Query consoles.

When you apply single session mode, you must close all existing opened connections. GoLand displays a notification if you have opened connections. To close opened connections for the selected data source, click Yes. To close opened connections for all modified data sources, click Yes for All.

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. On the Data Sources tab, select a data source that you want to modify.

3. On the Options tab, select Single session mode.

4. Click Apply.

   

When you connect to a data source, GoLand can retrieve and display you all the databases that the data source has. But in some cases (for example, with certain settings of PgBouncer), you can or are allowed to work only with a certain database. With the Single database mode enabled, you see in the database tree view only the database that you specified in the connection settings, not all the databases that were received from the data source.

Consider using this setting, for PostgreSQL, Azure SQL Database, Greenplum, Amazon Redshift.

1. Open data source properties. You can open data source properties by using one of the following options:

   • In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

   • Press CtrlAltShift0S.

2. On the Data Sources tab, select a data source that you want to modify.

3. On the Options tab, select Single database mode.

4. Click Apply.