Retrieving Database Metadata 1

The JDBC Metadata Explorer enables the retrieval of different database metadata (vendor/product name, supported functions, etc.) and the retrieval of existing schemas from the database that is connected via JDBC.

Input

Add the <databasemeta resulttag="Result element name"/> element to an input XML document with any root element, and specify a valid XML name within its resulttag attribute.

HTML/XML

<Root>
  <databasemeta resulttag="Result element name"/>
</Root>

Output

The output XML structure contains the <Data> root element with a child element whose name has been specified in the input structure within the resulttag attribute. It contains schema information and database metadata:

HTML/XML

<Data>
   <ResultElementName key="value" ...>
   <Schema>
      <TABLE_SCHEM>DB-Schema</TABLE_SCHEM>
      <TABLE_CATALOG isNull="(true/false)" />
   </Schema>
   ...
   </ResultElementName>
</Data>

Example

An input XML document contains the following XML structure to output metadata for the connected database:

HTML/XML

<RootElement>
   <databasemeta resulttag="DB"/>
</RootElement>

Then, the JDBC Metadata Explorer outputs e. g. the following result XML document:

HTML/XML

<Data>
   <DB product-name="Apache Derby" readOnly="false"
      supports-stored-procedures="true" supports-batch-updates="true"
      all-tables-are-selectable="true" supports-outer-joins="true"
      supports-convert="true" supports-group-by="true">
      <Schema>
         <TABLE_SCHEM>APP</TABLE_SCHEM>
         <TABLE_CATALOG isNull="true" />
      </Schema>
      ...
   </DB>