Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Urgent!! DB2 8.1: CLI0115E Invalid cursor state. SQLSTATE=24000

169 views

Skip to first unread message

CBB

unread,

Apr 7, 2003, 12:55:31 PM4/7/03

From my java application while executing the query:
SELECT lastupdate FROM profiles WHERE profilename = 'parser/4h04'

I got the following error from the DB2 8.1 database:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0115E Invalid cursor
state. SQLSTATE=24000

Can some one help me how to solve this??

I saw some documentation on the net asking to increase the parameter
APP_CTL_HEAP_SZ but I couldn't find this parameter on the 8.1 database
configuration

The stack trace is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0115E Invalid cursor
state. SQLSTATE=24000
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGe
nerator.java(Compiled Code))
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGe
nerator.java(Inlined Compiled Code))
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGen
erator.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2Statement.execute2(DB2Statement.java:840)
at COM.ibm.db2.jdbc.app.DB2Statement.executeQuery(DB2Statement.java:582)
..
..

thanks,
dw

0 new messages