File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
internet detective

Joined: May 26, 2003
Posts: 30136

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

[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 .....

subject: exception
Similar Threads
How to retrieve the first record in a database table
how to improve my program code ?
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state
JDBC connection for DB2 database
Getting Table Name