my dog learned polymorphism*
The moose likes JDBC and the fly likes rs.getstring not working. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "rs.getstring not working." Watch "rs.getstring not working." New topic
Author

rs.getstring not working.

swapna jhanjhar
Greenhorn

Joined: Oct 03, 2010
Posts: 8
I'm facing one strange problem. Donno the reason for the error.
I've one jsp page where I'm showing few values from db.
The servlet returns one resultset which has (say) name and id cols.
I've one hidden field and 2 textboxes.
if i'm doing in jsp page

it's throughing error that "no data found"

whereas

tis works fine..
From this it seems that we cant retrieve value from one RS column more than once.,...
can anyone please let me know the reason...and how can i achieve the same ???
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30085
    
149

Some database drivers don't let you retrieve a column more than once. The solution is to store it in variable.

Note that it is considered horrible practice to have JDBC code inside a JSP. It is better to call JDBC from a class called indirectly from your servlet and store the results in a request attribute. Then the JSP reads that attribute.


[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
 
 
subject: rs.getstring not working.
 
Similar Threads
How to update a image using servlet?
get table values from jsp to servlet
How to retrive data two times from database in sinble jsp page.
Getting error
getParameters names from jsp?