KickJava   Java API By Example, From Geeks To Geeks.

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


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.Statement JavaDoc;
36
37 import junit.framework.TestCase;
38 import junit.framework.TestResult;
39
40 /**
41  * HSQLDB TestBug808460 Junit test case. <p>
42  *
43  * @author boucherb@users
44  * @version 1.7.2
45  * @since 1.7.2
46  */
47 public class TestBug808460 extends TestBase {
48
49     public TestBug808460(String JavaDoc name) {
50         super(name);
51     }
52
53     /* Implements the TestBug808460 test */
54     public void test() throws Exception JavaDoc {
55
56         Connection JavaDoc conn = newConnection();
57         Statement JavaDoc stmt = conn.createStatement();
58
59         stmt.executeQuery("SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS");
60         conn.close();
61
62         conn = newConnection();
63         stmt = conn.createStatement();
64
65         stmt.executeQuery("SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS");
66         conn.close();
67     }
68
69     /* Runs TestBug808460 test from the command line*/
70     public static void main(String JavaDoc[] args) throws Exception JavaDoc {
71
72         TestResult result;
73         TestCase test;
74         java.util.Enumeration JavaDoc failures;
75         int count;
76
77         result = new TestResult();
78         test = new TestBug808460("test");
79
80         test.run(result);
81
82         count = result.failureCount();
83
84         System.out.println("TestBug808460 failure count: " + count);
85
86         failures = result.failures();
87
88         while (failures.hasMoreElements()) {
89             System.out.println(failures.nextElement());
90         }
91     }
92 }
93
Popular Tags