IntelliJ IDEA 2016.3 Help

Data Views

File | Settings | Tools | Database | Data Views for Windows and Linux
IntelliJ IDEA | Preferences | Tools | Database | Data Views for OS X


The settings on this page define how table data are shown and modified in the database, Hibernate and JPA consoles, and the table editor.

Item Description
Result set page size The number of table rows to be shown at a time, on one "page". Here is an example when this number is set to 2:
/help/img/idea/2016.3/PageSize2.png

If you don't want to limit the number of rows displayed simultaneously, specify zero (0).

Result set prefetch size Data from databases are retrieved in chunks. The number in this field defines the number of rows in such chunks.

A bigger number means fewer IDE - DB round trips but more memory for storing a chunk.

Filter history size The number of most recently used filtering conditions to memorize for a table in the table editor. Here is an example when this number is set to 2. (The filter history box contains two most recently used conditions.)
/help/img/idea/2016.3/DBFilterHistorySize2.png
LOB length limit The maximum size of a binary large object to be loaded in bytes.
Data Modification / Submit changes immediately When this options is off, the changes you make to data in a table are accumulated in IntelliJ IDEA unless you carry out the Submit command (Submit in the context menu or Ctrl+Enter). Before you submit the changes, you can revert them (Revert in the context menu or Ctrl+Z).

When this option is on, the changes are submitted right away.

See Submitting and reverting changes.

Last modified: 29 November 2016