[phplib] db_sql eats up oracle connections From: zoltan.sebestyen <email protected>
Date: 01/04/01

Hi,

 I'm developing a web+db applications which used by a company internally to
control back-end application (i.e. they haven't got the GUI of their own).
Because the internal use I made no login section/authentication for the
application, the users can use this application just by getting to the start
screen.
 My problem is the following: I use phplib's db_sql to implement the
database connectivity. As the user navigates on the pages of the
application, the number of the open database connections of the application
slowly but steadily rise.
 These connections never close and upon constant use the application eats up
all the available db connections of the Oracle 8 dbms, so that it must be
shut down.
 I would like to know how could I fix this behaviour.

Notes:
 I even tried register the database handler variable as a PHP session
variable so that at least I wouldn't have more than one connections for a
session. It didn't help I got more than one and the connections are still
alive.
 I noticed that in db_oci8.inc uses OCIplogon to connect to Oracle. This
means persistent connection. What's the reason the use this kind of
connection in PHPLIB? May be it's reason behind the problems, could someone
verify this? And if so, what are my options what can I do?
 I though of using db_sql::close(), but I never see the explicit use of it.
Could it help me out somehow?

Regards,

Zoltan Sebestyen

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>