KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > hsqldb > test > TestMultipleConnections


1 /* Copyright (c) 2001-2005, The HSQL Development Group
2  * All rights reserved.
3  *
4  * Redistribution and use in source and binary forms, with or without
5  * modification, are permitted provided that the following conditions are met:
6  *
7  * Redistributions of source code must retain the above copyright notice, this
8  * list of conditions and the following disclaimer.
9  *
10  * Redistributions in binary form must reproduce the above copyright notice,
11  * this list of conditions and the following disclaimer in the documentation
12  * and/or other materials provided with the distribution.
13  *
14  * Neither the name of the HSQL Development Group nor the names of its
15  * contributors may be used to endorse or promote products derived from this
16  * software without specific prior written permission.
17  *
18  * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
19  * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
20  * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
21  * ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
22  * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
23  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
24  * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
25  * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
26  * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
27  * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
28  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
29  */

30
31
32 package org.hsqldb.test;
33
34 import java.sql.Connection JavaDoc;
35 import java.sql.DriverManager JavaDoc;
36 import java.sql.ResultSet JavaDoc;
37 import java.sql.Statement JavaDoc;
38
39 public class TestMultipleConnections {
40
41     public TestMultipleConnections() {}
42
43     public static void main(String JavaDoc[] args) throws Exception JavaDoc {
44
45         // test for bug itme 500105 commit does not work with multiple con. FIXED
46
TestMultipleConnections hs = new TestMultipleConnections();
47         Connection JavaDoc con1 = hs.createObject();
48         Connection JavaDoc con2 = hs.createObject();
49         Connection JavaDoc con3 = hs.createObject();
50
51         con1.setAutoCommit(false);
52
53         //connection1.commit();
54
con2.setAutoCommit(false);
55
56         //connection1.commit();
57
con3.setAutoCommit(false);
58
59         //connection1.commit();
60
Statement JavaDoc st = con3.createStatement();
61
62         st.execute("DROP TABLE T IF EXISTS");
63         st.execute("CREATE TABLE T (I INT)");
64         st.execute("INSERT INTO T VALUES (2)");
65
66         ResultSet JavaDoc rs = st.executeQuery("SELECT * FROM T");
67
68         rs.next();
69
70         int value = rs.getInt(1);
71
72         con2.commit();
73         con3.commit();
74         con1.commit();
75
76         rs = st.executeQuery("SELECT * FROM T");
77
78         rs.next();
79
80         if (value != rs.getInt(1)) {
81             throw new Exception JavaDoc("value doesn't exist");
82         }
83     }
84
85     /**
86      * create a connection and wait
87      */

88     protected Connection JavaDoc createObject() {
89
90         try {
91             Class.forName("org.hsqldb.jdbcDriver");
92
93             return DriverManager.getConnection("jdbc:hsqldb:/hsql/test/test",
94                                                "sa", "");
95         } catch (Exception JavaDoc ex) {
96             ex.printStackTrace();
97         }
98
99         return null;
100     }
101 }
102
Popular Tags