might be an aggregate, collation, event, fdw, ftable, mview, operator, package, role, routine, sequence, synonym, table, user, view, vtable. Use the following pattern when you compose an expression for the Object filter field. On the Schemas tab, type filtering options in the Object filter field. 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 or press Ctrl+F5. On the Options tab, select the Auto sync checkbox. If someone changed the remote database data or view, the local view of the database might differ from the actual state of the database. On the Options tab, in the Startup script field, specify the query that you plan to run on a connection to a database. Run a predefined query as you establish a connection On the Options tab, select the Auto-disconnect after N seconds checkbox, where N is a number of seconds after which IntelliJ IDEA terminates the connection. You can specify a period in seconds after which IntelliJ IDEA terminates the connection. Disconnect from a database in a specified period In the Keep-alive query field, specify the query that you want to use as a keep-alive query. To set a custom keep-alive query for a driver, select the necessary driver on the Drivers tab. 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. 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. On the Data Sources tab, select a data source that you want to modify.Ĭlick the Options tab, scroll down to the Other section.įrom the Icon list, select an icon that you want to assign to the driver.Ĭonnection options Keep the connection alive In the Class field, specify the value that you want to use for the driver. In the file browser, navigate to the JAR file of the JDBC driver, select it, and click OK. In the Driver files pane, click the Add icon ( ) and select Custom JARs…. To revert changes, click the Roll back Changes icon ( ) that is in the lower-right part of the window. In the Data Sources and Drivers dialog, click the Drivers tab, and select a data source where you want to change a driver.Ĭlick the provided driver entry, and click Remove ( ). You can add libraries to the existing driver or replace the driver completely. In the Driver files pane, click the version number, and select the driver version that you need.Ĭonfigure a JDBC driver from the existing connection In these cases, select Go to driver from the list. Some data sources have a list with drivers for different versions (for example, MySQL). In the Data Sources and Drivers dialog, click the Drivers tab, and select a driver entry that you want to modify.Ĭlick the Driver link in data source settings. In the Database tool window ( View | Tool Windows | Database), click the Data Source Properties icon. You do not need to provide the password next time you open IntelliJ IDEA. You can terminate the connection by pressing the Deactivate icon ( ) or Ctrl+F2.įorever: password is saved in the IntelliJ IDEA storage. If you exit IntelliJ IDEA and open it again, you must provide the password again.įor session: password is saved only for the current connection session with a database (until you disconnect from it). Until restart: password is saved only for the current IntelliJ IDEA run. Never: password is prompted each time you establish a connection with a database. You can select the following options for storing your password: Alternatively, select a data source and press Ctrl+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 database connection, 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 Ctrl+Alt+S to open the IDE settings and 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. Configure database connections Enable the Database tools and SQL plugin
0 Comments
Leave a Reply. |