KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > quadcap > sql > StmtAddConstraint


1 package com.quadcap.sql;
2
3 /* Copyright 1999 - 2003 Quadcap Software. All rights reserved.
4  *
5  * This software is distributed under the Quadcap Free Software License.
6  * This software may be used or modified for any purpose, personal or
7  * commercial. Open Source redistributions are permitted. Commercial
8  * redistribution of larger works derived from, or works which bundle
9  * this software requires a "Commercial Redistribution License"; see
10  * http://www.quadcap.com/purchase.
11  *
12  * Redistributions qualify as "Open Source" under one of the following terms:
13  *
14  * Redistributions are made at no charge beyond the reasonable cost of
15  * materials and delivery.
16  *
17  * Redistributions are accompanied by a copy of the Source Code or by an
18  * irrevocable offer to provide a copy of the Source Code for up to three
19  * years at the cost of materials and delivery. Such redistributions
20  * must allow further use, modification, and redistribution of the Source
21  * Code under substantially the same terms as this license.
22  *
23  * Redistributions of source code must retain the copyright notices as they
24  * appear in each source code file, these license terms, and the
25  * disclaimer/limitation of liability set forth as paragraph 6 below.
26  *
27  * Redistributions in binary form must reproduce this Copyright Notice,
28  * these license terms, and the disclaimer/limitation of liability set
29  * forth as paragraph 6 below, in the documentation and/or other materials
30  * provided with the distribution.
31  *
32  * The Software is provided on an "AS IS" basis. No warranty is
33  * provided that the Software is free of defects, or fit for a
34  * particular purpose.
35  *
36  * Limitation of Liability. Quadcap Software shall not be liable
37  * for any damages suffered by the Licensee or any third party resulting
38  * from use of the Software.
39  */
40
41 import java.io.IOException JavaDoc;
42
43 import java.sql.SQLException JavaDoc;
44
45 /**
46  * Implementation of SQL <b>ALTER TABLE ADD CONSTRAINT</b> statement.
47  *
48  * @author Stan Bailes
49  */
50 public class StmtAddConstraint implements Stmt {
51     String JavaDoc tableName;
52     Constraint constraintDef;
53
54     public StmtAddConstraint(String JavaDoc tableName, Constraint constraintDef) {
55     this.tableName = tableName;
56     this.constraintDef = constraintDef;
57     }
58
59     public void execute(Session session) throws IOException JavaDoc, SQLException JavaDoc {
60     Database db = session.getDatabase();
61         session.getTableWriteLock("#Schema");
62     session.getTableWriteLock(tableName);
63     Table table = (Table)db.getRelation(tableName);
64         String JavaDoc constraintName = constraintDef.getName();
65         if (constraintName != null &&
66             table.getConstraint(constraintName) != null) {
67             throw new SQLException JavaDoc("ADD CONSTRAINT: constraint '" +
68                                    constraintName + "' already exists in " +
69                                    "table '" + tableName + "'");
70         }
71     session.doStep(new AddConstraint(session, table, constraintDef));
72     }
73 }
74
Popular Tags