Sample 0 [from 252 instances]

Class390.execute(Connection connection)#1{
                    while (testGroups.next()) {
                        testIdsStatement.setString(1, testGroups.getString(1));
                        ResultSet testExecutions = testIdsStatement.executeQuery();
                        while (testExecutions.next()) {
                            testNames.add(testExecutions.getString(1));
                        }
                        testExecutions.close();
                    }
}


Sample 1 [from 25 instances]

Class140.testMappingsWithEmbedEnumAndEnumDBTypes()#2{
        final PreparedStatement ps = connection.prepareStatement(
                "SELECT 'VALUE_1'::enumeration as a, 'VALUE_2'::enumeration as b, 'str' as str");
        final ResultSet rs = ps.executeQuery();
}


Sample 2 [from 23 instances]

Class400.testAmbiguousColumn()#1{
        Properties props = new Properties(TEST_PROPERTIES);
        Connection conn = DriverManager.getConnection(url, props);
            PreparedStatement statement = conn.prepareStatement(query);
            statement.executeQuery();
}


Sample 3 [from 19 instances]

Class50.getIdSet(PreparedStatement s)#1{
        ResultSet results = s.executeQuery();
}


Sample 4 [from 18 instances]

Class550.run()#1{
                            Connection con = dataSource.getConnection();
                            PreparedStatement ps = con.prepareStatement("select 1");
                            ResultSet rs = ps.executeQuery();
                            rs.close();
}


Sample 5 [from 15 instances]

Class420.getOrdersByProcess(Integer processId)#1{
        stmt.setInt(1, processId.intValue());
        ResultSet res = stmt.executeQuery();
}


Sample 6 [from 14 instances]

Class670.findOneUser(ResultSet[] results)#0{
    Connection conn = DriverManager.getConnection( "jdbc:default:connection" );
    PreparedStatement ps = conn.prepareStatement( "select id, name from t_user where name=?" );
    ps.setString( 1, "steve" );
    results[0] = ps.executeQuery();
}


Sample 7 [from 13 instances]

Class640.selectTwoSetsOfTwoAuthors(int p1,int p2,ResultSet[] rs1,ResultSet[] rs2)#1{
    Connection conn = DriverManager.getConnection("jdbc:default:connection");
    PreparedStatement ps1 = conn.prepareStatement("select * from author where id in (?,?)");
    ps1.setInt(2, p2);
    rs1[0] = ps1.executeQuery();
}


Sample 8 [from 7 instances]

Class180.testImplicitPortalClosing()#0{
    PreparedStatement s = conn.prepareStatement("select 1");
    s.executeQuery();
}


Sample 9 [from 6 instances]

Class620.testSelectWithUnaryMinusAndPlus()#1{
      JDBC.assertFullResultSet(ps.executeQuery(), expectedRows, false);
      ps.close();
}


Sample 10 [from 5 instances]

Class520.expectNullResult(PreparedStatement ps){
        JDBC.assertSingleValueResultSet(ps.executeQuery(), null);
}


Sample 11 [from 5 instances]

Class210.execute(String query,Object... params)#0{
    for (int index = 0; index < params.length; index++) {
      preparedStatement.setObject(index + 1, params[index]);
    }
    return preparedStatement.executeQuery();
}