IntelliJ IDEA 12.1.0 Web Help

Some features described here are available in Ultimate edition only.

The dialog box opens when you click the Properties toolbar button properties.gif in the Database Console tool window.

In this dialog box, specify the SQL dialect to use and define how parameters should be parsed. Here you can also configure displaying query results, and define layout to export query execution results.

The dialog box consists of the following tabs:

General tab

In this tab configure the common behaviour of the Database console.

ItemDescription
SQL Dialect From this drop-down list, select the SQL dialect to use. The selection determines the coding assistance provided. The available options are:
  • Derby
  • H2
  • HSQLDB
  • MySQL
  • Oracle
  • PostgreSQL
  • PostgresPLSQL
  • SQL Server
  • SQL92
  • SQLite
  • Sybase
  • keywords only. The coding assistance will be limited to highlighting the SQL keywords.
  • Plain text. The corresponding content will be treated as plain text.
Connection in auto-commit mode Select this check box to have SQL statements executed and committed as individual transactions.
Result Set Page Size In this text box, type the maximum number of retrieved records to display per page. The zero value stands for unlimited page size.
Show query results in new tab Select this check box to have a separate tab created for each query execution.

Data export tab

In this tab, define how query execution results will be presented if you need to export them.

ItemDescription
String Quotation In this pair of text boxes, type the symbols to enclose exported String data.
Values Separator In this text box, type the symbol to use as separator between exported values.
Include Table Header Select this check box to have the headers of tables exported.
Include Row Number Select this check box to have id numbers of exported records displayed.

Text mode tab

In this tab, configure parsing parameters inside SQL commands.

ItemDescription
Parameter Pattern (Java RegExp) Select this check box to have parameters within commands parsed using a regular expression and specify the desired regular expression in th text box.

See Also

Procedures:

Reference:

Web Resources: