|
Problem |
When retrieving a resultset's records (i.e.
ResultSet.next()) from a SQL query with an ORDER BY clause (e.g. SELECT
ProductName, UnitPrice FROM Products ORDER BY UnitPrice) the following
exception occurs:
java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]fetch: The
fetch type absolute cannot be used with forward only cursors. |
|
Cause |
The problem occurs with the WebSphere Branded Connect JDBC
driver, version 2.2.0016. |
|
Solution |
Use the latest version of the WebSphere Branded Connect
JDBC driver, version 2.2.0022 (or above).
Note: The WebSphere Branded Connect JDBC driver can be downloaded from
WebSphere Application Server's support website.
|
|
|
|
|
|
|