java.sql.SQLException{resolved}

java.sql.SQLException: Before start of resultset. *** does this mean? :confuesd: I thought that my code might be positioning the pointer of the the bounds of the table stored in memory. Any ideas on what might be wrong?

Thanks.

Code:

---

import java.sql.*;

  public class SQL{
    public static void main(String[] agrs){ 

    try{ 
    int columns = 0;

    Class.forName("com.mysql.jdbc.Driver").newInstance();
 
    Connection c = DriverManager.getConnection("jdbc:mysql://localhost/test");
 
 
    Statement s = c.createStatement();
    ResultSet rs = s.executeQuery("select * from ifilms");
    columns = (rs.getMetaData()).getColumnCount();
    for(int i = 0; i < columns; ++i){
      System.out.println(rs.getString(i));
    }
  /*
    boolean more = true;
    int index = 0; 
    while(more){
      System.out.println(rs.getString(++index));
      more = rs.next();
    }
  */
    }catch(Exception e){
      System.out.println(e);
  }
  }
 }

---

Code:

---

    for(int i = 0; i < columns; ++i){
      System.out.println(rs.getString(i));
    }

---

Its been a while, but don't you have to do an initial read() (or next() or whatever it is in Java) before you can access the data?

You have to indeed.

:rolleyes: Ok ok happy now! Just kidding. :lol: I had rs.next() in the for loop before and the exception was still thrown. If the while loop is uncommented and the for loop commented it's the same result.

Code:

---

import java.sql.*;

  public class SQL{
    public static void main(String[] agrs){ 

    try{ 
    int columns = 0;

    Class.forName("com.mysql.jdbc.Driver").newInstance();
 
    Connection c = DriverManager.getConnection("jdbc:mysql://localhost/test");
 
 
    Statement s = c.createStatement();
    ResultSet rs = s.executeQuery("select * from ifilms");
    columns = (rs.getMetaData()).getColumnCount();
    for(int i = 0; i < columns; ++i){
      System.out.println(rs.getString(i));
      rs.next();
    }
  /*
    boolean more = true;
    int index = 0; 
    while(more){
      System.out.println(rs.getString(++index));
      more = rs.next();
    }
  */
    }catch(Exception e){
      System.out.println(e);
  }
  }
 }

---

Code:

---

import java.sql.*;
public class SQL{
  public static void main(String[] args){
      try{
        String url="jdbc:mysql://localhost/northwind";
        Class.forName("com.mysql.jdbc.Driver");
        Connection cn=DriverManager.getConnection(url);

        Statement s=cn.createStatement();
        ResultSet rs=s.executeQuery("select * from territories");
        while(rs.next()){
            for(int i=0;i<rs.getMetaData().getColumnCount()-1;i++)
              System.out.print(rs.getObject(i+1)+"    ");
            System.out.println();
        }
      }
      catch(Exception e){
        e.printStackTrace();
      }
  }
}

---

Sorry i locked the wrong thread. I just merged in your thread so everything should be fine. I see how it's done now. :thumb: Thanks for the help.