Previous Index Next

2 AuDAO Features - Compatibility Matrix

In this chapter we would like to list all available features of the AuDAO generator. The current AuDAO version 1.2 (release 2010-02-25) contains the following features.

2.1 SQL Feature Matrix

AuDAO let's you to generate SQL create and drop scripts. This is useful for standard database like MySQL and Oracle. As for Google App Engine you can use only index related features.

Feature MySQL Oracle DB HSQLDB Google App Engine Google App Engine - JDO
primary keys yes yes yes no no
indexes yes yes yes no no
foreign keys yes yes yes no no
sequences no yes yes no no
data yes yes yes no no

2.2 DAO Feature Matrix

AuDAO let's you to generate Java DAO classes. If we say "DAO" we mean DAO and all related stuff like DTO and DAO implementation classes.

Feature MySQL Oracle DB HSQLDB Google App Engine Google App Engine - JDO
type boolean yes yes yes yes yes
type short yes yes yes yes yes
type int yes yes yes yes yes
type long yes yes yes yes yes
type double yes yes yes yes yes
type String yes yes yes yes yes
type Date yes yes yes emulated emulated
type Timestamp yes yes yes emulated emulated
type byte[] yes yes yes yes no
type Serializable yes yes yes yes no
type List no no no yes no
enumerations yes yes yes yes yes
transient columns yes yes yes yes yes
primary key yes yes yes yes yes
parent key ignored ignored ignored yes yes
ancestor key ignored ignored ignored yes no
autoincrement pk autoincrement sequence sequence yes yes
autoincrement not pk no no no yes no
auto date yes yes yes yes yes
auto timestamp yes yes yes yes yes
method count yes yes yes yes yes
method delete yes yes yes yes yes
method find yes yes yes yes yes
method insert yes yes yes yes yes
method move yes yes yes no no
method truncate yes yes yes no no
method update yes yes yes yes yes
all finder yes yes yes yes yes
dynamic finder SQL SQL SQL GQL JDOQL
primary key finder yes yes yes yes yes
index finder yes yes yes yes yes
condition finder SQL SQL SQL GQL JDOQL
reference finder yes yes yes no no
batch insert emulated emulated emulated yes no
count all yes yes yes yes yes
count dynamic yes yes yes yes yes
count by index yes yes yes yes yes
count by condition yes yes yes yes yes
count by reference yes yes yes no no
delete by primary key yes yes yes yes yes
delete all yes yes yes max 500 rows max 500 rows
delete dynamic yes yes yes max 500 rows max 500 rows
delete by index yes yes yes max 500 rows max 500 rows
delete by condition yes yes yes max 500 rows max 500 rows
find by primary key yes yes yes yes yes
find all yes yes yes yes yes
find dynamic yes yes yes yes yes
find by index yes yes yes yes yes
find by condition yes yes yes yes yes
find by reference yes yes yes no no
update by primary key yes yes yes yes yes
update column by primary key yes yes yes yes yes
raw update by primary key yes yes yes no no
batch update all yes yes yes no no
batch update dynamic yes yes yes no no
batch update by index yes yes yes no no
batch update by condition yes yes yes no no
Previous Index Next
Online Generátor

Vyzkoušejte zadarmo náš online DAO generátor.

Vytvořte konfigurační XML soubor a získejte zadarmo vygenerované SQL skripty a Java třídy !

GQL Parser

Stáhněte si zdrojové či binární soubory GQL parseru.

Query q =
 new GqlDynamic()
  .parseQuery(
   "SELECT * FROM Ent");
Plná podpora GQL. Více...