KickJava   Java API By Example, From Geeks To Geeks.

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


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 HSQLDB (open-source)
25  * <p><a HREF="http://www.hsqldb.org">http://www.hsqldb.org</a></p>
26  *
27  * @author Paul Ferraro
28  * @since 1.1
29  */
30 public class HSQLDBDialect extends DefaultDialect
31 {
32     /**
33      * @see net.sf.hajdbc.dialect.DefaultDialect#getSimpleSQL()
34      */
35     @Override JavaDoc
36     public String JavaDoc getSimpleSQL()
37     {
38         return "CALL NOW()";
39     }
40     
41     /**
42      * Deferrability clause is not supported.
43      * @see net.sf.hajdbc.dialect.DefaultDialect#createForeignKeyPattern()
44      */
45     @Override JavaDoc
46     protected String JavaDoc createForeignKeyPattern()
47     {
48         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}";
49     }
50 }
51
Popular Tags