|
Problem IT12106
|
Status: Closed |
WHEN AN ERROR OCCURS IN AN SPL WITH A SELECT, A -285 IS GENERATE D INTERNALLY BY THE SERVER WHICH WILL BLOCK ANY CURSORS FROM BEI
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
A Java program prepares and calls an SPL repeatedly.
An exception is raised in the SPL. As a result of this
exception, a -285 is generated in the server attempting to close
a cursor, which you could only detect if you trap for it (onmode
-I 285)
(oninit) afstack
(oninit) afhandler
(oninit) affail_interface
(oninit) check_traperror
(oninit) sqerr
(oninit) close_cursor
(oninit) sq_close
(oninit) sqmain
(oninit) spawn_thread
(oninit) th_init_initgls
(oninit) startup
Then if the application attempts to execute the prepared
statement again, the application will get a -285 attempting to
Open a Cursor
C->S (92) Time: 2015-09-24 08:44:07.38726
SQ_ID
17
SQ_CURNAME
"_ifxc000000000000f" [18]
SQ_BIND
# values: 5
0) Type.....: CHAR; NULLABLE
Indicator: NOT NULL
Precision: 0x0
Data.....: "BMMULTIMERY" [11]
1) Type.....: DATE; NULLABLE
Indicator: NOT NULL
Precision: 0x4
Data.....: 08/31/2015
2) Type.....: CHAR; NULLABLE
Indicator: NOT NULL
Precision: 0x0
Data.....: "A" [1]
3) Type.....: CHAR; NULLABLE
Indicator: NOT NULL
Precision: 0x0
Data.....: "K" [1]
4) Type.....: CHAR; NULLABLE
Indicator: NOT NULL
Precision: 0x0
Data.....: "" [0]
SQ_OPEN
SQ_EOT
S->C (14) Time: 2015-09-24 08:44:07.38727
SQ_ERR
SQL error..........: -285
ISAM/RSAM error....: 0
Offset in statement: 45
Error message......: "" [0]
SQ_EOT |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Fetch on cursor returns error and during close of that *
* cursor may return 285 error. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC7 *
**************************************************************** |
| Local Fix: |
On the client side you could prepare the statement again as a
workaround. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.11.2015
28.06.2016
28.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC7
|
| Problem solved according to the fixlist(s) of the following version(s) |
