Package java.sql

Examples of java.sql.CallableStatement.clearParameters()

2977
2978
2979
2980
2981
2982
2983
2984
2985
2986
2987
    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
2988
2989
2990
2991
2992
2993
2994
2995
2996
2997
2998
    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
2999
3000
3001
3002
3003
3004
3005
3006
3007
3008
3009
    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
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
434
435
436
437
438
439
440
441
442
443
444
      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
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
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
677
678
679
680
681
682
683
684
685
686
687
      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.