How to use ch.qos.logback.core.db.dialect

sqlDialect = new PostgreSQLDialect();
break;
sqlDialect = new MySQLDialect();
break;
sqlDialect = new OracleDialect();
break;
sqlDialect = new MsSQLDialect();
break;
sqlDialect = new HSQLDBDialect();
break;
sqlDialect = new H2Dialect();
break;
sqlDialect = new SybaseSqlAnywhereDialect();
break;
sqlDialect = new SQLiteDialect();
break;

 /**
  * This method handles cases where the
  * {@link DatabaseMetaData#supportsBatchUpdates} method is missing in the JDBC
  * driver implementation.
  */
 public boolean supportsBatchUpdates(DatabaseMetaData meta) {
  try {
   return meta.supportsBatchUpdates();
  } catch (Throwable e) {
   addInfo("Missing DatabaseMetaData.supportsBatchUpdates method.");
   return false;
  }
 }
}

/**
 * Learn relevant information about this connection source.
 *
 */
public void discoverConnectionProperties() {
 Connection connection = null;
 try {
  connection = getConnection();
  if (connection == null) {
   addWarn("Could not get a connection");
   return;
  }
  DatabaseMetaData meta = connection.getMetaData();
  DBUtil util = new DBUtil();
  util.setContext(getContext());
  supportsGetGeneratedKeys = util.supportsGetGeneratedKeys(meta);
  supportsBatchUpdates = util.supportsBatchUpdates(meta);
  dialectCode = DBUtil.discoverSQLDialect(meta);
  addInfo("Driver name="+meta.getDriverName());
  addInfo("Driver version="+meta.getDriverVersion());
  addInfo("supportsGetGeneratedKeys="+supportsGetGeneratedKeys);
  
 } catch (SQLException se) {
  addWarn("Could not discover the dialect to use.", se);
 } finally {
  DBHelper.closeConnection(connection);
 }
}

public static SQLDialect getDialectFromCode(SQLDialectCode sqlDialectType) {
 SQLDialect sqlDialect = null;
 switch (sqlDialectType) {
 case POSTGRES_DIALECT:
  sqlDialect = new PostgreSQLDialect();
  break;
 case MYSQL_DIALECT:
  sqlDialect = new MySQLDialect();
  break;
 case ORACLE_DIALECT:
  sqlDialect = new OracleDialect();
  break;
 case MSSQL_DIALECT:
  sqlDialect = new MsSQLDialect();
  break;
 case HSQL_DIALECT:
  sqlDialect = new HSQLDBDialect();
  break;
 }
 return sqlDialect;
}

DBUtil dbutilObject= new DBUtil ();
 //YOUR CONNECTION VARIABLE
 Connection con1 = dbutilObject.getDBConnection();

@Override
public void start() {
 if (connectionSource == null) {
  throw new IllegalStateException(
    "DBAppender cannot function without a connection source");
 }
 sqlDialect = DBUtil
   .getDialectFromCode(connectionSource.getSQLDialectCode());
 if (getGeneratedKeysMethod() != null) {
  cnxSupportsGetGeneratedKeys = connectionSource.supportsGetGeneratedKeys();
 } else {
  cnxSupportsGetGeneratedKeys = false;
 }
 cnxSupportsBatchUpdates = connectionSource.supportsBatchUpdates();
 if (!cnxSupportsGetGeneratedKeys && (sqlDialect == null)) {
  throw new IllegalStateException(
    "DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect");
 }
 // all nice and dandy on the eastern front
 super.start();
}

idStatement = connection.createStatement();
idStatement.setMaxRows(1);
String selectInsertIdStr = sqlDialect.getSelectInsertId();
rs = idStatement.executeQuery(selectInsertIdStr);

public static SQLDialect getDialectFromCode(SQLDialectCode sqlDialectType) {
  SQLDialect sqlDialect = null;
  switch (sqlDialectType) {
  case POSTGRES_DIALECT:
    sqlDialect = new PostgreSQLDialect();
    break;
  case MYSQL_DIALECT:
    sqlDialect = new MySQLDialect();
    break;
  case ORACLE_DIALECT:
    sqlDialect = new OracleDialect();
    break;
  case MSSQL_DIALECT:
    sqlDialect = new MsSQLDialect();
    break;
  case HSQL_DIALECT:
    sqlDialect = new HSQLDBDialect();
    break;
  case H2_DIALECT:
    sqlDialect = new H2Dialect();
    break;
  case SYBASE_SQLANYWHERE_DIALECT:
    sqlDialect = new SybaseSqlAnywhereDialect();
    break;
  case SQLITE_DIALECT:
    sqlDialect = new SQLiteDialect();
    break;
  }
  return sqlDialect;
}

/**
 * This method handles cases where the
 * {@link DatabaseMetaData#supportsGetGeneratedKeys} method is missing in the
 * JDBC driver implementation.
 */
public boolean supportsGetGeneratedKeys(DatabaseMetaData meta) {
 try {
  //
  // invoking JDBC 1.4 method by reflection
  //
  return ((Boolean) DatabaseMetaData.class.getMethod(
    "supportsGetGeneratedKeys", (Class[]) null).invoke(meta,
    (Object[]) null)).booleanValue();
 } catch (Throwable e) {
  addInfo("Could not call supportsGetGeneratedKeys method. This may be recoverable");
  return false;
 }
}

