ResultSet in forward direction error

[amit sharma]

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]

It says;

ResultSet.TYPE_SCROLL_INSENSITIVE

I think that should be

ResultSet.TYPE_SCROLL_SENSITIVE

[amit sharma]

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