Example usage for org.hibernate.dialect DB2Dialect DB2Dialect

Introduction

In this page you can find the example usage for org.hibernate.dialect DB2Dialect DB2Dialect.

Prototype

public DB2Dialect() 

Source Link

Document

Constructs a DB2Dialect

Usage

From source file:com.manydesigns.portofino.database.platforms.IbmDb2DatabasePlatform.java

License:Open Source License

public IbmDb2DatabasePlatform() {
    super(new DB2Dialect(), "jdbc:db2://<host>[:<port>]/<database_name>");
}

---

From source file:com.siemens.scr.avt.ad.hibernate.DB2XMLDialect.java

License:Open Source License

public static void main(String[] args) {
    System.out.println(new DB2Dialect().getLimitString("/*foo*/ select * from foos", true));
    System.out.println(new DB2Dialect().getLimitString("/*foo*/ select distinct * from foos", true));
    System.out.println(//from   w  ww  .  j  av  a2 s. co m
            new DB2Dialect().getLimitString("/*foo*/ select * from foos foo order by foo.bar, foo.baz", true));
    System.out.println(new DB2Dialect()
            .getLimitString("/*foo*/ select distinct * from foos foo order by foo.bar, foo.baz", true));
}

---

From source file:org.efs.openreports.util.schema.SchemaGenerator.java

License:Open Source License

public static void main(String[] args) {
    try {/*w  w  w.j  av  a 2s. c  o  m*/
        Configuration cfg = new Configuration().configure();

        String[] scripts = cfg.generateSchemaCreationScript(new HSQLDialect());
        writeFile("or_ddl_hsqldb.sql", scripts);

        scripts = cfg.generateSchemaCreationScript(new MySQLDialect());
        writeFile("or_ddl_mysql.sql", scripts);

        scripts = cfg.generateSchemaCreationScript(new SybaseDialect());
        writeFile("or_ddl_sybase.sql", scripts);

        scripts = cfg.generateSchemaCreationScript(new DB2Dialect());
        writeFile("or_ddl_db2.sql", scripts);

        // hibernate bug?
        cfg = new Configuration().configure();

        scripts = cfg.generateSchemaCreationScript(new PostgreSQLDialect());
        writeFile("or_ddl_postgre.sql", scripts);

        scripts = cfg.generateSchemaCreationScript(new Oracle9Dialect());
        writeFile("or_ddl_oracle.sql", scripts);

        //hibernate bug?
        cfg = new Configuration().configure();

        scripts = cfg.generateSchemaCreationScript(new SQLServerDialect());
        writeFile("or_ddl_sqlserver.sql", scripts);

        //hibernate bug?
        cfg = new Configuration().configure();

        scripts = cfg.generateSchemaCreationScript(new DerbyDialect());
        writeFile("or_ddl_derby.sql", scripts);
    } catch (Exception e) {
        e.printStackTrace();
    }
}

---