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 Oracle (commercial).
035 * @author Paul Ferraro
036 */
037@SuppressWarnings("nls")
038public class OracleDialect extends StandardDialect
039{
040        /**
041         * @see net.sf.hajdbc.dialect.StandardDialect#dummyTable()
042         */
043        @Override
044        protected String dummyTable()
045        {
046                return "DUAL";
047        }
048
049        /**
050         * @see net.sf.hajdbc.dialect.StandardDialect#getSequences(java.sql.DatabaseMetaData)
051         */
052        @Override
053        public Collection<QualifiedName> getSequences(DatabaseMetaData metaData) throws SQLException
054        {
055                List<QualifiedName> sequenceList = new LinkedList<QualifiedName>();
056                
057                Statement statement = metaData.getConnection().createStatement();
058                
059                ResultSet resultSet = statement.executeQuery("SELECT SEQUENCE_NAME FROM USER_SEQUENCES");
060                
061                while (resultSet.next())
062                {
063                        sequenceList.add(new QualifiedName(resultSet.getString(1)));
064                }
065                
066                statement.close();
067                
068                return sequenceList;
069        }
070
071        /**
072         * @see net.sf.hajdbc.dialect.StandardDialect#parseInsertTable(java.lang.String)
073         */
074        @Override
075        public String parseInsertTable(String sql)
076        {
077                return null;
078        }
079
080        /**
081         * @see net.sf.hajdbc.dialect.StandardDialect#truncateTableFormat()
082         */
083        @Override
084        protected String truncateTableFormat()
085        {
086                return "TRUNCATE TABLE {0}";
087        }
088        
089        /**
090         * ON UPDATE and deferrability clauses are not supported.
091         * @see net.sf.hajdbc.dialect.StandardDialect#createForeignKeyConstraintFormat()
092         */
093        @Override
094        protected String createForeignKeyConstraintFormat()
095        {
096                return "ALTER TABLE {1} ADD CONSTRAINT {0} FOREIGN KEY ({2}) REFERENCES {3} ({4}) ON DELETE {5,choice,0#CASCADE|1#RESTRICT|2#SET NULL|3#NO ACTION|4#SET DEFAULT}";
097        }
098
099        /**
100         * @see net.sf.hajdbc.dialect.StandardDialect#sequencePattern()
101         */
102        @Override
103        protected String sequencePattern()
104        {
105                return "'?(\\w+)'?\\.(?:CURR|NEXT)VAL";
106        }
107
108        /**
109         * @see net.sf.hajdbc.dialect.StandardDialect#nextSequenceValueFormat()
110         */
111        @Override
112        protected String nextSequenceValueFormat()
113        {
114                return "{0}.NEXTVAL";
115        }
116}