File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes problem with ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem with ResultSet" Watch "problem with ResultSet" New topic
Author

problem with ResultSet

Haritha Gorijavolu
Greenhorn

Joined: Feb 18, 2011
Posts: 21

I am using the following code to get data from a database and display it.




I am getting the following output:

Magazine info:

Magazine ID:1
Magazine Name:haritha
Publisher:xyz
Frequency:weekly EXCEPTION:No data found

When I use currid instead of rst.getString(1) in the out.println() of last line of while loop, the code works fine. Why is it not working for rst.getString(1)? Please help.
Haritha Gorijavolu
Greenhorn

Joined: Feb 18, 2011
Posts: 21

I m sorry. This script was to be in a JSP. So I choose JSP. However, the problem is with the result set. I should have posted it in JDBC.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

It looks like you may be using DB2. If so, why are you using the JDBC-ODBC bridge? I would recommend using a type 4 driver instead.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem with ResultSet