Skip to end of metadata
Go to start of metadata

Only in DbVisualizer Pro

This document and the Database Profile Framework in general is appropriate only when using the licensed DbVisualizer Pro edition.

The top level XML elements in a database profile is as follows:

  • InitCommands (optional)
    Defines SQLs that are executed before the profile is being loaded,
  • Commands
    Defines the SQLs for the ObjectsTreeDef, ObjectsViewDef and ObjectsActionDef,
  • ObjectsActionDef (optional)
    Defines actions for object types,
  • ObjectsTreeDef
    Defines the structure and what objects should be visible in the objects tree, 
  • ObjectsViewDef
    Defines the object views for a specific object type.

All database connections loads a database profile from an XML file and if there is no matching database profile, the generic profile is used. This profile use standard JDBC metadata requests to obtain information about the (some) objects in the database. The generic profile is located in DBVIS-HOME\resources\profiles\generic.xml.

XML template

The following show an overview of a database profile with the top level XML elements.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE DatabaseProfile SYSTEM "dbvis-defs.dtd">

<DatabaseProfile desc="Profile for Sybase ASE"
                 version="$Revision: 20369 $"
                 date="$Date: 2016-05-24 17:29:25 +0200 (Tue, 24 May 2016) $"
                 minver="9.5"
                 extends="generic">
 
  <InitCommands extends="true">
    ...
  </InitCommands>

  <Commands extends="true">
    ...
  </Commands>

  <ObjectsActionDef extends="true">
    ...
  </ObjectsActionDef>

  <ObjectsTreeDef extends="false">
    ...
  </ObjectsTreeDef>

  <ObjectsViewDef extends="true">
    ...
  </ObjectsViewDef>

</DatabaseProfile>

The DOCTYPE identifier at row 2 defines the DTD that is used to validate the XML. 

The root element for the database profile framework is the DatabaseProfile element setting various attributes. Continue to the next sections for information about XML elements forming a database profile.

  • No labels