Skip to Content
avatar image
Former Member

The operation is not allowed for result set type FORWARD_ONLY.

Hi,

Facing the below exception when im trying to access the ScrollableResults.first() and ScrollableResults.last(). Can any one help me out.

Does SAP HANA JDBC driver support only FORWARD_ONLY cursor ?

Caused by: org.hibernate.exception.GenericJDBCException: could not advance using first() at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: The operation is not allowed for result set type FORWARD_ONLY.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 31, 2017 at 03:10 AM

    Correct, the HANA JDBC driver only supports the FORWARD_ONLY cursor type. (checked with HANA 2 JDBC driver 2.1.2).

    Add comment
    10|10000 characters needed characters exceeded