I have question which is similar to this question which asked almost 10 years back. ResultSet. But there is no expected answer. If ResultSet type is forward only , you can read data in only forward direction. we can't apply absolute method on that ResultSet as per JDBC API specification . I tried sample example using Mysql databese . It allows reading ResultSet (forward only) in both forward and backward. I am able to apply absolute method . The same question is asked in Mysql forum Mysql forum .
So , I what want to know is What are the JDBC drivers which allowes both forward and backward readind data from ResultSet (forward only) ?. If a question asked in OCPJP exam of this type, Which standard we need to follow ? I mean Do we need to follow according to JDBC documentation ( or API ) ? or Do we need to follow according to specific driver implementation ?
This generally depends on the combination of a specific DB and a specific JDBC driver, so there is no general answer. I don't believe the JDBC spec says that a driver that's labelled as forward-only can't allow absolute access; it merely states it is not required to support that, and might throw an exception to that effect if you try.
You don't need to know about specific drivers for the exam.
If it is relevant, the question will tell you what you can assume about what the driver supports. For most questions:
1) The pretend driver supports everything
2) You need to know what happens under each possibility (aka that certain code could throw an exception)