BootstrapDBTimedQuery.java

package com.linkedin.databus.bootstrap.common;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/*
*
* Copyright 2013 LinkedIn Corp. All rights reserved
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*   http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied.  See the License for the
* specific language governing permissions and limitations
* under the License.
*
*/


/**
 *
 * Implement DB query with timeout. The expectation is that the
 * query throws MySQLTimeoutException if _queryTimeoutInSec is exceeded
 */
public class BootstrapDBTimedQuery
{
    private final PreparedStatement _stmt;
    private final int _queryTimeoutInSec;

    public BootstrapDBTimedQuery(PreparedStatement stmt)
    {
        this (stmt,0);
    }

    public BootstrapDBTimedQuery(PreparedStatement stmt,int queryTimeoutInSec)
    {
        _stmt = stmt;
        _queryTimeoutInSec = queryTimeoutInSec;
    }

    public ResultSet executeQuery() throws SQLException
    {
       if (_queryTimeoutInSec >= 0)
       {
           _stmt.setQueryTimeout(_queryTimeoutInSec);
       }
       return _stmt.executeQuery();
    }

}