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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.