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.
SAP Knowledge Base Article - Preview