hanging open cursors problem

From: Jan Kopinec <kopinec_at_ips-ag.ch>
Date: 1997/10/08
Message-ID: <343B6437.7A904A79_at_ips-ag.ch>#1/1


[Quoted] Hi All,

we have the following problem with our
application written in Developer 1.3.2: it needs too much open cursors because all cursors even explicit one used in one form are
just hanging on the server until disconnect no matter that the module where they have been opened and also closed is already inactive. Each newly called form adds its own cursors and so the number of open cursors can reach for example 600.

        Server options (NT Workgroup Servers V7.3.2.3.X) session_cached_cursors = 5
close_cached_open_cursors = true
cursor_space_for_time = false

        do not help as well
as forms' properties - cursor mode.

        The Developer 1.3.0 has a little bit reasonable behaiviour (it releases some cursors) but knows anybody the right solution/concept for 1.3.2(X)?

                        Thanks all, Jan Kopinec

                        kopinec_at_ips-ag.ch Received on Wed Oct 08 1997 - 00:00:00 CEST

Original text of this message