Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
SCJP 1.4, SCWCD 1.3, SCBCD 1.3
Originally posted by Roger Chung-Wee:
Most probably your driver does not support a scrollable ResultSet.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
SCJP 1.4, SCWCD 1.3, SCBCD 1.3
Originally posted by Roger Chung-Wee:
Note that some ORACLE drivers support a scrollable ResultSet.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Originally posted by Avi Abrami:
the Oracle JDBC driver cannot create a scrollable "ResultSet" for any SQL query.
The scrollable result set implementation has the following
limitation:
- setFetchDirection() on ScrollableResultSet does not do anything.
- refreshRow() on ScrollableResultSet does not support all combinations of sensitivity and concurrency. The following table depicts the supported combinations
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Originally posted by Navin Pillu:
if we close the statement {stmt.close()} then only it is throwing such exception otherwise ResultSet is working as scrollable.
Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. It is generally good practice to release resources as soon as you are finished with them to avoid tying up database resources.
Calling the method close on a Statement object that is already closed has no effect.
Note: A Statement object is automatically closed when it is garbage collected. When a Statement object is closed, its current ResultSet object, if one exists, is also closed.
Now question is that why it is behaving like this? once i returned a ResultSet object is should be scrollable.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
javax.servlet.ServletException: Invalid operation for forward only resultset: first
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
We can fix it! We just need some baling wire, some WD-40, a bit of duct tape and this tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
|