Re: Exception: Invalid Column Name in getString() (but query works)

I'm accessing Oracle through JDBC. I've done lots of JDBC but this is
the first time with Oracle. I have a select statement that represents
a join. The query runs okay (and I've verified it in a tool outside
of Java). When I try to get a column value, however, I get a SQL
Exception: Invalid Column Name. Since I know the query works, that
makes no sense to me at all. Here's the code and info I've captured,
along with the stack trace.
try
                    {
                         conn =
DBConnectionFactory.getPooledConnection(DBConstants.DB_PS_STU);
                         stmt = conn.createStatement();
                         String countrySelect = "select distinct B.COUNTRY " +
                                                         "from sysadm.PS_EXT_ORG_TBL A,
sysadm.PS_ORG_LOC_ASOF B " +
                                                         "where A.EXT_ORG_TYPE = 'SCHL' AND A.EXT_ORG_ID =
B.EXT_ORG_ID " +
                                                         "AND B.COUNTRY NOT " +
                                                         inSqlClause +
                                                         "order by B.COUNTRY";
         logger.debug("SQL statement for get Countries(): "+
countrySelect.toString());
                         rs = stmt.executeQuery(countrySelect);
                  ResultSetMetaData rms = rs.getMetaData();
                  logger.debug("Column Name: " +rms.getColumnName(1));
                         while(rs.next()==true)
                         {

countryList.add(rs.getString("sysadm.PS_ORG_LOC_ASOF.COUNTRY"));
                         }

I've tried this as getString("STATE"), getString("B.STATE"), and
"PS_LORG_LOC_ASOF.STATE"). None of these works. They all produce the
same exception.