SQLException: no data found - i can retrieve data, but not use it

[Jon Dornback]

i'm having trouble with a jdbc-odbc connection to an access database. in a function, i call a sql query, initialize an array to the size of the query by using result.last() and then result.getRow(), and then use .beforeFirst() before i start looping through the resultset to add each row to the array. i have done this successfully before within the same program, but for some reason it is now giving me trouble. whenever i call the .getString("columnname") function and try to use the returned value as a parameter, or assign it to another variable, i get "java.sql.SQLException: No data found". code below. any help greatly appreciated.

   public Contact[] getAllIntContacts(){
      Contact contacts[] = null;
      try{
         String sql = "SELECT * FROM MeetingContact WHERE status = 'B' OR status = 'I'";
         int i = 0;
         result = stmt.executeQuery(sql); // get result
         result.last();  // go to last row
         contacts = new Contact[result.getRow()]; // initialize the array
         System.out.println("array length: "+contacts.length);
         result.beforeFirst();  // prepare to loop through resultset
         String temp = "";  
         while(result.next()){
            // the following two lines work fine: it prints out the name
            System.out.print("contactname: ");
            System.out.println(result.getString("contactName"));
            
            // this line errors out (stack trace below)
            temp = result.getString("contactName");
            contacts[i] = new Contact(temp);
            i++;
         }
      } catch (Exception e){
         System.out.println(e);
         e.printStackTrace();
      }
      return new Contact[0];
   }
// Stack trace generated by temp = result.getString("contactName");
// The same thing happens if i use contacts[i] = new Contact(result.getString("contactName"));
java.sql.SQLException: No data found
        at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)

[Jon Dornback]

i found the problem: the jdbc-odbc driver requires that the columns are accessed in order. so, if in the db, the columns are "id,name,phonenumber" and in the code you try to getString("name"),getInt("id") it blows up.

[Fred Abbot]

Hi i am having the same problem can you tellme how you got around this issue.
Thank you
Fred