001/*
002 * HA-JDBC: High-Availability JDBC
003 * Copyright (c) 2004-2007 Paul Ferraro
004 * 
005 * This library is free software; you can redistribute it and/or modify it 
006 * under the terms of the GNU Lesser General Public License as published by the 
007 * Free Software Foundation; either version 2.1 of the License, or (at your 
008 * option) any later version.
009 * 
010 * This library is distributed in the hope that it will be useful, but WITHOUT
011 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or 
012 * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License 
013 * for more details.
014 * 
015 * You should have received a copy of the GNU Lesser General Public License
016 * along with this library; if not, write to the Free Software Foundation, 
017 * Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
018 * 
019 * Contact: ferraro@users.sourceforge.net
020 */
021package net.sf.hajdbc.dialect;
022
023import java.sql.DatabaseMetaData;
024import java.sql.ResultSet;
025import java.sql.SQLException;
026import java.sql.Statement;
027import java.util.Collection;
028import java.util.LinkedList;
029import java.util.List;
030
031import net.sf.hajdbc.QualifiedName;
032
033/**
034 * Dialect for <a href="firebird.sourceforge.net">Firebird</a>.
035 * @author Paul Ferraro
036 */
037@SuppressWarnings("nls")
038public class FirebirdDialect extends StandardDialect
039{
040        /**
041         * @see net.sf.hajdbc.dialect.StandardDialect#dummyTable()
042         */
043        @Override
044        protected String dummyTable()
045        {
046                return "RDB$DATABASE";
047        }
048
049        /**
050         * Firebird 2.0 will support standard syntax.  Until then...
051         * @see net.sf.hajdbc.dialect.StandardDialect#alterSequenceFormat()
052         */
053        @Override
054        protected String alterSequenceFormat()
055        {
056                return "SET GENERATOR {0} TO {1}";
057        }
058
059        /**
060         * @see net.sf.hajdbc.dialect.StandardDialect#getSequences(java.sql.DatabaseMetaData)
061         */
062        @Override
063        public Collection<QualifiedName> getSequences(DatabaseMetaData metaData) throws SQLException
064        {
065                List<QualifiedName> sequenceList = new LinkedList<QualifiedName>();
066                
067                Statement statement = metaData.getConnection().createStatement();
068                
069                ResultSet resultSet = statement.executeQuery("SELECT RDB$GENERATOR_NAME FROM RDB$GENERATORS");
070                
071                while (resultSet.next())
072                {
073                        sequenceList.add(new QualifiedName(resultSet.getString(1)));
074                }
075                
076                statement.close();
077                
078                return sequenceList;
079        }
080
081        /**
082         * @see net.sf.hajdbc.dialect.StandardDialect#parseInsertTable(java.lang.String)
083         */
084        @Override
085        public String parseInsertTable(String sql)
086        {
087                return null;
088        }
089
090        /**
091         * Firebird 2.0 will support standard syntax.  Until then...
092         * @see net.sf.hajdbc.dialect.StandardDialect#sequencePattern()
093         */
094        @Override
095        protected String sequencePattern()
096        {
097                return "GEN_ID\\s*\\(\\s*([^\\s,]+)\\s*,\\s*\\d+\\s*\\)";
098        }
099
100        /**
101         * @see net.sf.hajdbc.dialect.StandardDialect#selectForUpdatePattern()
102         */
103        @Override
104        protected String selectForUpdatePattern()
105        {
106                return "SELECT\\s+.+\\s+WITH\\s+LOCK";
107        }
108
109        /**
110         * @see net.sf.hajdbc.dialect.StandardDialect#nextSequenceValueFormat()
111         */
112        @Override
113        protected String nextSequenceValueFormat()
114        {
115                return "GEN_ID({0}, 1)";
116        }
117}