KickJava   Java API By Example, From Geeks To Geeks.

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


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.ResultSet JavaDoc;
36 import java.sql.Statement JavaDoc;
37
38 import junit.framework.TestCase;
39 import junit.framework.TestResult;
40
41 /**
42  * Tests for stored procedures.
43  *
44  * @author fredt@users
45  * @version 1.7.2
46  * @since 1.7.2
47  */
48 public class TestStoredProcedure extends TestBase {
49
50     public TestStoredProcedure(String JavaDoc name) {
51         super(name);
52     }
53
54     public void test() throws Exception JavaDoc {
55
56         Connection JavaDoc conn = newConnection();
57         Statement JavaDoc statement;
58         int updateCount;
59
60         try {
61             statement = conn.createStatement();
62
63             ResultSet JavaDoc rs = statement.executeQuery(
64                 "call \"org.hsqldb.test.TestStoredProcedure.procTest1\"()");
65
66             rs.next();
67
68             int cols = rs.getInt(1);
69
70             assertTrue("test result not correct", cols == 2);
71         } catch (Exception JavaDoc e) {
72             assertTrue("unable to execute call to procedure", false);
73         } finally {
74             conn.close();
75         }
76
77         conn = newConnection();
78
79         try {
80             statement = conn.createStatement();
81         } catch (Exception JavaDoc e) {
82             assertTrue("unexpected error", false);
83         } finally {
84             conn.close();
85         }
86     }
87
88     public static int procTest1(Connection JavaDoc conn)
89     throws java.sql.SQLException JavaDoc {
90
91         int cols;
92         java.sql.Statement JavaDoc stmt = conn.createStatement();
93
94         stmt.execute("CREATE temp TABLE MYTABLE(COL1 INTEGER,COL2 VARCHAR);");
95         stmt.execute("INSERT INTO MYTABLE VALUES (1,'test1');");
96         stmt.execute("INSERT INTO MYTABLE VALUES(2,'test2');");
97
98         java.sql.ResultSet JavaDoc rs = stmt.executeQuery("select * from MYTABLE");
99         java.sql.ResultSetMetaData JavaDoc meta = rs.getMetaData();
100
101         cols = meta.getColumnCount();
102
103         rs.close();
104         stmt.close();
105
106         return cols;
107     }
108
109     public static void main(String JavaDoc[] args) throws Exception JavaDoc {
110
111         TestResult result;
112         TestCase test;
113         java.util.Enumeration JavaDoc failures;
114         int count;
115
116         result = new TestResult();
117         test = new TestStoredProcedure("test");
118
119         test.run(result);
120
121         count = result.failureCount();
122
123         System.out.println("TestStoredProcedure failure count: " + count);
124
125         failures = result.failures();
126
127         while (failures.hasMoreElements()) {
128             System.out.println(failures.nextElement());
129         }
130     }
131 }
132
Popular Tags