• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

exception

 
ashish sood
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello,

i am writing a simple program of jdbc




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


please help me out with it


 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34218
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Access doesn't let you call getString() twice on the same column. Try changing the code to:

 
sudheer yathagiri kumar
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 .....

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic