Previous Index Next

3 SQL Features

This chapter describes all available SQL features of the AuDAO generator.

  1. 3.1 SQL Features
    1. 3.1.1 Primary Keys
    2. 3.1.2 Indexes
    3. 3.1.3 Foreign Keys
    4. 3.1.4 Sequences
    5. 3.1.5 Data

3.1 SQL Features

3.1.1 Primary Keys

Primary keys are automatically generated on SQL level. Although primary keys can contain more than one column, it is recommended to use only one-column primary keys due to limitations of the DAO layer.

The primary key columns are recognized by the column flag <pk/>.

See also: XSD - column

3.1.2 Indexes

Indexes are automatically generated on SQL level. Both unique and nonunique indexes are supported.

Indexes are defined by separate indexes/index definitions.

See also: XSD - index

3.1.3 Foreign Keys

Foreign keys are automatically generated on SQL level.

Foreign keys are generated when <ref> reference is used.

See also: XSD - ref

3.1.4 Sequences

Sequences are automatically generated on SQL level only for Oracle DB.

Sequences are generated when <auto/> with <pk/> is used.

See also: XSD - column

3.1.5 Data

Data insertion statements are automatically generated for standard databases.

Data insertion statements are generated when <data> definition is present.

See also: XSD - table

Previous Index Next
Free Online Tool

Try our free online DAO generator.

Upload the configuration XML file and get the generated SQL scripts and Java classes for free !

Free GQL Parser

Download source or binary of our open-source GQL parser.

Query q =
 new GqlDynamic()
  .parseQuery(
   "SELECT * FROM Ent");
All GQL features are supported. More...