/*
* Lokomo OneCMDB - An Open Source Software for Configuration
* Management of Datacenter Resources
*
* Copyright (C) 2006 Lokomo Systems AB
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or (at
* your option) any later version.
*
* This program is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* Lokomo Systems AB can be contacted via e-mail: info@lokomo.com or via
* paper mail: Lokomo Systems AB, Sv�rdv�gen 27, SE-182 33
* Danderyd, Sweden.
*
*/
package org.onecmdb.core.internal.storage.hibernate.hsql;
import org.hibernate.dialect.HSQLDialect;
public class HypersonicSQL18Dialect extends HSQLDialect {
public String[] getCreateSequenceStrings(String sequenceName) {
return new String[] {
"create table information_schema." + sequenceName
+ " (zero integer)",
"insert into information_schema." + sequenceName + " values (0)",
"create sequence " + sequenceName + " start with 1"
};
}
public String[] getDropSequenceStrings(String sequenceName) {
return new String[] {
"drop table information_schema." + sequenceName + " if exists",
"drop sequence " + sequenceName
};
}
public String getSequenceNextValString(String sequenceName) {
return "select next value for " + sequenceName
+ " from information_schema." + sequenceName;
}
public String getQuerySequencesString() {
return "select sequence_name from information_schema.system_sequences";
}
}