Package java.sql

Examples of java.sql.CallableStatement.clearParameters()

2969
2970
2971
2972
2973
2974
2975
2976
2977
2978
2979
    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
2980
2981
2982
2983
2984
2985
2986
2987
2988
2989
2990
    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
2991
2992
2993
2994
2995
2996
2997
2998
2999
3000
3001
    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
732
733
734
735
736
737
738
739
740
741
742
    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
199
200
201
202
203
204
205
206
207
208
209
            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
500
501
502
503
504
505
506
507
508
509
510
     
        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
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.