Examples of java.sql.Statement.addBatch()

java.sql.Statement.addBatch()
Adds a specified SQL commands to the list of commands for this Statement.
The list of commands is executed by invoking the executeBatch method. @param sql the SQL command as a String. Typically an INSERT or UPDATE statement. @throws SQLException if an error occurs accessing the database or the database does not support batch updates

    String inserttable = "insert into tab1 values(2, 'STRING_2')";
    System.out.println("doing: " + inserttable);
    stmt.addBatch(inserttable);
    inserttable = "insert into tab1 values(3, 'STRING_3')";
    System.out.println("doing: " + inserttable);
    stmt.addBatch(inserttable);
    inserttable = "insert into tab1 values(5, 'STRING_5')";
    System.out.println("doing: " + inserttable);
    stmt.addBatch(inserttable);
    inserttable = "select * from tab1";
    System.out.println("adding: " + inserttable);

View Full Code Here

    inserttable = "insert into tab1 values(3, 'STRING_3')";
    System.out.println("doing: " + inserttable);
    stmt.addBatch(inserttable);
    inserttable = "insert into tab1 values(5, 'STRING_5')";
    System.out.println("doing: " + inserttable);
    stmt.addBatch(inserttable);
    inserttable = "select * from tab1";
    System.out.println("adding: " + inserttable);
    stmt.addBatch(inserttable);


    int[] updateCount=null;

View Full Code Here

    inserttable = "insert into tab1 values(5, 'STRING_5')";
    System.out.println("doing: " + inserttable);
    stmt.addBatch(inserttable);
    inserttable = "select * from tab1";
    System.out.println("adding: " + inserttable);
    stmt.addBatch(inserttable);


    int[] updateCount=null;
    try {
      updateCount = stmt.executeBatch();
    } catch(SQLException se) {

View Full Code Here

                final String[] ddls = ddlString.split(";");




                batchDDLStatement = connection.createStatement();
                for (final String ddlEntry : ddls) {
                    batchDDLStatement.addBatch(ddlEntry);
                }
                batchDDLStatement.executeBatch();
            } catch (Exception sqlException) {
                throw BatchMessages.MESSAGES.failToCreateTables(sqlException, ddlFile, ddlString);
            }

View Full Code Here

  void runBatch(List<String> statements) {
    try {
      Statement stmnt = createStatement();
      try {
        for (Iterator<String> i = statements.iterator(); i.hasNext();) {
          stmnt.addBatch(i.next().toString());
        }
        int[] counts = stmnt.executeBatch();


        output(getColorBuffer().pad(getColorBuffer().bold("COUNT"), 8)
            .append(getColorBuffer().bold("STATEMENT")));

View Full Code Here

            {
              // ignore the error, HSQL sucks
            }
            else
            {
              statement.addBatch(StringEscapeUtils.unescapeJava(line));
            }
          }
          statement.executeBatch();
        }
        finally

View Full Code Here

    /** Test 15 Check savepoints in batch */
    public void testSavepointsInBatch() throws SQLException {
        Connection con = getConnection();
        Statement s = createStatement();
        s.execute("delete from t1");
        s.addBatch("insert into t1 values(1,1)");
        s.addBatch("insert into t1 values(2,2)");
        Savepoint savepoint1 = con.setSavepoint();
        s.addBatch("insert into t1 values(3,3)");
        s.executeBatch();
        con.rollback(savepoint1);

View Full Code Here

    public void testSavepointsInBatch() throws SQLException {
        Connection con = getConnection();
        Statement s = createStatement();
        s.execute("delete from t1");
        s.addBatch("insert into t1 values(1,1)");
        s.addBatch("insert into t1 values(2,2)");
        Savepoint savepoint1 = con.setSavepoint();
        s.addBatch("insert into t1 values(3,3)");
        s.executeBatch();
        con.rollback(savepoint1);

View Full Code Here

        Statement s = createStatement();
        s.execute("delete from t1");
        s.addBatch("insert into t1 values(1,1)");
        s.addBatch("insert into t1 values(2,2)");
        Savepoint savepoint1 = con.setSavepoint();
        s.addBatch("insert into t1 values(3,3)");
        s.executeBatch();
        con.rollback(savepoint1);


        assertTableRowCount("T1", 0);
        con.rollback();

View Full Code Here

        continue;
      }


      sqlQuery = conn.expandQuery(sqlQuery + ";");


      s.addBatch(sqlQuery);
    }
    s.executeBatch();
  }


  protected final void deployTables() throws PermissionBackendException {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.