Skip to content
The latest version of DbVisualizer was released 2024-07-04DOWNLOAD HERE ->

How a Database Profile is loaded

DbVisualizer automatically detect what database profile to use based on the Database Type setting for a database connection. A database profile can also be manually specified in the connection properties.

A database profile is located using the search paths defined in Connection Properties tab and the Database Profile category. The standard directories in the search path are:

  1. WORKSPACE\ext\profile
  2. DBVIS-HOME\resources\profiles

WORKSPACE is the workspace directory keeping all the user settings for DbVisualizer. By default, it's located in the .dbvis directory in the user's home directory.

The list of paths may be reorganized and directories can be added. Profile files are searched in the specified order.

If the actual database profile is found in the search path it is loaded and any parent profile(s) it extends are also loaded and finally merged.

If there is no matching profile then the generic profile is automatically used. This is very basic profile and shows only basic information about the objects in the database and should support most databases with a JDBC driver.

A database profile other than the generic is built for a specific database. Manually selecting for example a database profile for Oracle while connecting to Db2 will result in all sorts of errors.