GeeCON Prague 2014*
The moose likes JDBC and the fly likes problem in resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem in resultset" Watch "problem in resultset" New topic
Author

problem in resultset

BABUN GHOSh
Greenhorn

Joined: Apr 03, 2008
Posts: 7
In java when we open a resultset object is it only forward only?

example
out.println(rs.getString("NAME"));

out.println(rs.getString("NAME"));

but second time data is not show on broswer.
why?
my backend data base is oracle10g express edition.


Aveek
Amit Ghorpade
Bartender

Joined: Jun 06, 2007
Posts: 2716
    
    6

In java when we open a resultset object is it only forward only?

yes it is forward only.
if you want it scroll, then make a scrollable statement.

Hope this helps


SCJP, SCWCD.
|Asking Good Questions|
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18570
    
    8

However if both of those statements applied to the same row, then forward-only versus scrollable have nothing to do with your problem.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in resultset