![]() ![]() But in some cases (for example, with certain settings of PgBouncer), you can or are allowed to work only with a certain database. When you connect to a data source, WebStorm can retrieve and display you all the databases that the data source has. If the Single session mode checkbox is cleared, each new query console creates a new connection. On the Options tab, select Single session mode. To close opened connections for all modified data sources, click Yes for All. To close opened connections for the selected data source, click Yes. WebStorm displays a notification if you have opened connections. When you apply single session mode, you must close all existing opened connections. For more information about query consoles, refer to Query consoles. This mode allows you to see the temporary objects in the database tree, or use the same transaction in different query consoles. Single session mode means that the data source and all consoles use one and the same connection. On the Options tab, select the Read-only checkbox. *:*: all schemas in all all schemas from the current only the current the dbo schema from all databases, the current schema, schemas s1,s2,s3 from the db1 database.Ĭonnection modes Enable read-only mode for a connection On the Schemas tab, type filtering options in the Schema pattern: the current database or schema. For more information about regular expressions, refer to Class Patterns at JavaTM 2 Platform Standard Edition 5.0 API Specification.Īlso, you can check the following video at that describes how to hide objects that you do not need by using the object filter. To exclude an item, prepend with - (minus). 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 ( ) in the toolbar or press Control+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. Set a predefined query to run as you establish a connection On the Options tab, select the Auto-disconnect after checkbox and type a number of seconds after which WebStorm terminates the connection. You can specify a period in seconds after which WebStorm 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 WebStorm 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, WebStorm connects to a database automatically to receive database objects. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |