rs.next() returns true, but if (rs.next()) block not executed

[jwdvorak]

In the following method:

public boolean isMemberAlive(String userSsn) throws SQLException 
{
    boolean isMemberAlive = false;
 
    Connection c = null;
    Statement s = null;
    ResultSet rs = null;
 
    String strSQL = "SELECT Count(*) AS RecordCount " +
        "FROM crs.memmst " +
        "WHERE memmst_ssn = '" + userSsn + "' AND " +
            "(memmst_dt_death IS NULL OR 
            TRIM(memmst_dt_death) = '')";
 
    try 
    {
        c = CnxOracle.getConnection(schema, schemapwd);
        s = c.createStatement();
        rs = s.executeQuery(strSQL);
 
        if (rs.next()) 
        {
            if (rs.getInt("RecordCount") > 0)
            {
                isMemberAlive = true;
            }
        }
    }
    catch (SQLException exception)
    {
        recordException(exception);
    }
    finally 
    {
        rs.close();
        s.close();
        c.close();
 
        rs = null;
        s = null;
        c = null;
    }
 
    return isMemberAlive;
}
 

At line #21... if (rs.next()) - the resultset contains a record, rs.next() returns true (I checked using a breakpoint), but the statements in the if block are not executed. The code jumps immediately to the finally block.

This is happening in several (new) methods I've written, but older methods containing similar logic / syntax are working fine.

What is wrong???

Thanks,
Woody

[r035198x]

Perhaps an exception is being thrown. Put a println in your catch block and see if it executes.

[jwdvorak]

Nope... I put println statements in the if block and the catch block - not executing either of 'em. <sigh>

I'm playing around with Connection scoping, now... I wonder if using these similarly-named connections / statements / resultsets within multiple methods, within multiple DAO's might be introducing a conflict?

[r035198x]

Well if the code is not getting into the if for rs.next() then it means that rs.next() returned false. You made a mistake in your debugging.