Package java.sql

Examples of java.sql.CallableStatement.clearParameters()

1738
1739
1740
1741
1742
1743
1744
1745
1746
1747
1748
        } 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
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
        } 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
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
                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
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
            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
2982
2983
2984
2985
2986
2987
2988
2989
2990
2991
2992
    cStmt.setInt(1, 5);
    cStmt.registerOutParameter(2, Types.INTEGER);

    cStmt.execute();
    assertEquals(6, cStmt.getInt(2));
    cStmt.clearParameters();
        cStmt.close();
       
        conn1.setCatalog("mysql");
        cStmt = null;
    cStmt = conn1.prepareCall("{call `TST1`.`PROC`(?, ?)}");
View Full Code Here
2993
2994
2995
2996
2997
2998
2999
3000
3001
3002
3003
    cStmt.setInt(1, 5);
    cStmt.registerOutParameter(2, Types.INTEGER);

    cStmt.execute();
    assertEquals(6, cStmt.getInt(2));
    cStmt.clearParameters();
        cStmt.close();
   
    this.stmt = savedSt;
  }
 
View Full Code Here
2971
2972
2973
2974
2975
2976
2977
2978
2979
2980
2981
    cStmt.setInt(1, 5);
    cStmt.registerOutParameter(2, Types.INTEGER);

    cStmt.execute();
    assertEquals(6, cStmt.getInt(2));
    cStmt.clearParameters();
    cStmt.close();
       
        conn1.setCatalog("TST1");
        cStmt = null;
    cStmt = conn1.prepareCall("{call TST1.PROC(?, ?)}");
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
            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
503
504
505
506
507
508
509
510
511
512
513
     
        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
735
736
737
738
739
740
741
742
743
744
745
    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
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.