KickJava   Java API By Example, From Geeks To Geeks.

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


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  * @author Paul Ferraro
25  *
26  */
27 public class MySQLDialect extends DefaultDialect
28 {
29     /**
30      * Deferrability clause is not supported.
31      * @see net.sf.hajdbc.dialect.DefaultDialect#createForeignKeyPattern()
32      */
33     @Override JavaDoc
34     protected String JavaDoc createForeignKeyPattern()
35     {
36         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} ON UPDATE {6,choice,0#CASCADE|1#RESTRICT|2#SET NULL|3#NO ACTION|4#SET DEFAULT}";
37     }
38     
39     /**
40      * @see net.sf.hajdbc.dialect.DefaultDialect#createUniqueKeyPattern()
41      */
42     @Override JavaDoc
43     protected String JavaDoc createUniqueKeyPattern()
44     {
45         return "ALTER TABLE {1} ADD UNIQUE {0} ({2})";
46     }
47
48     /**
49      * @see net.sf.hajdbc.dialect.DefaultDialect#dropForeignKeyPattern()
50      */
51     @Override JavaDoc
52     protected String JavaDoc dropForeignKeyPattern()
53     {
54         return "ALTER TABLE {1} DROP FOREIGN KEY {0}";
55     }
56
57     /**
58      * @see net.sf.hajdbc.dialect.DefaultDialect#dropUniqueKeyPattern()
59      */
60     @Override JavaDoc
61     protected String JavaDoc dropUniqueKeyPattern()
62     {
63         return "ALTER TABLE {1} DROP INDEX {0}";
64     }
65 }
66
Popular Tags