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.SQLServerDialect;
024import org.sonar.api.database.DatabaseProperties;
025
026import java.sql.Types;
027
028public class MsSql implements Dialect {
029
030  public static final String ID = "mssql";
031
032  public String getId() {
033    return ID;
034  }
035
036  public String getActiveRecordDialectCode() {
037    return "sqlserver";
038  }
039
040  public String getActiveRecordJdbcAdapter() {
041    return "jdbc";
042  }
043
044  public Class<? extends org.hibernate.dialect.Dialect> getHibernateDialectClass() {
045    return MsSqlDialect.class;
046  }
047
048  public boolean matchesJdbcURL(String jdbcConnectionURL) {
049    return StringUtils.startsWithIgnoreCase(jdbcConnectionURL, "jdbc:microsoft:sqlserver:")
050      || StringUtils.startsWithIgnoreCase(jdbcConnectionURL, "jdbc:jtds:sqlserver:");
051  }
052
053  public static class MsSqlDialect extends SQLServerDialect {
054    public MsSqlDialect() {
055      super();
056      registerColumnType(Types.DOUBLE, "decimal");
057      registerColumnType(Types.VARCHAR, 255, "nvarchar($l)");
058      registerColumnType(Types.VARCHAR, DatabaseProperties.MAX_TEXT_SIZE, "nvarchar(max)");
059      registerColumnType(Types.CHAR, "nchar(1)");
060      registerColumnType(Types.CLOB, "nvarchar(max)");
061    }
062
063    @Override
064    public String getTypeName(int code, int length, int precision, int scale) {
065      if (code != 2005) {
066        return super.getTypeName(code, length, precision, scale);
067      } else {
068        return "ntext";
069      }
070    }
071  }
072
073  public String getDefaultDriverClassName() {
074    return "net.sourceforge.jtds.jdbc.Driver";
075  }
076
077  public String getConnectionInitStatement(String schema) {
078    return null;
079  }
080
081  public String getTrueSqlValue() {
082    return "1";
083  }
084
085  public String getFalseSqlValue() {
086    return "0";
087  }
088}
089