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}