Re: Oracle Packages and Shared/Pooled connections [newbie question]

From: Paul Boothroyd <paul.boothroyd_at_ntlworld.com>
Date: Mon, 27 Jan 2003 16:46:17 +0000
Message-ID: <3E356259.5050507@ntlworld.com>

Frank wrote:
> Paul Boothroyd wrote:
>

>> (Sorry I have not had time to check this out myself yet.)
>>
>>  From the notes I have regarding PL/SQL packages, they state that 
>> variables and constants declared in both the Specification (Interface) 
>> and Body (Implementation) are defined for the lifetime of a user session.
>>
>> I believe this has some serious implications regarding the usage of 
>> connection pools from many types of client, PHP; Java; etc.
>>
>> Could somebody please forward me URL's or an outline of the problems 
>> encountered ?
>>
>> Cheers (TIA), Paul
>>

>
> I don't think a connection pool will actually use the same session
> for different request origins. I.e. if I used application screen A,
> and you did as well, that would be two sessions. Maybe using the
> same userid, but two sessions.

The difference is that I am looking to serve information to web browsers, a connection to the database will be assigned by the (PHP, Java or another Transaction Manager) Server from a pool constructed using a standard user id and password.

Between HTML requests different connections may be used for the same browser client.

[I have decided that I will avoid persistent data (i.e. the specification declared variables), it is generally considered bad practice in the OO camp.]

Cheers, Paul

>
> If not, I would not want the connection pool mechanism.
>
> Just my 2c, Frank
>
Received on Mon Jan 27 2003 - 10:46:17 CST