java.sql.SQLException{resolved}

[Dillinger4]

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.

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); 
   }
  }
 }

[crptcblade]

    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?

[CornedBee]

You have to indeed.

[Dillinger4]

Ok ok happy now! Just kidding. 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.

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); 
   }
  }
 }

[brown monkey]

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();
      }
   }
}

[Dillinger4]

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