KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > objectweb > cjdbc > scenario > raidb2 > Raidb2StaticSchemaScenario


1 /**
2  * C-JDBC: Clustered JDBC.
3  * Copyright (C) 2002-2004 French National Institute For Research In Computer
4  * Science And Control (INRIA).
5  * Contact: c-jdbc@objectweb.org
6  *
7  * This library is free software; you can redistribute it and/or modify it
8  * under the terms of the GNU Lesser General Public License as published by the
9  * Free Software Foundation; either version 2.1 of the License, or any later
10  * version.
11  *
12  * This library is distributed in the hope that it will be useful, but WITHOUT
13  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
14  * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License
15  * for more details.
16  *
17  * You should have received a copy of the GNU Lesser General Public License
18  * along with this library; if not, write to the Free Software Foundation,
19  * Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
20  *
21  * Initial developer(s): Nicolas Modrzyk.
22  * Contributor(s): ______________________.
23  */
24
25 package org.objectweb.cjdbc.scenario.raidb2;
26
27 import java.sql.Connection JavaDoc;
28
29 import org.objectweb.cjdbc.scenario.templates.SimpleRaidb2Template;
30
31 /**
32  * This class defines a Raidb2StaticSchemaScenario
33  *
34  * @author <a HREF="mailto:Nicolas.Modrzyk@inrialpes.fr">Nicolas Modrzyk</a>
35  * @version 1.0
36  */
37 public class Raidb2StaticSchemaScenario extends SimpleRaidb2Template
38 {
39   public void testDrop() throws Exception JavaDoc
40   {
41       //Load database
42 cm.loadVirtualDatabases(controller, "myDB",
43           "hsqldb-raidb2-static-schema.xml");
44       mainVdb = controller.getVirtualDatabase("myDB");
45       mainVdb.enableAllBackends();
46       
47       Connection JavaDoc con = getCJDBCConnection();
48       con.createStatement().executeUpdate("Drop table REGION");
49       
50       con.createStatement().executeUpdate("create table region ( r_regionkey INTEGER NOT NULL, r_name CHAR(25), r_comment VARCHAR(152), PRIMARY KEY(r_regionkey))");
51   }
52 }
53
Popular Tags