java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]fetch: The fetch type absolute cannot be used with forward only cursors
 Technote (FAQ)
 
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.

 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): HP-UX
Software version: 4.0
Software edition:
Reference #: 1066254
IBM Group: Software Group
Modified date: Nov 20, 2003