Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
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 Badass: Making Users Awesome this week in the Game Development 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: 31634

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]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, 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