SAP Knowledge Base Article - Preview

2486128 - "SQL Anywhere Error -180: Cursor not open" error happened.


When running a java program, "SQL Anywhere Error -180: Cursor not open" error happened as below.

2017-04-14 11:29:06,306 INFO [] queryID: 2017_04_14_CST_0 queryType C[0],TT[1] N[2],DM[3],TM[4],QOS[5]: 0 Execute sql: commit;SELECT TOP 100000 COL001, ...... ;commit;
2017-04-14 11:29:06,307 INFO [org.jboss.resource.adapter.jdbc.vendor.SybaseIQExceptionSorter] error_text = SQL ANYWHERE ERROR -180: CURSOR NOT OPEN
2017-04-14 11:29:06,307 INFO [org.jboss.resource.adapter.jdbc.vendor.SybaseIQExceptionSorter] erro code is:559
2017-04-14 11:29:06,307 INFO [org.jboss.resource.adapter.jdbc.local.LocalManagedConnection] this is not a fatal exception: SQL Anywhere Error -180: Cursor not open

'WITH HOLD' parameter can't be specified for this because it's not the cursor which was explicitly opened by 'OPEN' statement.



Sybase IQ/ 5/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit
java version "1.6.0_32"
Java(TM) SE Runtime Environment (build 1.6.0_32-b05)
Java HotSpot(TM) 64-Bit Server VM (build 20.7-b02, mixed mode)


SAP Sybase IQ 15.4


SAP IQ, IQ, Cursor, Cursor not found, SQL ANYWHERE ERROR -180, -180 , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.