/*
 * Copyright 1999,2004 The Apache Software Foundation.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.apache.log4j.db.dialect;

import org.apache.log4j.db.ConnectionSource;
import org.apache.log4j.helpers.LogLog;

import java.sql.DatabaseMetaData;
import java.sql.SQLException;


/**
 *
 * @author Ceki Gulcu
 *
 */
public class Util {
  private static final String POSTGRES_PART = "postgresql";
  private static final String MYSQL_PART = "mysql";
  private static final String ORACLE_PART = "oracle";
  private static final String MSSQL_PART = "mssqlserver4";
  private static final String HSQL_PART = "hsql";
  
  public static int discoverSQLDialect(DatabaseMetaData meta) {
    int dialectCode = 0;

    try {

      String dbName = meta.getDatabaseProductName().toLowerCase();
      LogLog.debug("**db name is " + dbName);

      if (dbName.indexOf(POSTGRES_PART) != -1) {
        LogLog.debug("POSTGRESQL dialect selected");

        return ConnectionSource.POSTGRES_DIALECT;
      } else if (dbName.indexOf(MYSQL_PART) != -1) {
        return ConnectionSource.MYSQL_DIALECT;
      } else if (dbName.indexOf(ORACLE_PART) != -1) {
        return ConnectionSource.ORACLE_DIALECT;
      } else if (dbName.indexOf(MSSQL_PART) != -1) {
        return ConnectionSource.MSSQL_DIALECT;
      } else if (dbName.indexOf(HSQL_PART) != -1) {
        return ConnectionSource.HSQL_DIALECT;
      } else {
        return ConnectionSource.UNKNOWN_DIALECT;
      }
    } catch (SQLException sqle) {
      // we can't do much here
    }

    return dialectCode;
  }

  public static SQLDialect getDialectFromCode(int dialectCode) {
    SQLDialect sqlDialect = null;

    switch (dialectCode) {
    case ConnectionSource.POSTGRES_DIALECT:
      sqlDialect = new PostgreSQLDialect();

      break;
    case ConnectionSource.MYSQL_DIALECT:
      sqlDialect = new MySQLDialect();

      break;
    case ConnectionSource.ORACLE_DIALECT:
      sqlDialect = new OracleDialect();

      break;
    case ConnectionSource.MSSQL_DIALECT:
      sqlDialect = new MsSQLDialect();

      break;
    case ConnectionSource.HSQL_DIALECT:
      sqlDialect = new HSQLDBDialect();

      break;
    }
    return sqlDialect;
  }
  
  /**
   * This method handles cases where the 
   * {@link DatabaseMetaData#supportsGetGeneratedKeys} method is missing in the
   * JDBC driver implementation.
   */
  static public boolean supportsGetGeneratedKeys(DatabaseMetaData meta) {
    try {
      return meta.supportsGetGeneratedKeys();
    } catch(Throwable e) {
      LogLog.warn("The following warning is only informative.");
      LogLog.warn("Could not call supportsGetGeneratedKeys method. This may be recoverable");
      return false;
    }
  }
  
/** 
  * This method handles cases where the 
  * {@link DatabaseMetaData#supportsBatchUpdates} method is missing in the
  * JDBC driver implementation.
  */
  static public boolean supportsBatchUpdates(DatabaseMetaData meta) {
    try {
      return meta.supportsBatchUpdates();
    } catch(Throwable e) {
      LogLog.warn("Missing DatabaseMetaData.supportsBatchUpdates method.");
      return false;
    }
  }
}

@@ -1025,24 +1025,26 @@
 %22oracle%22;%0A  
+//
 private stat
@@ -1088,16 +1088,83 @@
 rver4%22;%0A
+  private static final String MSSQL_PART = %22microsoft sql server%22;%0A
   privat
@@ -1476,62 +1476,8 @@
 ) %7B%0A
-        LogLog.debug(%22POSTGRESQL dialect selected%22);%0A%0A
     

For MsSQL, it appears that the reported database name is "microsoft sql server"