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 */ 020 package org.sonar.core.persistence.dialect; 021 022 import org.hibernate.dialect.Dialect; 023 import org.hibernate.id.PersistentIdentifierGenerator; 024 import org.hibernate.id.SequenceGenerator; 025 import org.hibernate.type.Type; 026 027 import java.util.Properties; 028 029 /** 030 * if the underlying database is PostgreSQL, the sequence 031 * naming convention is different and includes the primary key 032 * column name 033 * 034 * @since 1.10 035 */ 036 public class PostgreSQLSequenceGenerator extends SequenceGenerator { 037 038 public static final String SEQUENCE_NAME_SEPARATOR = "_"; 039 public static final String SEQUENCE_NAME_SUFFIX = "seq"; 040 041 @Override 042 public void configure(Type type, Properties params, Dialect dialect) { 043 044 String tableName = params.getProperty(PersistentIdentifierGenerator.TABLE); 045 String columnName = params.getProperty(PersistentIdentifierGenerator.PK); 046 047 if (tableName != null && columnName != null) { 048 StringBuilder sequenceNameBuilder = new StringBuilder(); 049 050 sequenceNameBuilder.append(tableName); 051 sequenceNameBuilder.append(SEQUENCE_NAME_SEPARATOR); 052 sequenceNameBuilder.append(columnName); 053 sequenceNameBuilder.append(SEQUENCE_NAME_SEPARATOR); 054 sequenceNameBuilder.append(SEQUENCE_NAME_SUFFIX); 055 056 params.setProperty(SEQUENCE, sequenceNameBuilder.toString()); 057 } 058 059 super.configure(type, params, dialect); 060 } 061 062 }