exception

[ashish sood]

hello,

i am writing a simple program of jdbc

import java.sql.*;
class a
{
public static void main(String args[])
{
 try 
	   {
	   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	             Connection c=DriverManager.getConnection("jdbc:odbc:ash");
           Statement s = c.createStatement();
           ResultSet rs=s.executeQuery("select * from tab"); 
           while(rs.next())
           {
           String str=rs.getString(3); 
           System.out.println(rs.getString(3));
           c.close();
           }   
           }
           catch(Exception e)
           {
         System.out.println(e);
           }
}

}

however it is generating exception
java.sql.SQLException: No data found..


please help me out with it

[Jeanne Boyarsky]

Access doesn't let you call getString() twice on the same column. Try changing the code to:

String str=rs.getString(3);   
System.out.println(str); 

[sudheer yathagiri kumar]

hi,

str=rs.getString(3); here 3 means 3rd field of the table will be taken

System.out.println(str); by using this to print the value of the column and make close the connection object out side of the while loop.
while()
{

}
rs.close();
s.close();
c.close();

close the statements in reverse order .....