cx-oracle-users

[cx-oracle-users] Connection pooling for website

[Bradley L. <Bra...@ra...>]

Is it possible to share an oracle connection pool between different 
processes? regardless of whether using CGI, FastCGI, mod_python, I still 
have to deal with multiple apache processes and it doesn't make sense to 
have each one keep its own pool. I also want to avoid gutting my entire 
database layer the way sqlrelay would require -- I like cx_Oracle.

How do other people handle this? It doesn't seem to be possible with 
cx_Oracle.SessionPool from what I can see, unless there is a way to 
initialize it with an already-created poolname?

-- 

Bradley Lawrence
Application Developer, RapiData
Rapid Technology Corporation
(403) 209-3000 ext. 237

Re: [cx-oracle-users] Connection pooling for website

[Anthony T. <ant...@gm...>]

I am not aware of any way of sharing any Oracle connection between
multiple processes. I'm not that familiar with coding in Apache but I
do know that there are ways of indicating that you want one process to
handle the request which would allow you to use a connection pool. Of
course, then you are into threading which has its own set of
issues.... :-)

On 8/29/06, Bradley Lawrence <Bra...@ra...> wrote:
> Is it possible to share an oracle connection pool between different
> processes? regardless of whether using CGI, FastCGI, mod_python, I still
> have to deal with multiple apache processes and it doesn't make sense to
> have each one keep its own pool. I also want to avoid gutting my entire
> database layer the way sqlrelay would require -- I like cx_Oracle.
>
> How do other people handle this? It doesn't seem to be possible with
> cx_Oracle.SessionPool from what I can see, unless there is a way to
> initialize it with an already-created poolname?
>
> --
>
> Bradley Lawrence
> Application Developer, RapiData
> Rapid Technology Corporation
> (403) 209-3000 ext. 237
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Connection pooling for website

[Jani T. <re...@lu...>]

Anthony Tuininga kirjoitti:
> I am not aware of any way of sharing any Oracle connection between
> multiple processes. I'm not that familiar with coding in Apache but I
> do know that there are ways of indicating that you want one process to
> handle the request which would allow you to use a connection pool. Of
> course, then you are into threading which has its own set of
> issues.... :-)

There is way to do this, but it's nothing to do actually with cx_oracle, 
but generic Python coding.

If you're running Python as CGI, you're out of luck, since it's single 
process (well not entirely true but quite close) per call.

If you're using mod_python, you've more luck with it since it's 
persistent instance of your app that is running.

One simple (generic) connection pooling that I know is implemented in 
Trac system see <http://trac.edgewall.org/browser/trunk/trac/db/pool.py>

N.B.: Trac was my first reason to get interested in cx_oracle... :)

-- 

Jani Tiainen