This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "exception" Watch "exception" New topic


ashish sood

Joined: Oct 03, 2009
Posts: 8

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

Joined: May 26, 2003
Posts: 32635

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

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
sudheer yathagiri kumar
Ranch Hand

Joined: Mar 22, 2011
Posts: 35

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.


close the statements in reverse order .....

I agree. Here's the link:
subject: exception
It's not a secret anymore!