[phplib] Oracle DB_SQL : Too many connections?? From: j.t.montgomery (j.t.montgomery <email protected>)
Date: 06/14/01

Hi All,

I have been subclassing DB_sql for convenience throughout an Application I
am writing suddenly I notice that pretty quickly it arrives at the Max
number of connections to Oracle, making it unusable in the real world.

It appears to open another persistent connection for every query I make to
the same database object :
$c = new DB(); // What I have named the subclass
$c->query( $sql );
// process results here
$c->query( $other_sql );
// process 2nd set of results...

In port Monitor :-
Remote address Local_address Protocol Status
dbserver.norcol.ac.uk:1526 localhost:1063 TCP ESTABLISHED
dbserver.norcol.ac.uk:1526 localhost:1067 TCP ESTABLISHED
dbserver.norcol.ac.uk:1526 localhost:1076 TCP ESTABLISHED
dbserver.norcol.ac.uk:1526 localhost:1078 TCP ESTABLISHED
dbserver.norcol.ac.uk:1526 localhost:1094 TCP ESTABLISHED
dbserver.norcol.ac.uk:1526 localhost:1096 TCP ESTABLISHED
dbserver.norcol.ac.uk:1526 localhost:1219 TCP ESTABLISHED
dbserver.norcol.ac.uk:1526 localhost:1225 TCP ESTABLISHED

I suspect this behaviour is wrong? If so, how to fix the situation to reuse
the connection? Or, can I close the object's connection "manually"?

Thanks for any assistance/suggestions.

:-)
John

There are two systems involved - an NT which hosts the PHPLib application,
    and a Sun System which hosts Oracle database.
    - phplib_7_2 is on both (with the local4.inc update applied to use
PHP4 native sessions)
    - php is version 4.0.4pl1
    - Oracle is a legacy Oracle7 Server Release 7.3.3.0.0 - Production
carrying
        auth_user,Active_sessions, etc.
    - Apache is Apache/1.3.14

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