ee.jakarta.tck.concurrent.common.transaction.Counter Maven / Gradle / Ivy

Go to download
/*
 * Copyright (c) 2013, 2023 Oracle and/or its affiliates. All rights reserved.
 *
 * This program and the accompanying materials are made available under the
 * terms of the Eclipse Public License v. 2.0, which is available at
 * http://www.eclipse.org/legal/epl-2.0.
 *
 * This Source Code may also be made available under the following Secondary
 * Licenses when the conditions for such availability set forth in the
 * Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
 * version 2 with the GNU Classpath Exception, which is available at
 * https://www.gnu.org/software/classpath/license.html.
 *
 * SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0
 */
package ee.jakarta.tck.concurrent.common.transaction;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

public final class Counter {
    
    private Counter() {
        //utility class
    }

    /**
     * Get count of rows in test table to verify if a transaction was committed or
     * rolled back.
     *
     * @return number of rows, or -1 if error occurred while attempting to access
     *         table.
     */
    public static int getCount() {
        try (Connection conn = Connections.getConnection(true);) {
            return getCount(conn);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return -1;
    }

    private static int getCount(final Connection conn) {
        final String queryStr = "select count(*) from " + Constants.TABLE_P;

        try (Statement stmt = conn.createStatement()) {
            ResultSet rs = stmt.executeQuery(queryStr);
            if (rs.next()) {
                return rs.getInt(1);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        return -1;
    }

}