[phplib] How to use db_Sql with Oracle 8? From: zoltan.sebestyen <email protected>
Date: 12/08/00

Hi,

 I have serious problems with using Oracle 8 w/ PHPLIB 7.0.2c. I use db_SQL
by subclassing it in order to connect to a specific Oracle database. Because
every page uses this connection I've put the init sequence to a common
include file:

"
# The subclass
class DB_CNMS extends DB_Sql {
  var $Host = "...";
  var $Database = "...";
  var $User = "...";
  var $Password = "...";
}

# db init.
$db = new DB_CNMS;
"

Than use its methods like query(), next_record() etc.
What I noticed that after a while all the Oracle connections are ate up, and
I can no longer connect to Oracle, have to shut it down. The PHP-Oracle
connection remain alive - though inactive - even I no longer use'em and
accessing the PHP pages make new Oracle connections.

What did I wrong? Note that there's no session handling on these pages.

Regards,

Zoltan

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