Configuring Connection Properties
In addition to the connection details in the Connection tab, a database connection has a number of properties. Which properties are available depends on the database type of the connection, and on your edition of DbVisualizer.
You can set the properties at two levels: for all connections of a database type, in Tool Properties, and for a single connection, in its Properties tab.
Properties for a database type
The Database tab in Tools → Tool Properties lists all supported database types, such as Oracle, SQL Server and PostgreSQL. The properties you set for a database type apply to all connections of that type.

Properties for a connection
You can override the properties of the database type for a single connection, in the Properties tab of the connection's Object View tab. This way, you change settings for all connections of a type in one place, and only set the exceptions for each connection.

The Properties tab is organized like Tool Properties, but only shows the categories that apply to the connection. Some categories depend on the database, such as Explain Plan. The Connection Properties, Database Profile and Driver Properties categories are only available for a connection. This page describes Database Profile and Driver Properties; the other categories are described with the features they apply to.
To open the properties of the database type, click the Global Properties link at the top right.
Database profile
In the Database Profile category, you choose which database profile DbVisualizer uses for the connection: Auto Detect (default), Manually Choose, or the "Generic" Profile. Reconnect for the change to take effect.

With Auto Detect, the profile is chosen from the Database Type of the connection. If Database Type is also Auto Detect, DbVisualizer first detects the database type from the driver. There is rarely a reason to choose the profile yourself.
Driver properties
In the Driver Properties category, you set properties that are passed to the database driver when DbVisualizer connects. Use the filter to find a property.

Most properties, their default values and descriptions come from the driver, and not all drivers have them. Some are added by DbVisualizer for the driver, or by you; the Origin column shows where each property comes from. To change a property, edit its Value. The Edited column shows which properties you have changed. Properties that have the driver's default value aren't passed to the driver.
To add a property, click the plus button. The minus button removes a property you added, or resets a property to its default value.
Calling Java methods in the JDBC driver
In the driver properties list, you can also call methods of the JDBC classes java.sql.Connection and java.sql.Statement. Enter the method name, prefixed with the class name in lowercase, as Parameter, and the argument as Value. The method must take one argument: a whole number, true or false, or a text value.
Here are a few examples:
| Parameter | Value |
|---|---|
| java.sql.connection.setReadOnly | true |
| java.sql.statement.setFetchSize | 1000 |
java.sql.connection methods are called when DbVisualizer has connected to the database, and java.sql.statement methods when a statement has been created, before it is executed.