Examples of java.sql.PreparedStatement.addBatch()

java.sql.PreparedStatement.addBatch()
Add a set of parameters to the PreparedStatement's command batch. @throws SQLException if a database error happens

            
            psUpdateReference.setLong(3, channelID);
            
            if (usingBatchUpdates)
            {
               psUpdateReference.addBatch();
            }
            else
            {
               int rows = updateWithRetry(psUpdateReference);

View Full Code Here

            removeMessage(m, psDeleteMessage);
                       
            if (batch)
            {
               psDecMessage.addBatch();
               psDeleteMessage.addBatch();
            }
            else
            {
               int rows = updateWithRetry(psDecMessage);
               if (trace) { log.trace("Updated " + rows + " rows"); }

View Full Code Here

                           
            if (batch)
            {
               psUpdateMessage.addBatch();
                
               psDeleteMessage.addBatch(); 
            }
            else
            {
               int rows = updateWithRetry(psUpdateMessage);

View Full Code Here

                  psInsertMessage.addBatch();
                  messageInsertsInBatch = true;
               }
               else
               {
                  psUpdateMessage.addBatch();
                  messageUpdatesInBatch = true;
               }
            }
            else
            {

View Full Code Here

            
            removeMessage(m, psDeleteMessage);
                                        
            if (batch)
            {
               psUpdateMessage.addBatch();
               
               psDeleteMessage.addBatch();
            }
            else
            {

View Full Code Here

            ps.setInt(1, i);
            ps.setString(2, "text "+String.valueOf(i));
            ps.setTimestamp(3, new Timestamp(Calendar.getInstance().getTimeInMillis()));
            ps.setBytes(4, b);
            
            ps.addBatch();
        }
        
        //executing the batch...
        ps.executeBatch();

View Full Code Here

              ps.setInt(1, id);
              ps.setString(2, "text "+String.valueOf(id));
              ps.setTimestamp(3, new Timestamp(Calendar.getInstance().getTimeInMillis()));
              ps.setBytes(4, b);
              
              ps.addBatch();
              
              id += 1;
          }
          
          //executing the batch...

View Full Code Here

        sql   = "insert into test values(?)";
        pstmt = conn.prepareStatement(sql);


        for (int i = 0; i < 10; i++) {
            pstmt.setInt(1, i);
            pstmt.addBatch();
        }


        pstmt.executeBatch();


        //

View Full Code Here

            //we insert 1001
            for (int i = 0; i < 1001; i++) {
                pst.setString(1, "string_" + i);
                pst.setInt(2, i);
                pst.setString(3, "string2_" + i);
                pst.addBatch();


                if ((i > 0) && (i % 100 == 0)) {
                    pst.executeBatch();
                }
            }

View Full Code Here


        for (int ii = 0; ii < DECIMAL_FIELDS_PER_DATASET; ii++) {
            prep.setDouble(ii + 3, 0.123456789);    // Wert
        }


        prep.addBatch();
        prep.setString(1, "yyy");
        prep.setTimestamp(2, now);    // last_update


        for (int ii = 0; ii < DECIMAL_FIELDS_PER_DATASET; ii++) {
            prep.setDouble(ii + 3, 0.123456789);    // Wert

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.