On the Options tab, select the Run keep-alive query each checkbox and type a number of seconds after which IntelliJ IDEA must run a keep-alive query again. On the Data Sources tab, select a data source that you want to modify.
You can define the custom query in the driver settings for unsupported databases. You can keep the connection to a database alive by running a keep-alive query after the specified period. In the Time zone field, start typing the time zone that you want to use. Select a data source that you want to modify and click the Options tab. In the Database tool window ( View | Tool Windows | Database), click the Data Source Properties icon. You can open data source properties by using one of the following options: Connection options Set a time zone for a connection Alternatively, select a data source and press Control+F2.
If you want to close a database connection, select a data source and click the Deactivate button ( ) on the toolbar. Names of data sources that interact with a database are shown in the Database tool window with a little green circle. When you create a data source, IntelliJ IDEA connects to a database automatically to receive database objects. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name. Press Control+Alt+S to open the IDE settings and then select Plugins. The Database Tools and SQL plugin is available only in IntelliJ IDEA Ultimate. If the relevant features aren't available, make sure that you didn't disable the plugin. This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in IntelliJ IDEA by default.
0 kommentar(er)
