Page History
...
The db.xml file uses the following tags to define the database mapping:• About
...
...
Anchor | ||||
---|---|---|---|---|
|
The Table tag defines the table and its attributes, as described in the following table. The Table tag is a top level element in the db.xml file.
...
alias Defines an alias name for a table that is used frequently. For example, you can use the same lookup table again for different purposes.
Anchor | ||||
---|---|---|---|---|
|
The Join tag is a second level element in the db.xml file, and is part of the table definition. The Join tag defines Join conditions between the current table and other specified tables. The Join tag defines a one-way connection from the current table to another table, but not in the opposite direction. Usually, lookup tables do not include a Join definition. Instead, they will be referenced inside a Join definition of Statistics Tables. You should not define a Join between two Statistics Tables, unless it is a One-to-one Join. The Join predicates are included in the tag contents.
...
• Database limitations - in Oracle it is impossible to apply any option on a column of a long data type, or to use it in the ‘group by’.
Anchor | ||||
---|---|---|---|---|
|
The Related tag is a second level element in the db.xml file, and is part of the table definition. This tag is only relevant for lookup tables. It defines the statistics table used for retrieving entity identifiers that depend on a specified condition (see the depend attribute).
...