SAP Knowledge Base Article - Preview

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

Symptom

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

2017-04-14 11:29:06,306 INFO [com.aaa.ums.common.pm.osf.slave.query.workflow.Utilities] 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.


Read more...

Environment

Sybase IQ/15.4.0.3046/141204/P/ESD 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)

Product

SAP Sybase IQ 15.4

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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