KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > objectweb > jonas > jtests > tables > Tbeanexc


1 /*
2  * JOnAS: Java(TM) Open Application Server
3  * Copyright (C) 1999 Bull S.A.
4  * Contact: jonas-team@objectweb.org
5  *
6  * This library is free software; you can redistribute it and/or
7  * modify it under the terms of the GNU Lesser General Public
8  * License as published by the Free Software Foundation; either
9  * version 2.1 of the License, or any later version.
10  *
11  * This library is distributed in the hope that it will be useful,
12  * but WITHOUT ANY WARRANTY; without even the implied warranty of
13  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
14  * Lesser General Public License for more details.
15  *
16  * You should have received a copy of the GNU Lesser General Public
17  * License along with this library; if not, write to the Free Software
18  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
19  * USA
20  *
21  * --------------------------------------------------------------------------
22  * $Id: Tbeanexc.java,v 1.9 2004/03/19 11:57:15 benoitf Exp $
23  * --------------------------------------------------------------------------
24  */
25
26 package org.objectweb.jonas.jtests.tables;
27
28 import java.rmi.RemoteException JavaDoc;
29 import java.sql.Connection JavaDoc;
30 import java.sql.Statement JavaDoc;
31
32 import javax.naming.NamingException JavaDoc;
33
34 import org.objectweb.util.monolog.api.BasicLevel;
35
36 public class Tbeanexc extends Tmanager {
37
38     /**
39      * Entry point
40      */
41     public static void init() throws NamingException JavaDoc, RemoteException JavaDoc {
42     mgrInit();
43     createTable("beanexcAccountEB");
44     createTable("beanexcAccountEC");
45     }
46
47     /**
48      * create a table for CMP 1.x
49      */
50     private static void createTable(String JavaDoc name) throws RemoteException JavaDoc {
51
52     // get connection
53 Connection JavaDoc conn = null;
54     try {
55         conn = dataSource.getConnection();
56     } catch(Exception JavaDoc e) {
57         throw new RemoteException JavaDoc("Cannot get Connection");
58     }
59     
60     Statement JavaDoc stmt;
61     try {
62         stmt = conn.createStatement();
63         stmt.execute("DROP TABLE "+name);
64         stmt.close();
65         logger.log(BasicLevel.INFO, "Table "+name+" dropped");
66     } catch(Exception JavaDoc e) {
67         logger.log(BasicLevel.DEBUG, "Exception in dropTable : \n"+e);
68     }
69     try {
70         stmt = conn.createStatement();
71         stmt.execute("create table " + name +
72              "(c_number integer not null primary key,"+
73              "c_customer varchar(30), c_balance integer )");
74         stmt.execute("insert into "+name+" values(101,'Antoine de St Exupery',900)");
75         stmt.execute("insert into "+name+" values(102,'Alexandre Dumas fils',500)");
76         stmt.execute("insert into "+name+" values(103,'Conan Doyle',800)");
77         stmt.execute("insert into "+name+" values(104,'Alfred de Musset',140)");
78         stmt.execute("insert into "+name+" values(105,'Phileas Lebegue',235)");
79         stmt.execute("insert into "+name+" values(81, 'Philippe Coq',20)");
80         stmt.execute("insert into "+name+" values(82, 'Philippe Durieux',20)");
81         stmt.execute("insert into "+name+" values(83, 'Helene Joanin',20)");
82         stmt.execute("insert into "+name+" values(84, 'Adriana Danes',20)");
83         stmt.execute("insert into "+name+" values(85, 'Francois Exertier',20)");
84         stmt.execute("insert into "+name+" values(86, 'John Doo', 20)");
85         stmt.execute("insert into "+name+" values(87, 'Jim', 20)");
86         // Those following values are used to test ejbRemove() throwing RemoveException
87 stmt.execute("insert into "+name+" values(999990, 'For exception in ejbRemove', 20)");
88         stmt.execute("insert into "+name+" values(999991, 'For exception in ejbRemove', 20)");
89         stmt.execute("insert into "+name+" values(999992, 'For exception in ejbRemove', 20)");
90         stmt.execute("insert into "+name+" values(999993, 'For exception in ejbRemove', 20)");
91         stmt.close();
92         conn.close(); // release connection
93 } catch(Exception JavaDoc e) {
94         logger.log(BasicLevel.ERROR, "Exception in createTable : "+e);
95         throw new RemoteException JavaDoc("Exception in createTable : "+e);
96     }
97     logger.log(BasicLevel.INFO, "Table "+name+" created");
98     }
99
100 }
101
102
103
Popular Tags