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


JavaRanch » Java Forums » Databases » JDBC
Bookmark "ResultSet in forward direction error" Watch "ResultSet in forward direction error" New topic
Author

ResultSet in forward direction error

amit sharma
Ranch Hand

Joined: Jul 19, 2006
Posts: 129
I get the error ResultSet accessed in forward direction when my code is this
st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=st.executeQuery(query);
rs.last();

But when i use execute() instead of executeQuery().
st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
st.execute(query);
ResultSet rs=st.getResultSet();
rs.last();
It works fine.
I create the statement scrollable then why this error.
Thanks
sinasi susam
Ranch Hand

Joined: Jul 15, 2005
Posts: 67
It says;

ResultSet.TYPE_SCROLL_INSENSITIVE

I think that should be

ResultSet.TYPE_SCROLL_SENSITIVE
amit sharma
Ranch Hand

Joined: Jul 19, 2006
Posts: 129
Even if i change scroll insesnsitive to scroll sensitive no change in error .I think scroll-insensitive result set ignores changes that are made while it is open. It provides a static view of the underlying data it contains.If that was the case then why it work when i execute query using execute method
 
GeeCON Prague 2014
 
subject: ResultSet in forward direction error