|
HSQLDB example source code file (TestStoredProcedure.java)
The HSQLDB TestStoredProcedure.java source code/* Copyright (c) 2001-2008, The HSQL Development Group * All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, this * list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * * Neither the name of the HSQL Development Group nor the names of its * contributors may be used to endorse or promote products derived from this * software without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE * ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG, * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. */ package org.hsqldb.test; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import junit.framework.TestCase; import junit.framework.TestResult; /** * Tests for stored procedures. * * @author fredt@users * @version 1.7.2 * @since 1.7.2 */ public class TestStoredProcedure extends TestBase { public TestStoredProcedure(String name) { super(name); } public void test() throws Exception { Connection conn = newConnection(); Statement statement; int updateCount; try { statement = conn.createStatement(); ResultSet rs = statement.executeQuery( "call \"org.hsqldb.test.TestStoredProcedure.procTest1\"()"); rs.next(); int cols = rs.getInt(1); assertTrue("test result not correct", cols == 2); } catch (Exception e) { assertTrue("unable to execute call to procedure", false); } finally { conn.close(); } conn = newConnection(); try { statement = conn.createStatement(); } catch (Exception e) { assertTrue("unexpected error", false); } finally { conn.close(); } } public static int procTest1(Connection conn) throws java.sql.SQLException { int cols; java.sql.Statement stmt = conn.createStatement(); stmt.execute("CREATE temp TABLE MYTABLE(COL1 INTEGER,COL2 VARCHAR(100));"); stmt.execute("INSERT INTO MYTABLE VALUES (1,'test1');"); stmt.execute("INSERT INTO MYTABLE VALUES(2,'test2');"); java.sql.ResultSet rs = stmt.executeQuery("select * from MYTABLE"); java.sql.ResultSetMetaData meta = rs.getMetaData(); cols = meta.getColumnCount(); rs.close(); stmt.close(); return cols; } public static void main(String[] args) throws Exception { TestResult result; TestCase test; java.util.Enumeration failures; int count; result = new TestResult(); test = new TestStoredProcedure("test"); test.run(result); count = result.failureCount(); System.out.println("TestStoredProcedure failure count: " + count); failures = result.failures(); while (failures.hasMoreElements()) { System.out.println(failures.nextElement()); } } } Other HSQLDB examples (source code examples)Here is a short list of links related to this HSQLDB TestStoredProcedure.java source code file: |
... this post is sponsored by my books ... | |
#1 New Release! |
FP Best Seller |
Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.
A percentage of advertising revenue from
pages under the /java/jwarehouse
URI on this website is
paid back to open source projects.