Top level XML Elements
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"?>
<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.