Package java.sql

Examples of java.sql.CallableStatement.clearParameters()

838
839
840
841
842
843
844
845
846
847
848
        cs.execute();
        assertEquals(10, cs.getInt(1));

        // After clearing the parameters, execution should fail. Client used
        // to succeed.
        cs.clearParameters();
        assertStatementError("07000", cs);

        // Setting the parameter again should make it work.
        cs.setInt(1, 1);
        cs.execute();
View Full Code Here
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
            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
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
        } 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
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
            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
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
            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
734
735
736
737
738
739
740
741
742
743
744
    cstmt.registerOutParameter(1, Types.INTEGER);
    cstmt.execute();
    assertEquals(1, cstmt.getInt(1));

    if (!isRunningOnJdk131()) {
      cstmt.clearParameters();
      cstmt.registerOutParameter("param2", Types.INTEGER);
      cstmt.execute();
      assertEquals(1, cstmt.getInt(1));
    }
View Full Code Here
1847
1848
1849
1850
1851
1852
1853
1854
1855
1856
1857
      cStmt.setInt(1, 5);
      cStmt.registerOutParameter(2, Types.INTEGER);

      cStmt.execute();
      assertEquals(6, cStmt.getInt(2));
      cStmt.clearParameters();
      cStmt.close();

      this.conn.setCatalog("bug57022");
      cStmt = this.conn.prepareCall("{call bug57022.procbug57022(?, ?)}");
      cStmt.setInt(1, 5);
View Full Code Here
1857
1858
1859
1860
1861
1862
1863
1864
1865
1866
1867
      cStmt.setInt(1, 5);
      cStmt.registerOutParameter(2, Types.INTEGER);

      cStmt.execute();
      assertEquals(6, cStmt.getInt(2));
      cStmt.clearParameters();
      cStmt.close();

      this.conn.setCatalog("mysql");
      cStmt = this.conn
          .prepareCall("{call `bug57022`.`procbug57022`(?, ?)}");
View Full Code Here
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
      cStmt.registerOutParameter(2, Types.INTEGER);

      cStmt.execute();
      assertEquals(6, cStmt.getInt(2));
    } finally {
      cStmt.clearParameters();
      cStmt.close();
      this.conn.setCatalog(originalCatalog);
    }

  }
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
            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
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.