Sessionsquestion

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Frank_H

Sessionsquestion

Post by Frank_H » Wed 26 Jan 2005 14:38

Hi!

First: I'm on the search for the circumstances that causes an hang up of my program on sending a sql statement by your components (no error raises) this hang up occurs after a unknown time of using the prog.

I found out that my prog. uses 2 sessions, but i'm using only one OraSession component, one of the session is kicked and the other one is shown by the oracle manager after the hang up (as inactive):

the oracle system shows 2 opened session of my programm after setting OraTables to active... by what is that caused?

Code: Select all


OraSession->Connect(); //first session

  if ( OraSession->Connected ) {
    for (int i = 0; i ClassType() == __classid (TOraTable) ) {
        TOraTable *MyTable;
        MyTable = dynamic_cast (Components[i]);
        if (MyTable)
        {
            if (MyTable->Session == OraSession)            {
                  MyTable->Active = activate;
            }
        }//if (mytable)
      }//if (... == ...TOraTable)
    }//for
  }//if (Connected)

(ODAC 5.5 ORACLE 9.2.0.4.0 BCB6 10.161)

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Thu 27 Jan 2005 14:26

We couldn't reproduce your problem with program "hang up", pls. send us small demo project that illustrates it and include scripts to create server objects to ODAC support address.
As about two connections to Oracle instead one - try to disconnect TOraSession object at design-time (set Connected property in object inspector to False).

Post Reply