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

    int pointer = 0;
    int size = sqlList.size();
    int[] result = new int[size];
    Statement st = conn.createStatement();
    for (int i=0; i<size; i++) {
      st.addBatch(sqlList.get(i));
      if (++counter >= batchSize) {
        counter = 0;
        int[] r = st.executeBatch();
        conn.commit();
        for (int k=0; k<r.length; k++)

View Full Code Here

         scr = scr.replace(PASSWORD_TEMPLATE, dbPassword);


         String s = cleanWhitespaces(scr.trim());
         if (s.length() > 0)
         {
            statement.addBatch(s);
         }
      }
      statement.executeBatch();
   }

View Full Code Here

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

View Full Code Here

        s.executeUpdate("create table tmp(i int)");
        PreparedStatement ps = c.prepareStatement("insert into tmp values (?)");


        // fill batch:
        for (int i=0; i < 10; i++) {
            s.addBatch("insert into tmp values (" + i + ")");
        }


        s.executeBatch(); // should work OK, since no interrupt present


        // refill batch:

View Full Code Here


        s.executeBatch(); // should work OK, since no interrupt present


        // refill batch:
        for (int i=0; i < 10; i++) {
            s.addBatch("insert into tmp values (" + i + ")");
        }


        try {
            Thread.currentThread().interrupt();
            s.executeBatch();

View Full Code Here

            if (isComment(line))
                continue;
            queryEnds = checkStatementEnds(line);
            query.append(line);
            if (queryEnds) {
                stmt.addBatch(query.toString());
                query.setLength(0);
            }
        }
        stmt.executeBatch();

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

                conn = ds.getConnection();
                statement = conn.createStatement();


                for (Iterator i = statementList.iterator(); i.hasNext();) {
                    String sqlStatement = (String) i.next();
                    statement.addBatch(sqlStatement);
                }


                statement.executeBatch();
            }

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.