Package java.sql

Examples of java.sql.CallableStatement.clearParameters()

1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
            cs.registerOutParameter(2, Types.INTEGER);
            cs.setInt(1, i);
            cs.execute();
            assertEquals(1, cs.getInt(1));
            assertEquals(i, cs.getInt(2));
            cs.clearParameters();
        }
    }

}
View Full Code Here
1864
1865
1866
1867
1868
1869
1870
1871
1872
1873
1874
            fail("FAIL - execution ok on out of range out parameter");
        } catch (SQLException sqle) {
            assertSQLState("22003", sqle);
        }

        op.clearParameters();
        try {
            // b not set
            op.execute();

            fail("FAIL - b not set");
View Full Code Here
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
        } catch (SQLException sqle) {
            assertSQLState("22003", sqle);
        }

        // now some checks to requirements for parameter setting.
        op.clearParameters();
        try {
            // a,b not set
            op.execute();
            fail("FAIL - a,b not set");
        } catch (SQLException sqle) {
View Full Code Here
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
            op.execute();
            fail("FAIL - a,b not set");
        } catch (SQLException sqle) {
            assertSQLState("07000", sqle);
        }
        op.clearParameters();
        op.setString(2, "2");
        try {
            // a not set
            op.execute();
            fail("FAIL - a  not set");
View Full Code Here
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
            op.execute();
            fail("FAIL - a  not set");
        } catch (SQLException sqle) {
            assertSQLState("07000", sqle);
        }
        op.clearParameters();
        op.setBigDecimal(1, new BigDecimal("33"));
        try {
            // b not set
            op.execute();
            fail("FAIL - b  not set");
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
            indexedOutParamToTest == namedOutParamToTest);
        assertTrue("Output value not returned correctly",
            indexedOutParamToTest == 6);

        // Start over, using named parameters, this time
        storedProc.clearParameters();
        storedProc.setInt("x", 32);
        storedProc.registerOutParameter("y", Types.INTEGER);

        storedProc.execute();
View Full Code Here
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
            fail("FAIL - execution ok on out of range out parameter");
        } catch (SQLException sqle) {
            assertSQLState("22003", sqle);
        }

        op.clearParameters();
        try {
            // b not set
            op.execute();

            fail("FAIL - b not set");
View Full Code Here
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
        } catch (SQLException sqle) {
            assertSQLState("22003", sqle);
        }

        // now some checks to requirements for parameter setting.
        op.clearParameters();
        try {
            // a,b not set
            op.execute();
            fail("FAIL - a,b not set");
        } catch (SQLException sqle) {
View Full Code Here
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
        } catch (SQLException sqle) {
            assertSQLState("07000", sqle);
        }
        if (usingEmbedded()) {
            // Do not run for client until DERBY-2516 is fixed
            op.clearParameters();
            op.setString(2, "2");
            try {
                // a not set
                op.execute();
                fail("FAIL - a  not set");
View Full Code Here
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
                fail("FAIL - a  not set");
            } catch (SQLException sqle) {
                assertSQLState("07000", sqle);
            }
        }
        op.clearParameters();
        op.setBigDecimal(1, new BigDecimal("33"));
        try {
            // b not set
            op.execute();
            fail("FAIL - b  not set");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.