001/*
002 * Sonar, open source software quality management tool.
003 * Copyright (C) 2008-2012 SonarSource
004 * mailto:contact AT sonarsource DOT com
005 *
006 * Sonar is free software; you can redistribute it and/or
007 * modify it under the terms of the GNU Lesser General Public
008 * License as published by the Free Software Foundation; either
009 * version 3 of the License, or (at your option) any later version.
010 *
011 * Sonar is distributed in the hope that it will be useful,
012 * but WITHOUT ANY WARRANTY; without even the implied warranty of
013 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
014 * Lesser General Public License for more details.
015 *
016 * You should have received a copy of the GNU Lesser General Public
017 * License along with Sonar; if not, write to the Free Software
018 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02
019 */
020package org.sonar.core.persistence.dialect;
021
022import org.apache.commons.lang.StringUtils;
023import org.hibernate.dialect.Oracle10gDialect;
024import org.sonar.api.database.DatabaseProperties;
025
026import java.sql.Types;
027
028/**
029 * @since 1.12
030 */
031public class Oracle implements Dialect {
032
033  public static final String ID = "oracle";
034
035  public String getId() {
036    return ID;
037  }
038
039  public String getActiveRecordDialectCode() {
040    return "oracle";
041  }
042
043  public String getActiveRecordJdbcAdapter() {
044    return "oracle_enhanced";
045  }
046
047  public Class<? extends org.hibernate.dialect.Dialect> getHibernateDialectClass() {
048    return Oracle10gWithDecimalDialect.class;
049  }
050
051  public boolean matchesJdbcURL(String jdbcConnectionURL) {
052    return StringUtils.startsWithIgnoreCase(jdbcConnectionURL, "jdbc:oracle:");
053  }
054
055  public static class Oracle10gWithDecimalDialect extends Oracle10gDialect {
056    public Oracle10gWithDecimalDialect() {
057      super();
058      registerColumnType(Types.DOUBLE, "number($p,$s)");
059      registerColumnType(Types.VARCHAR, DatabaseProperties.MAX_TEXT_SIZE, "clob");
060      registerColumnType(Types.VARBINARY, "blob");
061    }
062
063    @Override
064    public Class getNativeIdentifierGeneratorClass() {
065      return OracleSequenceGenerator.class;
066    }
067  }
068
069  public String getDefaultDriverClassName() {
070    return "oracle.jdbc.OracleDriver";
071  }
072
073  public String getConnectionInitStatement(String schema) {
074    if (StringUtils.isNotBlank(schema)) {
075      return "ALTER SESSION SET CURRENT_SCHEMA = \"" + schema + "\"";
076    }
077    return null;
078  }
079
080  public String getTrueSqlValue() {
081    return "1";
082  }
083
084  public String getFalseSqlValue() {
085    return "0";
086  }
087}