5.9 Dialect for Multi-Database Support

Currently, the ActiveRecordPlugin provides implementations for MysqlDialect, OracleDialect, PostgresqlDialect, SqlServerDialect, Sqlite3Dialect, and AnsiSqlDialect. MysqlDialect and OracleDialect offer support for MySQL and Oracle databases, respectively, while AnsiSqlDialect supports databases that comply with ANSI SQL standards. Below is the configuration code for setting the database dialect:

public class DemoConfig extends JFinalConfig {
  public void configPlugin(Plugins me) {
    ActiveRecordPlugin arp = new ActiveRecordPlugin(…);
    me.add(arp);
    // Configuring the Postgresql dialect
    arp.setDialect(new PostgresqlDialect());
  }
}