Sessionsquestion
Posted: 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?
(ODAC 5.5 ORACLE 9.2.0.4.0 BCB6 10.161)
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)