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}