Package java.sql

Examples of java.sql.CallableStatement.executeBatch()

1679
1680
1681
1682
1683
1684
1685
1686
1687
1688
1689
       
        cStmt.setInt(1, 2048);
        cStmt.addBatch();
       
        try {
          cStmt.executeBatch();
        } catch (BatchUpdateException bUpE) {
          int[] counts = bUpE.getUpdateCounts();
 
          for (int i = 4093; i < counts.length; i++) {
            assertEquals(counts[i], Statement.EXECUTE_FAILED);
View Full Code Here
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
    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));
View Full Code Here
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
    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"));
View Full Code Here
655
656
657
658
659
660
661
662
663
664
665
        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
716
717
718
719
720
721
722
723
724
725
726
        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
656
657
658
659
660
661
662
663
664
665
666
        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
717
718
719
720
721
722
723
724
725
726
727
        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
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
    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"));
View Full Code Here
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
    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));
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
      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
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.