fr.ms.log4jdbc.rdbms.OracleRdbmsSpecifics Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of log4jdbc-file-jboss5 Show documentation

The newest version!

package fr.ms.log4jdbc.rdbms;

import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
 * RDBMS specifics for the Oracle DB.
 *
 * @author Arthur Blake
 */
public class OracleRdbmsSpecifics implements RdbmsSpecifics {

  private final RdbmsSpecifics genericRdbms = GenericRdbms.getInstance();

  public boolean isRdbms(final String classType) {
    return classType.equals("oracle.jdbc.driver.OracleDriver") || classType.equals("oracle.jdbc.OracleDriver");
  }

  public String formatSql(final String sql) {
    return genericRdbms.formatSql(sql);
  }

  public String formatParameter(final Object object) {

    if (object instanceof Timestamp) {
      return "to_timestamp('" + new SimpleDateFormat("MM/dd/yyyy HH:mm:ss.SSS").format(object)
          + "', 'mm/dd/yyyy hh24:mi:ss.ff3')";
    }

    if (object instanceof Date) {
      return "to_date('" + new SimpleDateFormat("MM/dd/yyyy HH:mm:ss").format(object) + "', 'mm/dd/yyyy hh24:mi:ss')";
    }

    return genericRdbms.formatParameter(object);
  }

  public String getTypeQuery(String sql) {
    return genericRdbms.getTypeQuery(sql);
  }

  public boolean isCaseSensitive() {
    return genericRdbms.isCaseSensitive();
  }
}