DsUtil.java

package org.jboss.as.test.integration.jca.reauth;

import static org.junit.Assert.assertTrue;
import static org.junit.Assert.fail;

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

public class DsUtil {
    public static void testConnection(Connection con, String query, String resultContains) {
        String result = null;
        Statement st = null;
        ResultSet rs = null;

        try {
            st = con.createStatement();
            rs = st.executeQuery(query);
            if (rs != null && rs.next()) { result = rs.getString(1); }
        } catch (Throwable t) {
            fail("it's impossible to execute query:" + query);
            t.printStackTrace();
        } finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException ignore) {
                    // Ignore
                }
            }
            if (st != null) {
                try {
                    st.close();
                } catch (SQLException ignore) {
                    // Ignore
                }
            }

        }

        assertTrue("result='" + result + "', but must contain '" + resultContains + "' substring",
                result.indexOf(resultContains) >= 0);

    }
}