Package java.sql

Examples of java.sql.CallableStatement.executeBatch()

811
812
813
814
815
816
817
818
819
820
821
        System.out.println("Callable Statement Test failed");
      }
      catch(SQLException e) { }

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

      try {
View Full Code Here
380
381
382
383
384
385
386
387
388
389
390
    call.addBatch();
    call.setInt(1, 2);
    call.addBatch();
    call.setInt(1, 3);
    call.addBatch();
    call.executeBatch();
    call.close();

    Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT id FROM int_table ORDER BY id");
    assertTrue(rs.next());
View Full Code Here
800
801
802
803
804
805
806
807
808
809
810
        System.out.println("Callable Statement Test failed");
      }
      catch(SQLException e) { }

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

      try {
View Full Code Here
728
729
730
731
732
733
734
735
736
737
738
        cstmt.addBatch();

        int[] updateCount=null;

        try {
            updateCount = cstmt.executeBatch();
            fail("Expected batchExecute to fail");
        } catch (BatchUpdateException b) {

            if (usingEmbedded()) {
                assertSQLState("38000", b.getSQLState(), b);
View Full Code Here
642
643
644
645
646
647
648
649
650
651
652
        for (int i = 0; i < isoLevels.length; ++i) {
            cs.setInt(1, isoLevels[i].getIsoLevel());
            cs.addBatch();
        }
        try {
            cs.executeBatch();
        } catch (SQLException e) {
            SQLException prev = e;
            while (e != null) {
                prev = e;
                e = e.getNextException();
View Full Code Here
661
662
663
664
665
666
667
668
669
670
671
        for (int i = 0; i < isoLevels.length; ++i) {
            cs.setString(1, isoLevels[i].getSqlName());
            cs.addBatch();
        }
        try {
            cs.executeBatch();
        } catch (SQLException e) {
            SQLException prev = e;
            while (e != null) {
                prev = e;
                e = e.getNextException();
View Full Code Here
667
668
669
670
671
672
673
674
675
676
677
        cstmt.setInt(2,50);
        cstmt.addBatch();

        int[] updateCount=null;
        try {
            updateCount = cstmt.executeBatch();
            assertEquals("updateCount length", 4, updateCount.length);

            for(int i=0; i< updateCount.length; i++){
                if (usingEmbedded()) {
                    assertEquals("Batch updateCount", 0, updateCount[0]);
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
      for (int i = 0; i < numBatches; i++) {
        storedProc.setInt(1, i + 1);
        storedProc.addBatch();
      }
     
      int[] counts = storedProc.executeBatch();
     
      assertEquals(numBatches, counts.length);
     
      for (int i = 0; i < numBatches; i++) {
        assertEquals(1, counts[i]);
View Full Code Here
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
    try {
      cStmt = noProcedureBodiesConn
          .prepareCall("{CALL sp_testBug28689(?)}");
      cStmt.setInt(1, 1);
      cStmt.addBatch();
      cStmt.executeBatch();

      assertEquals("BBBBBB", getSingleIndexedValueWithQuery(
          noProcedureBodiesConn, 1,
          "SELECT `usuario` FROM testBug28689 WHERE id=1"));
    } finally {
View Full Code Here
1655
1656
1657
1658
1659
1660
1661
1662
1663
1664
1665
    CallableStatement cstmt = c.prepareCall("{call pTestBug49831(?)}");
    cstmt.setObject(1, "abc", Types.VARCHAR, 32);
    cstmt.addBatch();
    cstmt.setObject(1, "def", Types.VARCHAR, 32);
    cstmt.addBatch();
    cstmt.executeBatch();
    assertEquals(2, getRowCount("testBug49831"));
    this.rs = this.stmt.executeQuery("SELECT * from testBug49831 ORDER BY VAL ASC");
    this.rs.next();
    assertEquals("abc", this.rs.getString(1));
    this.rs.next();
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.