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-rdbms 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 = GenericRdbmsSpecifics.getInstance();

  private final static String timestampFormat = "MM/dd/yyyy HH:mm:ss.SSS";

  private final static String dateFormat = "MM/dd/yyyy HH:mm:ss";

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

  public DataRdbms getData(final Object object) {
    if (object instanceof Timestamp) {

      return new GenericDataRdbms("to_timestamp('", new SimpleDateFormat(timestampFormat).format(object),
          "', 'mm/dd/yyyy hh24:mi:ss.ff3')");
    }

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

    return genericRdbms.getData(object);
  }

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

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

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