sqlDialect = new PostgreSQLDialect();
break;
sqlDialect = new MySQLDialect();
break;
sqlDialect = new OracleDialect();
break;
sqlDialect = new MsSQLDialect();
break;
sqlDialect = new HSQLDBDialect();
break;
sqlDialect = new H2Dialect();
break;
sqlDialect = new SybaseSqlAnywhereDialect();
break;
sqlDialect = new SQLiteDialect();
break;

 /**
  * This method handles cases where the
  * {@link DatabaseMetaData#supportsBatchUpdates} method is missing in the JDBC
  * driver implementation.
  */
 public boolean supportsBatchUpdates(DatabaseMetaData meta) {
  try {
   return meta.supportsBatchUpdates();
  } catch (Throwable e) {
   addInfo("Missing DatabaseMetaData.supportsBatchUpdates method.");
   return false;
  }
 }
}

public static SQLDialect getDialectFromCode(SQLDialectCode sqlDialectType) {
  SQLDialect sqlDialect = null;
  switch (sqlDialectType) {
  case POSTGRES_DIALECT:
    sqlDialect = new PostgreSQLDialect();
    break;
  case MYSQL_DIALECT:
    sqlDialect = new MySQLDialect();
    break;
  case ORACLE_DIALECT:
    sqlDialect = new OracleDialect();
    break;
  case MSSQL_DIALECT:
    sqlDialect = new MsSQLDialect();
    break;
  case HSQL_DIALECT:
    sqlDialect = new HSQLDBDialect();
    break;
  case H2_DIALECT:
    sqlDialect = new H2Dialect();
    break;
  case SYBASE_SQLANYWHERE_DIALECT:
    sqlDialect = new SybaseSqlAnywhereDialect();
    break;
  case SQLITE_DIALECT:
    sqlDialect = new SQLiteDialect();
    break;
  }
  return sqlDialect;
}

  /**
   * This method handles cases where the
   * {@link DatabaseMetaData#supportsBatchUpdates} method is missing in the JDBC
   * driver implementation.
   */
  public boolean supportsBatchUpdates(DatabaseMetaData meta) {
    try {
      return meta.supportsBatchUpdates();
    } catch (Throwable e) {
      addInfo("Missing DatabaseMetaData.supportsBatchUpdates method.");
      return false;
    }
  }
}

sqlDialect = new PostgreSQLDialect();
break;
sqlDialect = new MySQLDialect();
break;
sqlDialect = new OracleDialect();
break;
sqlDialect = new MsSQLDialect();
break;
sqlDialect = new HSQLDBDialect();
break;
sqlDialect = new H2Dialect();
break;
sqlDialect = new SybaseSqlAnywhereDialect();
break;
sqlDialect = new SQLiteDialect();
break;

  /**
   * This method handles cases where the
   * {@link DatabaseMetaData#supportsBatchUpdates} method is missing in the JDBC
   * driver implementation.
   */
  public boolean supportsBatchUpdates(DatabaseMetaData meta) {
    try {
      return meta.supportsBatchUpdates();
    } catch (Throwable e) {
      addInfo("Missing DatabaseMetaData.supportsBatchUpdates method.");
      return false;
    }
  }
}

public static SQLDialect getDialectFromCode(SQLDialectCode sqlDialectType) {
  SQLDialect sqlDialect = null;
  switch (sqlDialectType) {
  case POSTGRES_DIALECT:
    sqlDialect = new PostgreSQLDialect();
    break;
  case MYSQL_DIALECT:
    sqlDialect = new MySQLDialect();
    break;
  case ORACLE_DIALECT:
    sqlDialect = new OracleDialect();
    break;
  case MSSQL_DIALECT:
    sqlDialect = new MsSQLDialect();
    break;
  case HSQL_DIALECT:
    sqlDialect = new HSQLDBDialect();
    break;
  case H2_DIALECT:
    sqlDialect = new H2Dialect();
    break;
  case SYBASE_SQLANYWHERE_DIALECT:
    sqlDialect = new SybaseSqlAnywhereDialect();
    break;
  case SQLITE_DIALECT:
    sqlDialect = new SQLiteDialect();
    break;
  }
  return sqlDialect;
}

 /**
  * This method handles cases where the
  * {@link DatabaseMetaData#supportsBatchUpdates} method is missing in the JDBC
  * driver implementation.
  */
 public boolean supportsBatchUpdates(DatabaseMetaData meta) {
  try {
   return meta.supportsBatchUpdates();
  } catch (Throwable e) {
   addInfo("Missing DatabaseMetaData.supportsBatchUpdates method.");
   return false;
  }
 }
}

sqlDialect = new PostgreSQLDialect();
break;
sqlDialect = new MySQLDialect();
break;
sqlDialect = new OracleDialect();
break;
sqlDialect = new MsSQLDialect();
break;
sqlDialect = new HSQLDBDialect();
break;
sqlDialect = new H2Dialect();
break;
sqlDialect = new SybaseSqlAnywhereDialect();
break;
sqlDialect = new SQLiteDialect();
break;

 /**
  * This method handles cases where the
  * {@link DatabaseMetaData#supportsBatchUpdates} method is missing in the JDBC
  * driver implementation.
  */
 public boolean supportsBatchUpdates(DatabaseMetaData meta) {
  try {
   return meta.supportsBatchUpdates();
  } catch (Throwable e) {
   addInfo("Missing DatabaseMetaData.supportsBatchUpdates method.");
   return false;
  }
 }
}

 /**
  * This method handles cases where the
  * {@link DatabaseMetaData#supportsBatchUpdates} method is missing in the JDBC
  * driver implementation.
  */
 public boolean supportsBatchUpdates(DatabaseMetaData meta) {
  try {
   return meta.supportsBatchUpdates();
  } catch (Throwable e) {
   addInfo("Missing DatabaseMetaData.supportsBatchUpdates method.");
   return false;
  }
 }
}