Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Database tab in Tool Properties defines settings for all connections of the specific database type. All supported database types (Oracle, Informix, SQL Server, DB2, MySQL, etc.)  are listed, and for each database type there are a number of properties that are applied to any database connection of that type. This means, for instance, that a database connection defined as being a PostgreSQL database type will use the PostgreSQL properties defined in Tool Properties

Image RemovedImage Added

Connection Properties

...

The Connection Properties are available in the Properties sub tab in the the database connection's Object View tab.

Image RemovedImage Added

The Properties tab is organized basically the same way as the Tool Properties window. The main difference is that the list contains only the categories that are applicable to this database connection. The Database Profile and Driver Properties categories are available only in the Properties tab and not in Tool Properties. The page explains the Database Profile and Driver Properties categories, while the other categories are described in pages that describe feature the property applies to.

...

The Database Profile category is used to select whether a profile should be automatically detected and loaded by DbVisualizer, or if a specific one should be used for the database connection. The default strategy is to Auto Detect a database profile.

Image RemovedImage Added

Note

The way DbVisualizer auto detects a profile is based on the setting of Database Type in the Connection tab. If the Database Type is also set to Auto Detect, DbVisualizer first detects the database type based on the JDBC information, and then detects the profile based on the database type.

...

The Driver Properties category is used to fine tune a JDBC driver before the database connection is established. You can use the filter to quickly find a specific property. 

Image RemovedImage Added

The list of parameters, their default values and parameter descriptions are determined by the JDBC driver used for the connection. Not all drivers supports additional driver properties. To change a value, just modify it in the list. The first column in the list indicates whether the property has been modified or not, and so, whether DbVisualizer will pass that parameter and value onto the driver at connect time.

...