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

Hi,

Just one more note my letter. I noticed that everytime I access a different
page on my PHP site (i.e. do not reload the same page), a new Oracle
connection is created. If I kill the older connections it's OK, if I kill
the most recent, PHP would complain of this killed session until I restart
Apache. Any ideas?

Zoltan

> -----Original Message-----
> From: Sebestyén Zoltán
> Sent: Friday, December 08, 2000 12:08 PM
> To: phplib <email protected>
> Subject: [phplib] How to use db_Sql with Oracle 8?
>
>
> 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>
>

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