@Transactional( value = "txManager",rollbackFor = Exception.class)
    public void updateBatch(String[] sql, String tableId) {
        Connection connection = AppDBContext.getWCon(tableId);
        if(connection == null ){
            throw new DaoException("get connection error ");
        }
        Statement statement = null;
        try {
             statement = connection.createStatement();

            for (String s : sql) {
                statement.addBatch(s);

            }
            statement.executeBatch();
        } catch (SQLException e) {
        	
        	String msg = "sql=" +Arrays.toString(sql);
        	if (msg.length() > 2000) {
        		msg = msg.substring(0, 2000);
        	}
        	
            log.error("batch insert error" + e.getMessage() + ", tableId=" + tableId +  ", " + msg, e);
            try {
                connection.rollback();
            } catch (SQLException e1) {
                log.error("rollback error" + e1.getMessage(), e);
            }
            throw new DaoException("batch insert error ", e);

        } finally {
            DBUtil.closeSt(statement);
        }

    }