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.DerbyDialect;
024import org.hibernate.id.IdentityGenerator;
025import org.sonar.api.database.DatabaseProperties;
026
027import java.sql.Types;
028
029/**
030 * @since 1.12
031 */
032public class Derby implements Dialect {
033
034  public static final String ID = "derby";
035
036  public String getId() {
037    return ID;
038  }
039
040  public String getActiveRecordDialectCode() {
041    return "derby";
042  }
043
044  public String getActiveRecordJdbcAdapter() {
045    return "jdbc";
046  }
047
048  public Class<? extends org.hibernate.dialect.Dialect> getHibernateDialectClass() {
049    return DerbyWithDecimalDialect.class;
050  }
051
052  public boolean matchesJdbcURL(String jdbcConnectionURL) {
053    return StringUtils.startsWithIgnoreCase(jdbcConnectionURL, "jdbc:derby:");
054  }
055
056  public String getDefaultDriverClassName() {
057    return "org.apache.derby.jdbc.ClientDriver";
058  }
059
060  public String getConnectionInitStatement(String schema) {
061    return null;
062  }
063
064  public static class DerbyWithDecimalDialect extends DerbyDialect {
065    public DerbyWithDecimalDialect() {
066      super();
067      registerColumnType(Types.DOUBLE, "decimal");
068      registerColumnType(Types.VARCHAR, DatabaseProperties.MAX_TEXT_SIZE, "clob");
069      registerColumnType(Types.VARBINARY, "blob");
070
071      // Not possible to do alter column types in Derby
072      registerColumnType(Types.BIGINT, "integer");
073
074      registerColumnType(Types.BIT, "boolean");
075    }
076
077    @Override
078    public String toBooleanValueString(boolean bool) {
079      return bool ? "true" : "false";
080    }
081
082    /**
083     * To be compliant with Oracle, we define on each model (ch.hortis.sonar.model classes)
084     * a sequence generator. It works on mySQL because strategy = GenerationType.AUTO, so
085     * it equals GenerationType.IDENTITY.
086     * But on derby, AUTO becomes TABLE instead of IDENTITY. So we explicitly change this behavior.
087     */
088    @Override
089    public Class getNativeIdentifierGeneratorClass() {
090      return IdentityGenerator.class;
091    }
092  }
093
094  public String getTrueSqlValue() {
095    return "true";
096  }
097
098  public String getFalseSqlValue() {
099    return "false";
100  }
101}