List of executeBatch() Examples

Examples of executeBatch()

com.alibaba.druid.support.ibatis.SqlMapClientWrapper.executeBatch()
com.alibaba.druid.support.ibatis.SqlMapExecutorWrapper.executeBatch()
com.asakusafw.yaess.core.task.ExecutionTask.executeBatch()
Executes a target flow. If execution is failed except on {@link ExecutionPhase#SETUP setup}, {@link ExecutionPhase#FINALIZE finalize}, or {@link ExecutionPhase#CLEANUP cleanup}, then the {@code finalize} phase will be executed for recoverybefore the target flow execution is aborted. Execution ID for each flow will automatically generated. @param batchId target batch ID @throws InterruptedException if interrupted during this execution @throws IOException if failed to execute target batch @throws IllegalArgumentException if some parameters were {@code null}
de.danet.an.workflow.api.WorkflowService.executeBatch()
Execute a batch in the context of the workflow service i.e. on the server.
We do not want to define a specific mechanism for implementing the remote invocation mechanism used with the workflow API. Yet it is obvious that any implementation can profit from the possibility to execute several actions as one call to the server. @param batch the batch to be executed. @return the result returned by {@link Batch#execute Batch.execute}. @throws RemoteException if a system-level error occurs. @throws InvocationTargetException if thrown by {@link Batch#execute Batch.execute}
java.sql.CallableStatement.executeBatch()
java.sql.PreparedStatement.executeBatch()
java.sql.Statement.executeBatch()
Submits a batch of SQL commands to the database. Returns an array of update counts, if all the commands execute successfully.
If one of the commands in the batch fails, this method can throw a BatchUpdateException and the JDBC driver may or may not process the remaining commands. The JDBC driver must behave consistently with the underlying database, either always continuing or never continuing. If the driver continues processing, the array of results returned contains the same number of elements as there are commands in the batch, with a minimum of one of the elements having the EXECUTE_FAILED value. @return an array of update counts, with one entry for each command in thebatch. The elements are ordered according to the order in which the commands were added to the batch.
1. If the value of an element is >=0, the corresponding command completed successfully and the value is the update count for that command, which is the number of rows in the database affected by the command.
2. If the value is SUCCESS_NO_INFO, the command completed successfully but the number of rows affected is unknown.
4. If the value is EXECUTE_FAILED, the command failed.
@throws SQLException if an error occurs accessing the database
l2p.database.FiltredStatement.executeBatch()
org.apache.ojb.broker.accesslayer.ConnectionManagerIF.executeBatch()
Execute batch (if the batch mode where used).
org.apache.olingo.odata2.api.processor.part.BatchProcessor.executeBatch()
Executes a OData batch request and provide Batch Response as {@link ODataResponse} @param handler batch handler @param contentType the content type of the request @param content Batch Request body @return a {@link ODataResponse} object @throws ODataException
org.apache.pig.PigServer.executeBatch()
Submits a batch of Pig commands for execution. @throws FrontendException @throws ExecException
org.dbunit.database.statement.IBatchStatement.executeBatch()
org.dbunit.database.statement.IPreparedBatchStatement.executeBatch()
org.fto.jthink.jdbc.SQLExecutor.executeBatch()
批量执行SQL, 注意:有的JDBC驱动对批量处理不支持事务，比如微软的MSSQL JDBC驱动！衰 @param sqls SQL语句数组 @return 更新计数所组成的数组
org.sql2o.Query.executeBatch()

Examples of java.sql.PreparedStatement.executeBatch()

            prep.setDouble(ii + 3, 0.123456789);    // Wert
        }


        prep.addBatch();


        int[] updateCounts = prep.executeBatch();


        con.setAutoCommit(true);
        prep.close();
    }

View Full Code Here

Examples of java.sql.PreparedStatement.executeBatch()


            for (int i = 1; i <= 4; i++) {    // [2, 3, 4]
                prep.setInt(1, i);
                prep.addBatch();
                System.out.println("executeBatch() for " + i);
                prep.executeBatch();
                con.commit();


                // prep.clearBatch(); // -> java.lang.NullPointerException
                // at org.hsqldb.Result.getUpdateCounts(Unknown Source)
            }

View Full Code Here

Examples of java.sql.PreparedStatement.executeBatch()

        for (int i = 0; i < 10000; i++) {
            pstmt.setString(1, "name" + i);
            pstmt.addBatch();
        }


        pstmt.executeBatch();


//
        sql = "select count(*) from test where name = (select max(name) from empty)";
        rs = stmt.executeQuery(sql);

View Full Code Here

Examples of java.sql.PreparedStatement.executeBatch()

            ps.setLong(2, 23456789123458L);
            ps.setCharacterStream(3, reader, 100);
            ps.setString(4, "test-scope-3");
            ps.addBatch();


            int[] results = ps.executeBatch();


            //
            try {
                InputStream fis =
                    getClass().getResourceAsStream(resourceFileName);

View Full Code Here

Examples of java.sql.PreparedStatement.executeBatch()

                throw new UnableToExecuteStatementException("Exception while binding parameters", e);
            }


            try {
                final long start = System.currentTimeMillis();
                final int[] rs =  stmt.executeBatch();
                log.logPreparedBatch(System.currentTimeMillis() - start,  rewritten.getSql(), parts.size());
                return rs;
            }
            catch (SQLException e) {
                throw new UnableToExecuteStatementException(e);

View Full Code Here

Examples of java.sql.PreparedStatement.executeBatch()

      " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);", null);


    for (SpeakerNPC npc : SingletonRepository.getNPCList()) {
      dumpNPC(stmt, npc);
    }
    stmt.executeBatch();
    logger.debug("Completed dumping of NPCs in " + (System.currentTimeMillis() - start) + " milliseconds.");
  }


  /**
   * dumps all NPCs

View Full Code Here

Examples of java.sql.PreparedStatement.executeBatch()

          for (int i = 0; i < params.length; i++) {
            adaptors[i].set(pstat, params[i], i + 1);
          }
          pstat.addBatch();// 需要配置一下batchSize,嘻嘻,不然分分钟爆内存!!
        }
        int[] counts = pstat.executeBatch();


        pstat.close();
        statIsClosed = true;
        conn.commit();
        conn.setAutoCommit(oldAutoCommit);

View Full Code Here

Examples of java.sql.PreparedStatement.executeBatch()

          ps.setInt(1, i%2);
            ps.setString(2, "Tuple " +i);
            ps.setString(3, "any value");
            ps.addBatch();
        }
        ps.executeBatch();


    s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
    
    //Executing the query below and looking at it's plan will show that
    //we picked index T2I1 rather than T2I2 because there are no

View Full Code Here

Examples of java.sql.PreparedStatement.executeBatch()

          }
          i++;
        }
        prep.addBatch();
        conn.setAutoCommit(false);
        prep.executeBatch();
        conn.commit();
        prep.close();
        prep = null;
      } catch (Throwable e) {
        if (!omitErrorLogs) {

View Full Code Here

Examples of java.sql.PreparedStatement.executeBatch()

      dataStmt.setInt(3, relLoc.getBlockZ());
      dataStmt.setString(4, block.getType().toString());
      dataStmt.setShort(5, block.getData().toItemStack().getDurability());
      dataStmt.addBatch();
      if (++changed % batchSize == 0) {
        dataStmt.executeBatch();
      }
    }
    dataStmt.executeBatch(); // insert remaining records
    databaseConnection.commit();
    databaseConnection.setAutoCommit(true);

View Full Code Here

0 1 2 3 4 5 6

TOP

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.