Ce contenu n'est pas disponible dans la langue sélectionnée.
Chapter 11. DDL Metadata
11.1. DDL Metadata
A VDB can define models/schemas using DDL. Here is a small example of how one can define a view inside the
-vdb.xml file. See the <metadata> element under <model>.
Example 11.1. Example to show view definition
<model visible = "true" type = "VIRTUAL" name = "customers">
<metadata type = "DDL"><![CDATA[
CREATE VIEW PARTS (
PART_ID integer PRIMARY KEY,
PART_NAME varchar(255),
PART_COLOR varchar(30),
PART_WEIGHT varchar(255)
) AS
select a.id as PART_ID, a.name as PART_NAME, b.color as PART_COLOR, b.weight as PART_WEIGHT from modelA.part a, modelB.part b where a.id = b.id
]]>
</metadata>
</model>
Another complete DDL based example is at the end of this section.
Note
The declaration of metadata using DDL,
NATIVE or DDL-FILE is supported out of the box, however the MetadataRepository interface allows users to plug-in their own metadata facilities. For example, you can write a Hibernate based store that can feed the necessary metadata. You can find out more about custom metadata repositories in Red Hat JBoss Data Virtualization Development Guide: Server Development.
Note
The DDL based schema is not constrained to be defined only for the view models.
Note
The full grammar for DDL is in the appendix.
