Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    61

    Unanswered: There's no current cursor - Error

    Hello,

    I'v an application that open one conection inside one while and close it a each interaction, for example:

    While i=0 to 500
    Open
    Begin '' Start Transaction

    .
    . (Several operations like Inserts, Updates, Deletes etc)
    .


    Commit '' End Transaction
    Close

    End While


    When I'v a small count (variable I) example: 100, the application work perfectly.


    The problem occours when I try 500,600 interactions, appearing the error:"There's no current cursor "

    I guess there are any configuration in onconfig, because I'm beliving that informix's droping connecting of my application for own "security"

    Someone knows a way solve this problem ?

    I tried open just one connection and open and close transactiosn in each interaction, but the result was worse.


    Att,
    Fernando.

  2. #2
    Join Date
    Oct 2007
    Posts
    61

    Text

    Hello,

    I was thinking about my problem. I'v a blob field system on that operation.. and I'm beliving the problem occour because I'v to record text field (blob) at each interaction and maybe it generate error...


    I was reading onconfig parameters and I saw DBSPACETEMP PHYSFILE TEMPS...

    If I changed that parameters, can help in a problem ?

    Thanks !

  3. #3
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Fernando,

    did you check about eventual cursors that should remain opened while you perform the transactions?
    Commit/rollback will close all open cursors unless they are DECLARED as WITH HOLD.

    Dis you check this ?

  4. #4
    Join Date
    Aug 2013
    Posts
    5
    Did you examined about ultimate cursors that should stay started out while you execute the transactions.

    marketing solutions
    Last edited by Steffanblue; 09-02-13 at 01:35.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •