Package java.sql

Examples of java.sql.CallableStatement.clearParameters()

433
434
435
436
437
438
439
440
441
442
443
      int indexedOutParamToTest = storedProc.getInt(2);

      assertTrue("Output value not returned correctly",
          indexedOutParamToTest == 6);

      storedProc.clearParameters();
      storedProc.setInt(1, 32);
      storedProc.registerOutParameter(2, Types.INTEGER);

      storedProc.execute();
View Full Code Here
841
842
843
844
845
846
847
848
849
850
851
        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
659
660
661
662
663
664
665
666
667
668
669
      catch(SQLException e) {
        System.out.println("Callable Statement Test failed");
      }

      try {
        cs.clearParameters();
        System.out.println("Callable Statement Test failed");
      }
      catch(SQLException e) { }

      try {
View Full Code Here
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
      cs.registerOutParameter(2, Types.INTEGER);
      cs.setInt(1, i);
      cs.execute();
      assertEquals(1, cs.getInt(1));
      assertEquals(i, cs.getInt(2));
      cs.clearParameters();
    }
    cs.close();
  }

  @Test
View Full Code Here
642
643
644
645
646
647
648
649
650
651
652
      catch(SQLException e) {
        System.out.println("Callable Statement Test failed");
      }

      try {
        cs.clearParameters();
        System.out.println("Callable Statement Test failed");
      }
      catch(SQLException e) { }

      try {
View Full Code Here
1615
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625
            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
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.