KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > net > sf > hajdbc > dialect > MaxDBDialect


1 /*
2  * HA-JDBC: High-Availability JDBC
3  * Copyright (c) 2004-2006 Paul Ferraro
4  *
5  * This library is free software; you can redistribute it and/or modify it
6  * under the terms of the GNU Lesser General Public License as published by the
7  * Free Software Foundation; either version 2.1 of the License, or (at your
8  * option) any later version.
9  *
10  * This library is distributed in the hope that it will be useful, but WITHOUT
11  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
12  * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License
13  * for more details.
14  *
15  * You should have received a copy of the GNU Lesser General Public License
16  * along with this library; if not, write to the Free Software Foundation,
17  * Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
18  *
19  * Contact: ferraro@users.sourceforge.net
20  */
21 package net.sf.hajdbc.dialect;
22
23 /**
24  * Dialect for Oracle (commercial).
25  * @author Paul Ferraro
26  * @since 1.1
27  */
28 public class MaxDBDialect extends DefaultDialect
29 {
30     /**
31      * @see net.sf.hajdbc.dialect.DefaultDialect#getSimpleSQL()
32      */
33     @Override JavaDoc
34     public String JavaDoc getSimpleSQL()
35     {
36         return "SELECT 1 FROM DUAL";
37     }
38
39     /**
40      * @see net.sf.hajdbc.dialect.DefaultDialect#truncateTablePattern()
41      */
42     @Override JavaDoc
43     protected String JavaDoc truncateTablePattern()
44     {
45         return "TRUNCATE TABLE {0}";
46     }
47     
48     /**
49      * ON UPDATE and deferrability clauses are not supported.
50      * @see net.sf.hajdbc.dialect.DefaultDialect#createForeignKeyPattern()
51      */
52     @Override JavaDoc
53     protected String JavaDoc createForeignKeyPattern()
54     {
55         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}";
56     }
57 }
58
Popular Tags