com.clustercontrol.commons.util.JdbcBatchExecutor.java Source code

Introduction

Here is the source code for com.clustercontrol.commons.util.JdbcBatchExecutor.java

Source

/*
    
Copyright (C) 2012 NTT DATA Corporation
    
This program is free software; you can redistribute it and/or
Modify it under the terms of the GNU General Public License
as published by the Free Software Foundation, version 2.
    
This program is distributed in the hope that it will be
useful, but WITHOUT ANY WARRANTY; without even the implied
warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.  See the GNU General Public License for more details.
    
 */

package com.clustercontrol.commons.util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.clustercontrol.util.HinemosTime;

/**
 * JDBC?????insert???update???
 */
public class JdbcBatchExecutor {
    private static final Log log = LogFactory.getLog(JdbcBatchExecutor.class);

    public static void execute(JdbcBatchQuery query) {
        List<JdbcBatchQuery> list = new ArrayList<JdbcBatchQuery>();
        list.add(query);
        execute(list);
    }

    /**
     * ?
     * 
     * @param query
     *            insert???update
     */
    public static void execute(List<JdbcBatchQuery> queryList) {
        Connection conn = null;
        long start = HinemosTime.currentTimeMillis();
        JpaTransactionManager tm = null;
        try {
            tm = new JpaTransactionManager();
            conn = tm.getEntityManager().unwrap(java.sql.Connection.class);
            conn.setAutoCommit(false);
            for (JdbcBatchQuery query : queryList)
                try (PreparedStatement pstmt = conn.prepareStatement(query.getSql())) {
                    query.addBatch(pstmt);
                    pstmt.executeBatch();
                }
            if (!tm.isNestedEm()) {
                conn.commit();
            }
        } catch (Exception e) {
            log.warn(e);
            if (conn != null) {
                try {
                    conn.rollback();
                } catch (SQLException e1) {
                    log.warn(e1);
                }
            }
        } finally {
            if (tm != null) {
                tm.close();
            }
        }
        long time = HinemosTime.currentTimeMillis() - start;
        String className = "";
        if (queryList.size() != 0) {
            className = queryList.get(0).getClass().getSimpleName();
        }
        String message = String.format("Execute [%s] batch: %dms. size=%d", className, time, queryList.size());
        if (time > 3000) {
            log.warn(message);
        } else if (time > 1000) {
            log.info(message);
        } else {
            log.debug(message);
        }
    }
}