com.hangum.tadpole.rdb.core.util.bander.oracle.OracleExecutePlanUtils.java Source code

Introduction

Here is the source code for com.hangum.tadpole.rdb.core.util.bander.oracle.OracleExecutePlanUtils.java

Source

/*******************************************************************************
 * Copyright (c) 2013 hangum.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the GNU Lesser Public License v2.1
 * which accompanies this distribution, and is available at
 * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
 * 
 * Contributors:
 *     hangum - initial API and implementation
 ******************************************************************************/
package com.hangum.tadpole.rdb.core.util.bander.oracle;

import java.sql.PreparedStatement;

import org.apache.commons.lang.StringUtils;

import com.hangum.tadpold.commons.libs.core.define.PublicTadpoleDefine;
import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;
import com.hangum.tadpole.engine.sql.util.PartQueryUtil;

/**
 * oracle execute plan
 * 
 * @author hangum
 *
 */
public class OracleExecutePlanUtils {

    /**
     * oracle query plan? . 
     * 
     * @param userDB
     * @param sql
     * @param planTableName
     * @throws Exception
     */
    public static void plan(UserDBDAO userDB, String sql, String planTableName, java.sql.Connection javaConn,
            PreparedStatement stmt, String statement_id) throws Exception {
        //java.sql.Connection javaConn = null;
        //PreparedStatement stmt = null;
        //ResultSet rs = null;

        try {
            //SqlMapClient client = TadpoleSQLManager.getInstance(userDB);
            //javaConn = client.getDataSource().getConnection();

            String query = PartQueryUtil.makeExplainQuery(userDB, sql);
            query = StringUtils.replaceOnce(query, PublicTadpoleDefine.STATEMENT_ID, statement_id);
            query = StringUtils.replaceOnce(query, PublicTadpoleDefine.DELIMITER, planTableName);

            stmt = javaConn.prepareStatement(query);
            //stmt = javaConn.prepareStatement( StringUtils.replaceOnce(PartQueryUtil.makeExplainQuery(userDB,  sql), PublicTadpoleDefine.DELIMITER, planTableName));
            stmt.execute();

        } finally {
            //if(rs != null) rs.close();
            //if(stmt != null) stmt.close();
            //if(javaConn != null) javaConn.close();
        }

    }
}